My apologies initially as I know the answer is in the forums already but I could not find anything that perfectly applied to my situation well enough to allow me to figure it out with some trial and error.
I am new to Crystal Reports and am learning. I have watched the videos on YouTube and read many of these forums. Let me describe my problem:
I am using a report that comes with some software called FabSuite. They use Crystal Reports to make the reports for their system. I have a report I want to modify. The report has 10 fields that are listed with a header row and are columns. There are over 1800 rows at this time. The first two fields (or groups) are commonly used but do have 10 different types in the field. My report looks like this :
Shape Grade Qty Dim Length
TMW SA210 14 2"x.105 20'
TMW SA210 10 2"x.125 15'
TMW SA178A 24 1"x.150 12'
PL A36 10 1"x 48 20'
PL C 14 10x53 15'
I want it to take the shape column and place each shape on a separate page. I want the pages to look like this:
Qty Dim Length
SA210
14 2"x.105 20'
10 2"x.125 15'
SA178A
24 1"x.150 12'
_______________________
New page due to new shape
Qty Dim Length
A36
10 1"x 48 20'
_______________________
New page due to new shape
Qty Dim Length
C
14 10x53 15'
I have tried several variations of suppressing and grouping to no avail. I have made new headers and that also was unsuccessful. I would like to not create a whole new report from scratch if possible. I would be happy to post the file if needed to look at what is there as well.
Thank you in advance for any help on this.