• 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
 23 Subscribed to this forum
Sort:
Author
Messages
Donna
Veteran Member
Posts: 110
Veteran Member
New Poster
New Poster
Congrats on posting!
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
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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
Posts: 110
Veteran Member
New Poster
New Poster
Congrats on posting!
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