topic Re: Web Report Studio and HTML links in SAS Web Report Studio

Web Report Studio and HTML links

deleted_user — Thu, 05 Nov 2009 16:08:48 GMT

Hi, not sure if i'm posting this in the right place but here goes........

Put simply, I'm trying to print a table of URLs and I'd like the ability to click through to them from WRS.

I'm trying to create a data dictionary type application and i'd like to be able to search for a column name and have the ability to click through to a specific URL which will present me with a document containing more detailed info on the selected column.

Has anyone else ever tried this, or does anyone have any ideas if it is possible??

Cheers

Paul

Re: Web Report Studio and HTML links

Cynthia_sas — Thu, 05 Nov 2009 21:09:55 GMT

Hi:
Web Report Studio uses XML and Java to present information. HTML tags may or may not be honored in a Web Report Studio report or stored process results (usually not with SAS 9.1.3 and WRS 3.1) This Tech Support note has some relevant info:
http://support.sas.com/kb/18/085.html

The type of drill-down that you describe is seems more a Portal applet or Portal stored process rather than a WRS report.

For more help with what you want to accomplish, you might be better served by opening a track with Tech Support.

cynthia

Re: Web Report Studio and HTML links

deleted_user — Fri, 06 Nov 2009 09:25:10 GMT

Hi Cynthia,

Thanks for the info. I have previously queried Tech Support who told me it was not possible but I thought I'd try my luck on here. You never know, someone might have a hack 😉

Cheers

Paul

Re: Web Report Studio and HTML links

Jenn2 — Fri, 06 Nov 2009 21:31:56 GMT

Simkinp,
Did you build the table in Web Report Studio or in some other application?

Re: Web Report Studio and HTML links

cgerdvil — Tue, 10 Nov 2009 03:29:25 GMT

What you want to do is not possible in 9.1.3 unless you use Report Linking and prompts created from Information Map Studio.
That's a good idea you have and I might try it 🙂
I overcame this limitation in WRS by creating drilled reports based on prompts from a rolled up report in a hierarchy.
For example, let's say I have a 100K record table of customers and I wanted to display the data based on user driven input. (too much data for one report and will render very slowly when used with group breaks)
I create a "Top" page with totals of customers based on State where State is a link to another report (50 records, 2 columns). State is also a filter that I set up in another report where the user is prompted to enter a State. I link the two reports together by State and the user can click on the State of interest and see a detailed report subsetted by State. Follow that logic all the way down the chain until you get to the lowest level of detail you want to display.
I'm not sure how exactly you're going to be able to do this but the method I described is fairly simple but powerful - it kind of acts like a cube but faster.

Re: Web Report Studio and HTML links

deleted_user — Wed, 11 Nov 2009 11:52:10 GMT

Jenn2,

The table was built in Base SAS then imported into a metadata library. This dataset is then referenced via an information map.

Cheers

Paul

Re: Web Report Studio and HTML links

deleted_user — Wed, 11 Nov 2009 12:04:20 GMT

cgerdvil,
Thanks for the info.

hmmmm, I'm wondering now if I could link a report to a stored process perhaps, and somehow have the stored process render some html for me. (Time to go play again!)

Cheers

Paul