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!

Group Header and Details

Status
Not open for further replies.

tdf2437

Technical User
May 15, 2015
5
US
I currently have a Group Header 1 and Details 1 toward the top of the page. I would like to create an exact duplicate of each one of these areas and place them within the middle of the page. In other words, the same information that shows on the top of the page, is also in the middle of the page. Could someone suggest what I could accomplish this task. Thanks
 
Does the group header change on each page? If so just put the field or formula that you're grouping on into the group footer. If not you might need to put it into a new detail section and suppress that section if duplicated.
I hope that helps.
 
The group header does not change on each page. This report is only meant to be a one page report, always. If I add a new detail section, how would I also have the second group header show right above it?
 
The Group Header will always be above Details 1. How many groups do you have?
 
only one at the top, and some way of duplicating it and putting it in the middle.
 
Assuming I have understood the question properly, you want the GH and Details to show at the top of the page and be repeated in the middle of the same page.

The simplest way to achieve this wold be to replicate the report and insert it as a sub-report within the original version, and link the parameters if there are any.

This is not a very efficient approach as the report will need to query the database twice. Depending on what is being shown in the Details section (number of fields and number of rows), an alternative approach may be to repeat the GH field(s) in the GF, and use Variable(s) to replicate the Details.

Hope this helps.

Cheers
Pete

 
You will probably also need to suppress the detail section in the sub report.
 
I disagree LaurieHamlin. The whole reason for using the Sub Report approach was so as to repeat the details section.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top