Traditional web-based reporting with SAS BI tools

Multiple Report Linking.

Reply
Occasional Contributor
Posts: 8

Multiple Report Linking.

Hi All,

Is there any possible way  to link a report to  multiple reports .

I have explained my scenario in the below example.

image_jpeg.jpg

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

SAS Super FREQ
Posts: 384

Re: Multiple Report Linking.

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

Occasional Contributor
Posts: 17

Re: Multiple Report Linking.

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

Occasional Contributor
Posts: 17

Re: Multiple Report Linking.

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

Post a Question
Discussion Stats
  • 3 replies
  • 405 views
  • 3 likes
  • 3 in conversation