Is it possible: Parameter that selects either of 6 columsn 1

[dadazs]

Hello

Thank you for reading.
I have a requirement to create a report where I need to select a value from either 6 columns. Then the selected column should appear in the report. User should be able to ignore selection too.

Is it something Crystal is capable of doing?

e.g.
Table:
Budtet1 Budtet2 Budtet3 Budtet4 Budtet5 Budtet6

User may wish to select any of above or none. The selected column value should appear in designated field in the report.

Many thanks

 

[lbass]

Are you saying that only one column should be selected?

What do you want to happen when the user selects none of the columns? None of the columns appear on the report or all?

-LB

 

[dadazs]

In general, user should have 7 options:
column1 to column6 and n/a

If user selects none then column should be blank or display "n/a".

Cheers

 

[lbass]

First create a parameter {?Budget} with options like "Budget1", "Budget2", etc., and with a final option of "N/A".

Then create a formula {@Budget}:

select {?Budget}
case "Budget1" : {table.budget1}
case "Budget2" : {table.budget2}
|
|
case "Budget6" : {table.budget6}
case "N/A" : "N/A"

Add this formula to the detail section of the report.

-LB

 

[dadazs]

Thank you. Great info!