Crystal Report - Formatting Question regarding adding ID to each page

Rhonda Oakley 2

I am working on the annual statements canned report and need to add the system record ID to each corresponding page. I have exported the information into crystal report and I know where the data lives and I know that I need it on the top left of every corresponding page. I have placed it as far to the top that I can get it. The first page is correct but then it takes the first ID and puts in on the next corresponding page therefore making all the IDs off. Can anyone assist with what I am doing wrong?


 

Chester Bammel

Hi Rhonda,

​If you are talking about what I think is happening, that won't work on pages.  What if the ID changes in the middle of the page, or after the very first record of the page?  The ID would be correct for that first record, then wrong for all the rest.

You need to create a group for the ID and place that into the Group Header.  The ID cannot print on the page header for the above reason.  It will, however, print correctly at the beginning of every change of group.

Let me know if I missed the boat on what your issue is.


​

Rhonda Oakley 2

Chester Bammel:

Hi Rhonda,

​If you are talking about what I think is happening, that won't work on pages.  What if the ID changes in the middle of the page, or after the very first record of the page?  The ID would be correct for that first record, then wrong for all the rest.

You need to create a group for the ID and place that into the Group Header.  The ID cannot print on the page header for the above reason.  It will, however, print correctly at the beginning of every change of group.

Let me know if I missed the boat on what your issue is.


​

So is that an easy fix? Can you walk me through that?

 

Rhonda Oakley 2

Or even better does anyone know how to export the information into a word file or an excel file then I could use a mail merge to get the code onto the form?

Chester Bammel

Sure.  I'm glad to help.

• ​With the report open in the Design tab, click on the field that you want to make the group. 
• In the menu across the top of the page, select Insert, and then Group from the drop-down
• The Insert Group dialog box should come up with the field already selected.  If that field is not selected you can use the dropdown to select it from the list.
• Choose sort order, or accept the default ascending order and click OK.
• You will notice the new group listed, but it will be at the lowest group level.  I don't know how many groups you already have - if any.  If you have no groups, it will be Group #1, which is fine.  If you for instance already have 2 groups, then the new group will be Group #3.
• Decide which group level it needs to be.  If it needs to change to a higher level, yu can simply grab the group header on the design bar at the left and drag it up.
• Run the report and if that is not right, you can always move it up another level or move it back down.

​I am not familiar with the specific report you are using, so I'm just giving you general information.


Let me know how it goes.