topic Re: Can we display parameter value on report or under report header in SAS Visual Analytics

Can we display parameter value on report or under report header

anandsasbi — Wed, 02 Mar 2016 17:31:02 GMT

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

Regards,

Anand Kumar

Re: Can we display parameter value on report or under report header

Explore_SAS — Fri, 04 Mar 2016 20:36:31 GMT

Doesnt your dropdown selected values will be a parameter values ?

Re: Can we display parameter value on report or under report header

anandsasbi — Sat, 05 Mar 2016 11:35:04 GMT

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 .

Re: Can we display parameter value on report or under report header

sundeep15685 — Mon, 07 Mar 2016 16:24:23 GMT

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

https://www.youtube.com/watch?v=g-ZWxX4jxRU

I am new to SAS VA, just learning it in the recent days, If my solutions does not work, please correct me.

Thanks

Re: Can we display parameter value on report or under report header

Frank_Boekamp — Tue, 08 Mar 2016 19:09:10 GMT

I think it's not possible to use paramater values in text objects. It would be a much valued addition to SAS VA imho

Re: Can we display parameter value on report or under report header

TeriPatsilaras — Tue, 08 Mar 2016 23:45:17 GMT

@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,

Teri

Re: Can we display parameter value on report or under report header

anandsasbi — Wed, 09 Mar 2016 13:59:35 GMT

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.

Re: Can we display parameter value on report or under report header

BobbieWagoner — Wed, 09 Mar 2016 16:20:14 GMT

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.