• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Printing multiple parameter descriiption value fields

 2 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Donna
Veteran Member Send Private Message
Posts: 110
Veteran Member
5/7/2014 1:38 PM
I have a formula that will print the values in my parameter that accepts multiple parameter values. My user would like to see the parameter descripton field instead.

Does anyone have a suggestion for accessing the parameter description value field?

Thank you.

Donna
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
5/9/2014 6:46 PM
If you have the reportid, the ERS.ERS_REPORTPARMVALUES table contains the description under the 'PARAMETERNAME' field or the description under ERS.ERS_REPORTPARAMETERS 'PARAMETERDESCRIPTION' field.
Donna
Veteran Member Send Private Message
Posts: 110
Veteran Member
5/12/2014 8:58 PM
Hi Greg,

Sorry, I did not respond sooner. I have not had a chance to add the ERS tables to my report and test the values returned for the 'PARAMETERDESCRIPTION' field but will respond with my results.

Thank you.

Donna