Sorting

rbuser

How do we allow end users to determine sort orders within reports? We are
using RB Enterprise.

Peter Knapp

nicocizik

Hi Peter,

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.

--

rbuser

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?

nicocizik

Peter,

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.

--