BookmarkSubscribeRSS Feed
AndreR
Calcite | Level 5
Hello all,
is it possible to pass an applied section filters to a linked 2nd report?

I have a report A which has a YEAR and MONTH section filter, where user
can select multiple entries and I want to pass the applied section filters
to the linked report B. Is this somehow possible?

Report A:

Applied filters: YEAR equal to 2010 AND MONTH equal to 1, 2, 3

Country|Revenue|Margin
----------------------------------
Germany|1000|1000
Belgium|1000|1000


Thanks in advance,

Kind regards,
André
5 REPLIES 5
Madelyn_SAS
SAS Super FREQ
If Report B has prompts for YEAR and MONTH, you should be able to pass the filter values from Report A to Report B. There are some limitations depending on which version of WRS you are using. Specifically, you cannot pass values for numeric expressions in version 4.2.

Here is a sample for passing prompt values to linked reports written for version 3.1, with some updates for 4.2.

http://support.sas.com/kb/26/174.html
AndreR
Calcite | Level 5
Thank you for your answer.

Report B has Year, Month and Country prompt(all alphanumerical), and they are all
shown in report linking dialogue, but I can only select an entry for country prompt.

But I guess in your SAS link the note says it's not possible:

"Notes on Report Linking Via Prompts
...
* If you hide a category that is being used in a report linking prompt, then the prompt association is removed. The report link will still work but you will have to complete the prompt window before the target report is rendered."


The category Year and Month are hidden, they are only used for section filter.
I guess it's a problem with multiple entries for section filter(like Month IN '01, 02, 03'),
I think right now it's only possible to pass one entry to the linked report.

But anyway thanks for your help,

Kind regards,
André
AngelaHall
SAS Employee
Andre,
There are still mechanisms to accomplish this via SAS Stored Processes.
You could pass the values from Report A into Report B (which is built in SAS Stored Processes).

Several resources exist but might not totally explain how this works:
http://support.sas.com/kb/19/597.html
http://support.sas.com/documentation/cdl/en/citug/61084/HTML/default/n1cxoydhoyhsain13of3rrl6yfir.ht...

Maybe a SAS Global Forum 2011 paper is in order?

What I would have is a link (to the stored process, passing the parameters) defined within the data table itself, then select the 'Display as Hyperlink' button in Information Map Studio (similar to my post on doing this for formats: http://sas-bi.blogspot.com/2010/01/custom-colors-on-categories-in-web.html). Then the data cells should link to the Report B passing the information you require.

~ Angela
Madelyn_SAS
SAS Super FREQ
Just an FYI, Web Report Studio 4.2 supports passing group break values to prompts (olap and relational) and hidden filtered values (olap only) as explained in http://support.sas.com/kb/35/642.html

There are plans to support hidden filtered values for relational in the next release.
AndreR
Calcite | Level 5
Thanks Angela & BIC_USER_3@SAS,
I'll try to get familiar with how Stored Procedures work, I haven't used them so far.

cya

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 1023 views
  • 0 likes
  • 3 in conversation