Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Can we display parameter value on report or under report header

Reply
Contributor
Posts: 26

Can we display parameter value on report or under report header

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

Contributor
Posts: 69

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

Doesnt your dropdown selected values will be a parameter values ?
Contributor
Posts: 26

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

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 .

Contributor
Posts: 32

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

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

 

http://blogs.sas.com/content/sgf/2015/01/29/using-parameters-in-sas-visual-analytics Teri Patsilaras demonstrates two advanced applications of using parameters in SAS Visual Analytics reports. The first example uses a single parameter as both a search criteria filter and a custom calculated data ...
Contributor
Posts: 52

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

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

SAS Employee
Posts: 6

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

@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'Smiley Wink

 

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

Attachment
Attachment
Attachment
Contributor
Posts: 26

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

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.

SAS Employee
Posts: 8

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

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.

 

Attachment
Attachment
Attachment
Attachment
Post a Question
Discussion Stats
  • 7 replies
  • 943 views
  • 3 likes
  • 6 in conversation