topic Re: Filters and Linked Reports in SAS Web Report Studio

Filters and Linked Reports

jonathantrue — Wed, 25 Sep 2013 21:40:25 GMT

I've been trying to do some research on passing prompt values from one report to a linked report, and it seems like about the only way to do this is via a stored process that updated/reads a table... Is there some other solution that I'm just missing?

In report 1, you select a start and end date. Report one is linked to another report and some of variables are tied to filters on report 2. But report 2 always prompts me for the start and end date because I can't figure out how to pass those values... This seems like something that should be built in, but I'm guessing it's not?

I'm not having a great deal of luck with the "stored process/table update" method, and I'd prefer not to create 2 seperate information maps tied to seperate stored procs as described in that method. Any other ideas that I could try?

Re: Filters and Linked Reports

FredrikE — Thu, 03 Oct 2013 06:46:41 GMT

If you have start and end date in your report it should be possible to link direcly to report#2.

In report2 you need prompts for date and those are the ones you use when linking....

I might have missed something thou....

Re: Filters and Linked Reports

ajuvaba — Fri, 04 Oct 2013 11:50:56 GMT

You have to create a link between prompt in report 2 and filter value in report 1. It will always prompt values if you open report 2 directly but works if you click from one report to other.

This link should help you to understand how it works. http://support.sas.com/kb/41/526.html

If you don't have the possibility to create a link between two reports then you need additional rights. You have to be a member of a Web Report Studio role that has the "Advanced Report Creation: Create Report Links" capability.

It takes maybe few times to try out but it is quite easy to understand process.

Hope it works for you also...

Re: Filters and Linked Reports

twocanbazza — Mon, 28 Oct 2013 21:22:54 GMT

In WRS, you can only link reports using characters vars - dates in SAs are Numeric.

26174 - Using SAS® Web Report Studio to pass prompt values between linked reports

Might be different in latest version of WRS

Re: Filters and Linked Reports

Haikuo — Tue, 29 Oct 2013 01:26:03 GMT

From SAS programmer point of view, prompts are macro variables. So here are some suggestions:

1. Use ONE stored process for both reports.

2. Make sure the macro variables are global.

Haikuo