Showing Description in report for a parameter.

building reports crystal reports
1

Hi all,
I have a requirement where I need to show description of a parameter in the report.
For eg:

CODE DES
AF Associated Feature
BG Background
BGA Background Ambient
BCA Bkgrd Comm Ambient
BC Bridge/Cue
CJ Combination M Jingle
CS Combination M Promo
CT Combination M Theme … and so on.

The parameter is on the DB field ‘CODE’. Here when the user selects the parameter value ‘AF’ the report should show the description ‘Associated Feature’ in the Report Header.

I am using stored procedures in the report and lookups(coming from a package) for the drop down values of parameters.
I thought of creating arrays in the formula editor but I could not find a way to pass values to an array variable from a field. (I have to enter all the values in array manually to create an it. But we have approx 50 reports which have CODES of more than 40. So it’ll be not worthful).

Is there any way to achieve this requirement?
Thanks for your help in advance.

prk (BOB member since 2007-10-09)

2

Try creating a sub-report and pass the code to it and fetch the description back. That would be the easiest way I think.

Sanjay Kodidine :us: (BOB member since 2008-03-19)

3

I tried that SKodidine, but when there is no data returned for a particular input parameter criteria, the description for that paprameter is empty.
eg: for BC - Bridge/Cue, if even though there are no records, the description(Bridge/Cue) should come in the report header but it is showing empty there.

prk (BOB member since 2007-10-09)

4

I’m just wondering if you worked out how to do this. I have run into the exact same issue.

It would have been nice to do something like

JOIN({?param.desc},",") or something similar.

Cheers

Hally (BOB member since 2009-06-30)