Multiple Crosstab acros report behaviour

rbuser

Hi!
In your demos all crosstabs are placed in detail band. When I put crosstab
in detail band I get multiple crosstab (depend on how many detail records
are in dataset) instead of one.
Can you help me please (RB 7.03 on D7 EE)
Regards,
Benjamin Vadas

The difference between theory and practice is that in theory there is no
difference between theory and practice, but in practice there is....

nardmoseley

You need to set the Report.DataPipeline to nil (). The detail band
will print once for each record in the Report.DataPipeline. Then the
crosstab will traverse the Crosstab.DataPipeline and build a crosstab.

Try using the Crosstab wizard and it will configure the report properly for
you.


--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi!
Is that the same for EURExplorer work? I.e. when .exe is fixed and on client
side user want to create one crosstab, is that possible to change?
If is, please how?
THX!

nardmoseley

I do not understand the question. Yes, ReportBuilder works the same for the
end-user as it does for the Delphi developer.

Simplest way to create a crosstab is to use the crosstab wizard. But you can
easily do it manually as well. Create a new report. When the Data workspace
is used to create a query, RB will internall set the Report.DataPipeline to
the first query that you create. However, from the Design workspace you can
select Report | Data and use the dialog set DataPipeline to . Then
connect the crosstab to the data.

If you have a master/detail relationship you can connect the
report.DataPipeline to the master and connect the crosstab to the detail.
Then the report will produce a crosstab for each master record.



--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Now is clear....
THX!