June 23, 2008 at 7:55 am
I am trying to create a report that has a Master / Detail relationship.
For a Master record there is the following fields (ID, Name) - report is sorted by ID
For the detail portion of the report, there are many Datasets and report tables involved for the ID being processed that definitely fill up a page (ie..the report for one ID normally fills about 5 pages (8.5x11) worth of info. There are several IDs in the database and I want to run the report for all IDs at one time and place into one PDF file.
To my question/issue:
Since for one ID, there are many pages associated with it of info, is there a way to display the ID and NAME being processed at the top of every page?
I am able to do it for a version of the report where I create it for one ID by passing the ID & NAME as a parameter to the report and subsequently placing the parameters into the Report Header – but in this case I may have over 100 IDs to process. Actually, I have a little more info that I place in the Header (6 fields related to the ID) but for the sake of describing the issue, I use ID & NAME.
Any help in resolving this issue is greatly appreciated.
July 14, 2008 at 2:52 pm
Unless I'm misunderstanding your question, it seems that you should be able to manage this with groups.
-Group the report on the lowest common detail (in your case, sounds like ID),
-In the Grouping and Sorting Properties box, check Include group header, and check Repeat group header.
-If you want the page to break at the end of each ID, also check Page break at end
-Add the fields that you want repeated to the group header row
-If you need to use the group header row for your report data column headers also, right click the group header row and select 'Insert Row Below', this will keep the detail headers with the detail.
My apologies if I've grossly understated the depth of your request.
July 15, 2008 at 12:59 am
Hi Kurt,
You can use Row grouping in your table.
Add one Group for ID
Now Drag and drop ID and Name fields in Group Hearder. You can hide Group Footer.
You can place remaing fields in Detail Section.
I hope this is what you are trying about...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply