Repeating crosstab

rbuser

Hi all,

I'm using crosstab component to make my report. On the report whole crosstab
component data is repeating itself so instead of two pages I got 50 pages
and I simply can't figure out why. Only when I put something specific (both
must be optional) in both row and column field to search, then crosstab is
not repeating itself. Unfortunatelly that is not the solution because I want
my client to be able to have whole dataset not just one record.

Thanks in advance

Josko

P.S. If my English is bad sorry.

nardmoseley

Try setting Report.DataPipeline to nil (none).

A report will generate one detail band for each row in the datapipeline to
which it is assigned.


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

rbuser

I can't do that because if I set my Report.DataPipeline to nil than I get
that crosstab component looses its dataset and no data at all would be
printed.

rbuser

I've put the crosstab component on the summary bend and it works fine now. I
put it in the detail band originally because this is where in the demo
example the crosstab was placed. I still don't understand why in the demo it
works fine (no repeats of crosstab component) placed in the detail band.

nardmoseley

Try the following steps:

1. Open crosstab demo 127 in the report designer.

2. Set Report.AutoStop to False.

Now preview the report and notice that it generates 600 plus pages.

Return to the Design workspace and try the following:

1. From the main menu, select Report | Data to display the dialog and then
select '' and press OK to close the dialog.

(When you set the Report.DataPipeline property, the data-aware controls that
have ParentDataPipeline set to True, will also be updated, thus the
crosstab.DataPipeline is now unassigned).

3. Select the Crosstab and assign the DataPipeline.

Now preview the report and it will work correctly.


I prefer this latter configuration because it is simpler to understand.
Either configuration will work.









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

rbuser

When I open crosstab demo 127 in the report designer I simply don't see the
Report.AutoStop option.
Am I looking in the wrong place or do I have to add something in uses clause
in Delphi in order to be able to see it.
I've got ReportBuilder Enterprise Edition Version 7.03 and Delphi 5. Thanks
in advance.

Josko

nardmoseley

1. Open the report in Delphi IDE. Then use the Delphi object inspector.

2,. For RB 9 we added an object inspector to the ReportDesigner and that
shows the property as well.

3. Normally the AutoStop property is handled for you. When a DataPipeline is
assigned then AutoStop is sutomatically set to False, and vice versa.

You will notice that if you use the Crosstab wizard to create a report it
configures the report to have no datapipeline assigned and the crosstab to
be connected to the datapipeline.


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