I have a subreport on my main report in the report footer. The subreport has 30 items in it but only room for 15 on the main page of the report. I cant see the other 15 records. How can I get it to print those other 15 records on the second page?
I tried that but I am required to keep the subreport from running bigger than a few inches ( it is the invoices paid on a check stub). If I do the "can grow" it runs into the space for the check. I was going to count the invoices paid on the check and
compare that to the invoices printed but I dont know how to force it to print any extras on the next page.
For example 15 invoices paid. My area for the subreport can fit 12. I am not sure how to write the formula to force the remaining 3 to print on the next page.
Dear you insert again footer section(b) by right click on footer -> insert section. in this above footer section. you set your subreport and set "can grow= true" to subreport and footer section(b). and just check preview.
When I put the subreport in the details section it repeats (how ever many times there is a record) Can I get around it by not using a subreport and putting 12 detail sections? If so how do I get it to go to the next page if the check has more than 12 records?
I check new page after and put the formula as @recordprint>12 but then all the next record print on a seperate page (3 pages with one record on each page for 15 total records) How can I get all 3 on one page?
When I put the subreport in the details section it repeats
you are adding wrong section ( see my first comment in this form) . you must add page footer or group footer section below details section ( It show footer(b) after adding).
and in new footer or group footer, put subreport into it.
Then can-grow option set to true for both.
Give page margin for footer by report option. (right now I don't have report installed, just chekc it what is exact to set margin)
So whenever go to further beyond in single page, report automatically push in second page. You always check preview also.
I was able to get it to go to the next page. I have 2 subreports in the report (both in group footers). How can I get both to go to next page if necessary? Also how can I get them to hold their place on the next page? (for example at the bottom of the
page rather than the top)
k.reusch
0 Points
7 Posts
View all records in a subreport
Feb 15, 2013 06:06 PM|LINK
Hello,
I have a subreport on my main report in the report footer. The subreport has 30 items in it but only room for 15 on the main page of the report. I cant see the other 15 records. How can I get it to print those other 15 records on the second page?
Thanks in advance
Ajay2707
Contributor
4487 Points
870 Posts
Re: View all records in a subreport
Feb 16, 2013 06:39 AM|LINK
Hi ,
set "can grow= true" for footer and sub-report and also in data-section in sub-report .
k.reusch
0 Points
7 Posts
Re: View all records in a subreport
Feb 17, 2013 07:32 PM|LINK
Thanks for the response.
I tried that but I am required to keep the subreport from running bigger than a few inches ( it is the invoices paid on a check stub). If I do the "can grow" it runs into the space for the check. I was going to count the invoices paid on the check and compare that to the invoices printed but I dont know how to force it to print any extras on the next page.
For example 15 invoices paid. My area for the subreport can fit 12. I am not sure how to write the formula to force the remaining 3 to print on the next page.
Ajay2707
Contributor
4487 Points
870 Posts
Re: View all records in a subreport
Feb 18, 2013 08:32 AM|LINK
Hi K.Reusch,
Dear you insert again footer section(b) by right click on footer -> insert section. in this above footer section. you set your subreport and set "can grow= true" to subreport and footer section(b). and just check preview.
k.reusch
0 Points
7 Posts
Re: View all records in a subreport
Feb 18, 2013 07:04 PM|LINK
Hi Ajay2707
How do I stop it from growing into the section below it? I want it to go to the next page rather than grow further down the first page.
Thanks
itityagi
Member
489 Points
193 Posts
Re: View all records in a subreport
Feb 19, 2013 01:09 PM|LINK
Try adding another detail section in the main report and then place the sub report in the same.
k.reusch
0 Points
7 Posts
Re: View all records in a subreport
Feb 22, 2013 01:11 AM|LINK
When I put the subreport in the details section it repeats (how ever many times there is a record) Can I get around it by not using a subreport and putting 12 detail sections? If so how do I get it to go to the next page if the check has more than 12 records?
Thanks for the help
k.reusch
0 Points
7 Posts
Re: View all records in a subreport
Feb 22, 2013 01:23 AM|LINK
I check new page after and put the formula as @recordprint>12 but then all the next record print on a seperate page (3 pages with one record on each page for 15 total records) How can I get all 3 on one page?
Ajay2707
Contributor
4487 Points
870 Posts
Re: View all records in a subreport
Feb 22, 2013 11:39 AM|LINK
Hi K.Reusch,
you are adding wrong section ( see my first comment in this form) . you must add page footer or group footer section below details section ( It show footer(b) after adding).
and in new footer or group footer, put subreport into it.
Then can-grow option set to true for both.
Give page margin for footer by report option. (right now I don't have report installed, just chekc it what is exact to set margin)
So whenever go to further beyond in single page, report automatically push in second page. You always check preview also.
k.reusch
0 Points
7 Posts
Re: View all records in a subreport
Feb 23, 2013 07:57 PM|LINK
Thanks,
I was able to get it to go to the next page. I have 2 subreports in the report (both in group footers). How can I get both to go to next page if necessary? Also how can I get them to hold their place on the next page? (for example at the bottom of the page rather than the top)