03-02-2016 12:31 PM
Can we display parameter value on report header; suppose I have two parameters Location_P and Period_P. both link to tow different control (drop-down list or list). I want to display both parameter values on header I means in text box.
Like REPORT ABC FOR Location_p under PERIOD Period_P
If Location_P and Period_P parameter having value US and Dec-2015 respectively then below line I want to display in text box
REPORT ABC FOR US under PERIOD Dec-2015
Note:-This is for SAS Visual Analytics report
Could you please help on same
Thanks in advance
03-05-2016 06:35 AM
Location_P and Period_P both parameter have assigned for two different controller (under role tab). I am able to use both parameter in filter for any report object . But I want to display both parameters on text box, for report heading. Right now i have used list table for display location and period value by using parameter on filter. but it's not look good .
03-07-2016 11:24 AM
How about creating a text box and assigning it to your Parameter value. But I think you can use a parameter in only one object. So, you need to create a new parameter and give the same value as your old parameter.
Using a parameter in a text box is shown in the below video
I am new to SAS VA, just learning it in the recent days, If my solutions does not work, please correct me.
03-08-2016 06:45 PM
@Frank_Boekamp you are correct. There is no way to use parameter values in Text objects at this time.
The best workaround is using the List Table. But instead of using filters you can create a Calculated Item to display in the List Table. For the Calculated Item you can concatenate strings and character parameters together as you like. (Note: you cannot concatenate numerics.)
Since we cannot hide the column in the List Table - you may need to name the Calculated Item to your advantage:
Calculated Item name: Report ABC
Report ABC = Concatenate(Concatenate(Location_P'p, 'under period '), 'Period_P'
To make the List Table look better - you can increase the font size or change the font color. You can even change background color of the List Table.
I hope this helps,
03-09-2016 08:59 AM
Thanks TeriPatsilaras_sas, but I did same thing by use of list table but I need to show as header. If I am using list table then it's look like a box. Even after change color (white) of list back ground.
03-09-2016 11:20 AM
Here is an additional approach that we came up with to solve the 'report header' issue. This solution uses a calculated data item (Report Description) created in the designer that makes use of the concatenation and format operators. The formula in text mode is here:
Concatenate('Report is for this period: ', Format('Date by Month'n[Raw], 'MONYY5.'))
The report example includes a list table object that displays data for periods. A period is selected using a drop-down list. A button bar is incorporated to display the header text. Interactions are defined between the drop-down list and the list table and the drop-down list and the button bar. I have attached screen shots of the report in viewer mode, the calculation of the Report Description data item, the button style, roles, and properties, and the interactions.
I hope this solution will be useful to you.