Crosstabs / Sub Reports

rbuser

I have a report that lists some sales info using one query
I want a crosstab at the bottom summarising the info using another query
I have created a sub report and set it's data to the summary query
On the title band of the sub report I have placed my crosstab
The subreport I have placed in the summary band of the main report

It wont work.
Tried all combinations of footer/summary I can think of.
What is the best way to do this

Regards
Rhonda Ridge

digitalmetaphors

Hi Rhonda,

In the main report, use the summary band to place the crosstab. The crosstab
has its own data traversal engine and will traverse all the records you
connect through the summary pipeline. There is no need to place it in the
subreport. If you want to place a subreport in the summary of the main
report too, then the crosstab and the subreport should be in the main
report's summary band and use the ShiftRelativeTo property to have them
print correctly one after the other.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

How do I connect the crosstab to different pipeline to that used by the main
report. Thats' why I put it on a sub report.

I can't use the main report pipeline as the data here is slightly different.

digitalmetaphors

The crosstab has its own data pipeline property. Simply set that after you
set the pipeline on the main report. Once you set the pipeline on the main
report, by default, the crosstab gets assigned to the same pipeline when you
create the report and when you disconnect the main report's datapipelin
property, the crosstab's pipeline assignment is cleared out as well. This is
intentional for RB components when ParentDataPipeline is true.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Sorry if I am being dense here but I cannot find where I assign this in the
crosstab.
I can do it in RAP of course but I need to do it in the Design Tab itself to
be able to configure the rows and columns.
Thanks

digitalmetaphors

Hi Rhonda,

In the designer, when you select the crosstab component, the drop down box
should appear on the toolbar so that you can select the datapipeline, just
as you would do for a subreport in the designer. You could also use the
object inspector to set the datapipeline property at design time.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Great thanks Jim, never noticed that there and have always set the sub
reports by Report Data option when on the sub report page.