Hi All,
Is there any possible way to link a report to multiple reports .
I have explained my scenario in the below example.
By Clicking the values of different columns i should navigate to respective reports .(For example if i clicked the value under stores column i should get the report containing store's details and the same for the other columns also).
Pls help me in this regards.
TIA
Regards,
Ramesh
I'm sorry but you cannot link to multiple reports. However, you can add prompts to a single target report and pass values from the source report to display different results. This SAS note explains: http://support.sas.com/kb/41/984.html
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Creating Beautiful Reports
SAS Visual Analytics Learning Center
Hello Ramesh,
There is a way to do this. Create a dataset with the required colums, In that create number of stores column with the hyperlink pointing to the stored process of the report linking to the number of stores report. and in the same way create a number of person column pointing to another stored process linking to the number of persons report.
Using the created data set, use proc report to display the result. Copy the code and create a stored process. Use the stored process to create the report
Note:
This will be a work around to see the links in the web report studio but if you import the same report in AMO, then it will be imported with full URL and the value(77) .
Regards,
Akilan R
Hello Ramesh,
There is a way to do this. Create a dataset with the required colums, In that create number of stores column with the hyperlink pointing to the stored process of the report linking to the number of stores report. and in the same way create a number of person column pointing to another stored process linking to the number of persons report.
Using the created data set, use proc report to display the result. Copy the code and create a stored process. Use the stored process to create the report
Note:
This will be a work around to see the links in the web report studio but if you import the same report in AMO, then it will be imported with full URL and the value(77) .
Regards,
Akilan R
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.