Sub Report

MikeC · Post by **MikeC** » Fri Jun 11, 2010 11:50 am

I have a report that is basically 2 reports in one. The first (top) portion contains data regarding total values. The lower portion of the report contains summary data regarding exemptions. I think it's the perfect case for a sub report for the exemption data.

I have a report summary band for some totals, and under that I'd like to start my sub report. The summary band is not set to print at the bottom of the page, rather I want it to float under the group footer.

I don't want the sub report to start over on another page, just wherever the previous group footer stops the sub report should start. How do I set the sub report to start showing right after the summary band rather than starting on a new page?

Post by **Andrew** » Mon Jun 14, 2010 2:53 am

Hello,

Could you, please send us more detailed information about your request.
What are the exemption data?
What is the structure of your report?

Thank you.

MikeC · Post by **MikeC** » Mon Jun 14, 2010 8:04 am

I have 2 tables linked to the report with completely different data. For the first table, which will be the top portion of the report, I have a group header band linked to table #1, a header band, a data band linked to table #1 (no data since I'm only doing total information, a group footer band with summary information for each group, and a report summary band for totals of all groups referenced in the group header band.

I would like to have the first appear, including the totals in the summary band, and then the 2nd report (linked to table #2) should start right after the summary band.

I thought I could do it with a sub report placed after the summary band, but that doesn't seem to work as I'd expect it to.

So when I preview the report I want to see the first report run, and then after my summary totals I want the 2nd report to start.

Post by **Ivan** » Mon Jun 14, 2010 9:08 am

Hello,

We understand what you need to do. In our product the number of Data Bands is unlimited and each of them may have its own data source that is not related to others. You can without any problems to place your data bands on one page.

Please see the attached sample of a report. GroupHeaderBand1, DataBand1 and GroupFooterBand1 output records of the first datasource. GroupHeaderBand2, DataBand2 and GroupFooterBand2 output totals for the first datasource. DataCategories output records of the second DataSource.

Also, please watch video tutorials at http://stimulsoft.com/Videos.aspx

Thank you.

MikeC · Post by **MikeC** » Mon Jun 14, 2010 2:57 pm

I did figure out how to get the grouping and flow correct, but I'm having an issue with the vertical size of the layout area. I have some summary information that I need to add at the end of the report, but the vertical size of the layout area won't allow me to add any more bands. How can I increase the vertical size of the layout area?

I looked in the documentation but couldn't find anything about it in there.

Post by **Ivan** » Tue Jun 15, 2010 2:28 am

Hello,

Please set the LargeHeight property of Page to true, and modify the LargeHeightFactor property if necessary.

Thank you.