Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Grouping data and having summary totals in Crystal Reports

I am using Crystal Reports 2011.

Attached is an example report I need to create in Crystal Reports.

The detailed data needs to be grouped a certain way with Group name and group field data together surround by a rectangle.  Note the data in the attached report in a drawn rectangle like Supplier Code.  I need help on how to format the Crystal Report exactly how the attached report shows.

Please help!

Thanks!

Sincerely,

Keith Jackson

Tags:
replied

Hi Keith,

it sounds like you have most of the report laid out, just some tweaking to make it look the way you want.

The column titles are easy.  I'm going to guess your groups are arranged like:

Group1 Supplier Code

Group2 Master ID

Group3 Tracking No

Group4 Coil No

Group5 Coil Weight

Group6 CL Date

Hide all the Group Header sections below Group2.  So you should see only the Supplier Code, which you want and the Master ID.  Now move the Group information from the other groups into the Master ID group header.

This should get you close to what you want.  It may need some more tweaking depending on how your data is sorted but give it a try.

Good luck,

Brian

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question