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

Subreport

Status
Not open for further replies.

michelle1981

Programmer
Jan 7, 2005
4
RO
Hi!
Is there any way that i could do the following in a report:

Page Header
Details a
-Subreport 1
Details b
-Subreport 2
Page Footer

If Subreport 1 has:
Report Header
Details
Report Footer

and the Report Header (from Subreport 1) must repeat on every page from report Subreport 1.

Is there any formula or adjustement to do that repetition?

Thanx in advance.
 
Within the subreport, create a formula that is true for all records, e.g.:

{table.ID} > 0

Group on this formula and check "Repeat group header on each page". Then use this group header as your page header.

-LB
 
Thank you for your message, i had that option in mind, too, but in the header of the subreport there is only a drawing: lines and text objects.

The problem is i dont't have a field to group by.

Is there any posibility?
Thanks in advance.
 
What's in the subreport report header is irrelevant. For the formula, you could use any field in the subreport that appears for all records, or you could use a formula like:

whilereadingrecords;
1

Insert a group on this and check "Repeat group header on each page" and then drag your report header fields into this new group header.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top