I have 2 subreports in my Report. There is enough data to spill over to the second page. However when I print preview, the second page just prints the heading for the subreports, not the data. Also the next record is blank with only the headings. It's like it only wants to print the first page. Is this something wrong with subreports or the software?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data not being displayed
- Thread starter lactbc
- Start date
lactbc
Subreports are pretty standard stuff, so the problem shouldn't be there.
Is it possible that you are driving the report from a form and you have a line behind the command button that closes the form, and the form is therefore closing before the report has a chance to display the second page?
Tom
Subreports are pretty standard stuff, so the problem shouldn't be there.
Is it possible that you are driving the report from a form and you have a line behind the command button that closes the form, and the form is therefore closing before the report has a chance to display the second page?
Tom
- Thread starter
- #3
Thanks for the reply,
I redid the whole report again. Yes, I'm using subreports from the subreports within a form. It's a clean insertion without any other lines or buttons. The first record looks exactly how I want it. It spills over nicely to the 2nd page. But the 2nd record is still displaying blank data. So I decided to add a couple of more records. But it seems only the data for the 1st record gets displayed. The rest of the records thereafter are blanks with just he headings. What the heck could it be?
I redid the whole report again. Yes, I'm using subreports from the subreports within a form. It's a clean insertion without any other lines or buttons. The first record looks exactly how I want it. It spills over nicely to the 2nd page. But the 2nd record is still displaying blank data. So I decided to add a couple of more records. But it seems only the data for the 1st record gets displayed. The rest of the records thereafter are blanks with just he headings. What the heck could it be?
lactbc
I'm not sure what you mean by "I'm using subreports from the subreports within a form."
Your main report should be built on either a query or table. Then your subreport needs to be linked by the appropriate field, so that you get one subreport for each record in the main report.
Without knowing a little more about how you are set up, I don't know what further to suggest.
Tom
I'm not sure what you mean by "I'm using subreports from the subreports within a form."
Your main report should be built on either a query or table. Then your subreport needs to be linked by the appropriate field, so that you get one subreport for each record in the main report.
Without knowing a little more about how you are set up, I don't know what further to suggest.
Tom
- Status
Similar threads
- Locked
- Question
