Grouping on fields that have more than one value entered. Please need help fast!!!

[Former Member]

Post Author: DennisC

CA Forum: General

I am creating a report that is to be grouped on a particular field that can have more than one entry. My user said they did not care how I did it but to only count the record one time. The field that is selected is a dropdown on an form that is in Alpha order. So the entries always appear in the the field in alpha order. This is for use as an example: Record 1 has a value of CAT in the field, Record 2 has a value of CAT, DOG in the field and Record 3 has a value of CAT, DOG, HORSE in the field. I get 3 separate groupings for the 3 records.

Group = CAT

Then the detail information appears here

Group = CAT, DOG

Then the detail information appears here

Group = CAT,DOG,HORSE

Then the detail information appears here

What is would like to see using this example is one group for CAT with all 3 records appearing under it and ignore the other two. This way there would all be getting counted but the report would look a little more streamlined.

Group = CAT

record 1 detail information

record 2 detail information

record 3 detail information

thanks in advanced for any help!!!!

[Former Member]

Post Author: shawks

CA Forum: General

Instead of saying this is generating two reports I should have said there are two separate groupings - one for Xsub2 and one for Xsub4 - on the same report. What I would like is one report with the data for Xsub2 and Xsub4 combined (not separated into groups).

[Former Member]

Post Author: shawks

CA Forum: General

Yes, there is grouping being used on X which is leading to the two reports. In most cases this layout is fine. In this case though I do not want the data for the two X values separate. I want them on the same report. So for example, if there is a total on the report it is not the total for the one X value on one report and the other X value total on another report I am looking for. I want the total for those that match both X values to appear one report.

[Former Member]

Post Author: V361

CA Forum: General

Shawks, how is the db designed, are you using subreports, or grouping on ???, not sure why you are getting two reports unless the report was designed to run that way.

[Former Member]

Post Author: shawks

CA Forum: General

I am trying resolve the same/similar issue in Crystal Reports 10. For example, on a table there is a column called X with values Xsub1, Xsub2, Xsub3, etc. The user can select a parameter that includes Xsub2 and Xsub4. If this is selected 2 reports are generated (one for Xsub2 and Xsub4). What we really want is one report with the combined information for Xsub2 and Xsub4. How is (or is it) possible to do this in Crystal Reports 10? FYI - When the report was initially created the main body of the report was placed in the Group Footer so if the Group Footer is suppressed the content of the report is suppressed, too.

Thanks

[Former Member]

Post Author: V361

CA Forum: General

What version of CR are you on ?, if CRXI, look at the samples, you will see something close to this. IE: Dynamic Pick Lists.....