I have a report which is based on a table which doesn't have a primary key by design. One of the key fields in the table is one called Claims ID, there could be several records with the same Claims ID. I need a report that keeps all of the records with the same ID on one page however I am having an incredibly difficult time doing so. Can anybody help me?
Reports problem
- Thread starter mlamont
- Start date
DBL
Registered User.
- Local time
- Today, 15:06
- Joined
- Feb 20, 2002
- Messages
- 659
Open the report in design view. One the toolbar you have a button called Grouping and Sorting. Click that and you get a little pop-up window. Select Claim ID from the combo box and change the Group Header from No to Yes. Put your Claim ID field in the space under the the Claim ID Header bar and put all the other fields in the space under the Detail bar. Run the report and it should group all the data together for the same Claim ID
Just to add a little more to that, you may also wish to change the value in the 'keep together' option to whole group. This will mean that if a group begins half way down the page but goes over to the next, the whole group will be forced to the next page.
However, if an ID group is small enough to fit on a page with another ID group it will.
If you wish to only show one Claim Id group per page, use the force new page option in the group properties. This will mean that the claim ID will always start on a fresh sheet.
However, if an ID group is small enough to fit on a page with another ID group it will.
If you wish to only show one Claim Id group per page, use the force new page option in the group properties. This will mean that the claim ID will always start on a fresh sheet.
Similar threads
