If you would like to link users to a specific section within a Web Report Studio report, there is a quick way to generate the URL. Just send yourself an email from Web Report Studio.
A parameter &rsTS is included in the link which corresponds to the specific section selected. This URL can be copied and used from SAS Portal, Stored Processes, etc.
Included in the three screens below is an example of using the EMAIL function to generate a direct link to the US Sales Report's Graph Section. (Mouseover to view the step described. Click to view the full screenshot.)
15 Comments
Hi Angela,
This is very cool tip. However its not working in my scenario :( . I am using SAS WRS 4.4 , When i click the e-mail, the Link has the word EMAILED with some umbers and the report name also reflects the same. Is it any work around to over come this ??? I have to write a Stored procedure which leads user to specfic section in the web report. All i need the link for the second , third section. Any help on this wll be greatly appreciated.
Thanks,
Prabakaran
Unfortunately, this functionality no longer works in Web Report Studio. There were issues with links being longer than allowed for post processing, so SAS changed the mechanism to create a relative link that is resolved by the Web Report Studio app on the fly. You can contact SAS Technical Support to see about a workaround. There is actually something called an STP Report Launcher that could be used to redirect you to a specific location of a WRS report.
Thanks, Angela, useful tip. Reviving this thread again...
I'm trying to open a WRS report from the Portal (i.e. using http://xxxx/SASPortal/syndication.do?com.sas.portal instead of http://xxxx/SASWebReportStudio/openRV.do? to avoid having to sign in again), but I can't see a way of passing prompt values in the URL using this method. It always goes to the prompt screen of the report.
Any idea?
Hi Daniel,
Thanks for reading the blog. This post was created with a prior version of WRS and it appears that this functionality no longer exists. The emailed links now have been reduced to a numeric representation of the prompt selection (such as: Emailed%2F131212_093216). The Report Portlet from SAS Portal shows the default prompt selections in the Portal, and if the user wants a different set of prompts they could click the 'Launch Live Report' link.
I see that you have opened a ticket with Technical Support - at this time that is the best approach.
Hi again Angela (and others)
I found the solutions be keep looking SAS notes etc.
http://support.sas.com/documentation/cdl/en/citug/63816/HTML/default/viewer.htm#n1kaxrhektg72kn1800i55qwjpfd.htm
The solutions is to open the report as described in the link above :-)
Great to hear Martin! Thanks for sharing the solution.
Hi Angela
Hopefully you can help us even your originally post is 1-2 years old. We are running 9.3M2 and now the email functions (used to generate links) has changes. When linkig to sections I canfigure it out butwith prompts I can't. The Email functions do not show the prompt (R_ELMT) fx:
https://HOST.../SASWebReportStudio/openRVUrl.do?rsRID=SBIP%3A%2F%2FMETASERVER%2FFunding+samarbejde%2FFF+BI%2FJyske+Bank%2FReports%2FJB+Historik+BRF+l%C3%A5nenr.srx%2FEmailed%2F130911_190613%28ReportCI%29&PSAL=0
Instead of the prompt and Emailed + date is included in the link. Can you please help us to figure a correct "prompt" l.
Martinink
Angela, Ignore my last requst. Just realised I need to seperate prompts with "&".
Thanks Again
Super news Matt! Glad you figured it out!
can you please provide an example of a link including parameter value. I am trying to acheive this but my mail client truncates the link and I need to know the format te URL takes when including user pvided values. Below is as much as I can see;
http://vibbpsws01.corp.aco.uk:8080/SASWebReportStudio/openRV.do?rsAM=pUrl&rsRID=SBIP%3A%2F%2FMETASERVER%2FProducts%2FZ.srx%28Report%29&.R_ELMT_0910201214023627143..n=%3CInteger
Help much appreciated
Matt - Here is an example of a report "CountryReport_Select Date" located in my User Folder - where I had a date prompt set to get all values from 1000 days ago:
http://servername:8080/SASWebReportStudio/openRV.do?rsAM=pUrl&rsRID=SBIP%3A%2F%2FMETASERVER%2FUser+Folders%2FAngela+Hall%2FMy+Folder%2FCountryReport_Select+Date.srx%28Report%29&.R_ELMT_091220121427298854..DATA_09122012142749746%5C.P_17=%3CDate+value%3D%22D-1000D%22+version%3D%221.0%22%2F%3E
Which type of prompt are you using? I can generate an example of the same type which could help you deconstruct and build one there.
~ Angela
Angela
Many thanks for your help. An example for a character and numeric prompt to go with that above would be a huge help. I can see as much as 'Integer+value' or 'String-value' before my mail client truncates the link so examples of the remainder should get me there.
Thans again
Matt
Here you go Matt. Also out of curiosity - what email system are you using? Lotus? Outlook? I am using Outlook - but have the HTML format set as the default.
There are also interesting issues with certain prompt names - such as: http://support.sas.com/kb/43/624.html
Numeric Prompt:
("TotalSales Country Report v2" with 'salestotal' imap prompt set to 105123)
http://servername:8080/SASWebReportStudio/openRV.do?rsAM=pUrl&rsRID=SBIP%3A%2F%2FMETASERVER%2FUser+Folders%2FAngela+Hall%2FMy+Folder%2FTotalSales+Country+Report+v2.srx%28Report%29&.R_ELMT_0914201218382575825..SalesTotal=%3CInteger+value%3D%22105123%22+version%3D%221.0%22%2F%3E
(Note that you need to use: http://support.sas.com/kb/19/455.html to get the numeric prompt to display.)
Character Prompt:
("TotalSales Country Report v2" with 'countryprompt' imap prompt set to Canada)
http://servername:8080/SASWebReportStudio/openRV.do?rsAM=pUrl&rsRID=SBIP%3A%2F%2FMETASERVER%2FUser+Folders%2FAngela+Hall%2FMy+Folder%2FTotalSales+Country+Report+v2.srx%28Report%29&.R_ELMT_0914201218382575825..countryprompt=%3CString+value%3D%22Canada+++++++++++++++++++%22+version%3D%221.0%22%2F%3E
Thanks Angela. I'm using Lotus Notes 7.1. Apparently this is a known issue fixed in the next release which we should be moving to shortly. Until then can I bother you for one more link. I need to know how to combine multple parameters into a single url so an example of the the above but with two prompt values would be greatly apprecated.
Thanks again for all your help.
Matt
Cool tip ... thanks!