Click here to Skip to main content
15,947,958 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi there...I'm hoping you can help me.

I am using Crystal Reports 2011. In my report, I have grouping based on a certain field. I want the details for that group to display certain columns based upon the data in the field that the group is based on.

For example, if the Grouping field is 'CON' I want the columns as follows:

Location Material Notes

If it's 'FRAM' display:
Item Description

If it's 'HDSFC' display:
Description Type Splash Application Edge Group

And so on...

There are over 20 options that can all be on the same report at once (possibly 20+ groups appearing on one report).

The groups I'm OK with, but how on earth do I get it to display columns conditionally? Any help would be GREATLY appreciated.

UPDATE: I figured out how to get certain columns to display by doing mulitple groups/sections. However, they are all going to use the same footer, and the fields that show up need to be suppressed based on a certain criteria (the value of a certain field).

I tried doing 'is not in' and all of the values that I want to display with that field, but it's giving me an error that "the remaining text does not appear to be part of the formula".

{FieldName} is not in ('CON', 'SID')
Updated 24-Jun-15 13:19pm

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900