Home Subreports
New Blog Posts: Merging Reports - Part 1 and Part 2

Crosstabs / Sub Reports

edited September 2003 in Subreports
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

Comments

  • edited September 2003
    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


  • edited September 2003
    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.

  • edited September 2003
    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


  • edited September 2003
    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


  • edited September 2003
    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


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


This discussion has been closed.