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?
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...
In WRS, you can only link reports using characters vars - dates in SAs are Numeric.
Might be different in latest version of WRS
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.