ReportBuilder simply traverses the data you provide, it will not sort the data for you. All sorting must be done in the dataset before the report is generated.
Surely selecting a sort order is a fundamental of a report generation? How can we distribute an end user version of a 'report generator' where they cannot independently determine the sort order of the report? This would mean we have to compile all users reports for them in the IDE. We must have mis-read the marketing materials on RAP, we thought it could allow uses access to events etc without a design time IDE. Have we missed something?
Sorry for the missunderstanding. It is possible to give your users the ability to change the sort order of a report however this must be done before the report is generated (previewed/printed). Using RAP, it is possible to gain limited access to your datasets before the report generates using the BeforePrint event or OnGlobalCreate. Usually a rule of thumb for RAP is to figure out how you would implement something first in Delphi, without the use of RAP. Then once this is working, try moving it to RAP, creating the necessary pass thru functions if needed.
Alternatively, giving your users access to the Data workspace (DADE) allows them to create, search, and sort the data any way they like. This can also be done using the Query Wizard in DADE. The Query Wizard can be customized or replaced to your needs.
Comments
ReportBuilder simply traverses the data you provide, it will not sort the
data for you. All sorting must be done in the dataset before the report is
generated.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
can we distribute an end user version of a 'report generator' where they
cannot independently determine the sort order of the report? This would
mean we have to compile all users reports for them in the IDE. We must have
mis-read the marketing materials on RAP, we thought it could allow uses
access to events etc without a design time IDE. Have we missed something?
Sorry for the missunderstanding. It is possible to give your users the
ability to change the sort order of a report however this must be done
before the report is generated (previewed/printed). Using RAP, it is
possible to gain limited access to your datasets before the report generates
using the BeforePrint event or OnGlobalCreate. Usually a rule of thumb for
RAP is to figure out how you would implement something first in Delphi,
without the use of RAP. Then once this is working, try moving it to RAP,
creating the necessary pass thru functions if needed.
Alternatively, giving your users access to the Data workspace (DADE) allows
them to create, search, and sort the data any way they like. This can also
be done using the Query Wizard in DADE. The Query Wizard can be customized
or replaced to your needs.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com