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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subreport in Report Header won't grow

Status
Not open for further replies.

ThePixelMines

Technical User
Jun 6, 2007
17
US
I've got a subreport in my report header that will only display the first entry of the subreport.

To see the relationship among tables click here.

My report works like this:
The report header is to have a monthly summary of my department's billing. At the end of the header I forced a new page and every page after shows the invoice for each client. All of these are pulled from an 'End Date Range' The subreport (connected by Project ID) displays fine by itself but when put in the report header only displays the first entry. The subreport is simply a query of every ProjectID, ProjectName, ClientID, ClientName, Total Charges of project, and all client credits.

My subreport is set 'yes' for 'Can Grow.'

Any other clues?

Check it, Fool!
 
Set the Report Header Can Grow to Yes as well and you should be good to go.

If for some reason it doesn't work (sometimes the report and page sections do odd things) I would add another grouping say for department (even if you have to add it to the query as a literal) and then put the subreport in there instead AND set that section's Can Grow to Yes.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top