By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,658 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,658 IT Pros & Developers. It's quick & easy.

Sub Report Data showing as seperate page for each Record

100+
P: 171
Hi,
I have a report with only a header and a footer, I want to put a sub report in as the reports detail, the sub report has 3 records and then a Sum at the end, for the sum I have created a sorting and grouping group called "0" and the sum is in "=0 Footer". I then put the sub report in the Detail section of the main report, when I run the Sub Report separatley, it shows as 3 records in the report, but when I run the main report including the sub report in the detail section, it shows each record in a different page? I would like the 3 records to appear on the same page of the main report same as they are coming up in the sub report.

Thanks
Jun 22 '09 #1
Share this Question
Share on Google+
7 Replies


NeoPa
Expert Mod 15k+
P: 31,712
You haven't actually told us any of the settings that control page separating for any of your objects.

I'm not sure if this is relevant (too little info) but I'm also not sure about creating a "0" group when you already have a report footer. Maybe you could explain your rationale for this too.
Jun 22 '09 #2

100+
P: 171
Hi NeoPa...Page separating? To tell you the truth I have no idea of what I'm doing, the only reason I created the "0" group was because I read on a forum that I would be able to see the Footer and Header of a sub report in the main report that way. Where should I get the page separating controls information from?
Jun 23 '09 #3

NeoPa
Expert Mod 15k+
P: 31,712
That may be true, but I would expect the report header and footer to work in a similar way and provide the acces you need. I've never tried explicitly with subreports though.

For each section (other than Page header & footer themselves) there are properties called Force New Page & Keep Together.
Jun 23 '09 #4

100+
P: 171
Oops, I wasn't looking in Print Preview, In Print Preview, the report was running properly. Doh!
Jul 23 '09 #5

NeoPa
Expert Mod 15k+
P: 31,712
Can I take that to mean all is hunky-dory now?
Aug 3 '09 #6

100+
P: 171
Yes, all fine now. Thank You
Aug 3 '09 #7

NeoPa
Expert Mod 15k+
P: 31,712
Excellent.

Come back if you need more help :)
Aug 3 '09 #8

Post your reply

Sign in to post your reply or Sign up for a free account.