dwabbott
asked on
Displaying description of parameter in report heading
After selecting a parameter for a time period I am reporting on, I want to display the parameter in the report heading. When I select 'Period 13 2011', which is the description of the data item as shown in the Edit Parameter dialog box, the report displays [FISCPERIOD].[DT2011013], which is the full name of the data item. I want it to display 'Period 13 2011'. Is there any way this can be done?
Thank you.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That is amazing. It worked beautifully! Thank you for your quick and precise solution!
If your format of the data item is always the same, maybe you can do something with RIGHT, LEFT, MID to print it out the way you want.