Traditional web-based reporting with SAS BI tools

Pass applied section filters to a linked 2nd report

Reply
Occasional Contributor
Posts: 6

Pass applied section filters to a linked 2nd report

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é
SAS Super FREQ
Posts: 407

Re: Pass applied section filters to a linked 2nd report

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
Occasional Contributor
Posts: 6

Re: Pass applied section filters to a linked 2nd report

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é
SAS Employee
Posts: 238

Re: Pass applied section filters to a linked 2nd report

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
SAS Super FREQ
Posts: 407

Re: Pass applied section filters to a linked 2nd report

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.
Occasional Contributor
Posts: 6

Re: Pass applied section filters to a linked 2nd report

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
Ask a Question
Discussion stats
  • 5 replies
  • 301 views
  • 0 likes
  • 3 in conversation