Custom Selection of fields in Crystal reports

[jonav]

Hi,

I have a requirement similar to thread149-655589 but would like to get the fields in one parameter and User can select fields they want to display on report.

?{Praram} should have list of values
Deal
IP
Territory
Media Language

How to get these values into Parameter and user select accordingly to display on report.

each Values in Paramter will have a technical name
like Deal has Deal Key, IP had IP# Key, Terrotry with Territory Medium Name.

Pls help.
Thanks

 

[lbass]

If the order of the fields is not important to you, then just create multiple detail sections and four page header sections for labels, and add the fields to each section. Then conditionally suppress the sections based on the parameter selection. Show all permutations of the four fields in the list of values:

Deal, IP, Terr, Med
Deal, IP, Terr
Deal, IP
Deal
IP, Terr, Med
IP, Terr
IP
Terr, Med
Terr
Med

The section suppress formulas would like this:

{?Parm} <> "Deal, IP, Terr, Med"

//etc.

-LB

 

[jonav]

Thank you but I have more than 50 fields that need to show on report that is one the reason the user want to know if they can customize the fields.

Do you suggest still to create the detail section of all the combination of the fields ..

Pls advice

Thanks
JN

 

[lbass]

No, that makes no sense. I think you should use the approach in the original thread.

-LB