start new page for each grouping with a sub report

[espltd]

Hi I am using a main report and then have a subreport on it with a .net web application. In the subreport I would like to have each new grouping be on its' own page. Just wondering if there is a way to do this. Also with the subreport when I tried to add a page header section it did not seem to be available. Thanks.

 

[synapsevampire]

Subreports don't have page headers, they observe the Main Report page headers.

You can create a faux page header:

http://support.businessobjects.com/library/kbase/articles/c2005103.asp

Anyway, you can have a new page for each group by right clicking the group header section of the subreport and selecting format section->New Page Before

-k

 

[espltd]

Hi thanks for the quick response. I am using version 9 of crystal reports. When I right click on the group header do not see select format section, there are selections such as hide, suppress, section expert, show short sectin names, ect. Am I in the correct area?

 

[espltd]

Hi got it to work just went tothe section expert, thanks. Just wondering if you know if there is a way to suppress stuff on the main report based on what is returned in the subreport? Thanks.

 

[synapsevampire]

Yeah, since you didn't post your software version (please remember to always do this), I used CR 8 terminology.

You can pass variables from main<->subreports byt using shared variables.

Once the subreport has fired, you can use it in the main report, and example is:

subreport formula:
//@MyValue
whileprintingrecords;
shared numbervar Somevalue:= sum{table.value});

Then in a formula in the maqin report, again AFTER the subreport has executed, you can reference it's values, as in:

Main Report formula:
//@MyValue
whileprintingrecords;
shared numbervar Somevalue;
somevalue < 1000

so this would work as a suppress formula for sections after the subreport.

Stating that you want to "suppress stuff" isn't meaningful, please take the time to what you specifically need.

-k

 

[espltd]

ok thanks for the reply. I probably should have been more specific, I want to suppress text objects in the main report, looks like I can do that with the information you provided.