I want to show summary level report and then I need to provide detailed level information to user if he click on particular text field in summary report.
One option : to create separate summary and detailed reports and link the detailed report inside summary report.
However, can someone suggest any other method to achieve this kind of drill down without report linking ?? I mean..is it possible to on the fly produce detailed report if user clicks on a field on summary report ?
(We can not use OLAP ! so that option is ruled out.)
Sid, I used to think you couldn't do parameter linking in WRS (i.e. I click on the USA part of the report and it brings up detail on USA), but last Friday I saw a demo of exactly that. I think this was report linking though... which you suggested you wanted to avoid.
There's a different SAS product called SAS/IntrNet which can do what I think you're getting at: you click on the USA value in the table and it passes "USA" to some SAS code which generates a USA report on the fly. It's pretty cool, but again, a different product from WRS.
So, lots of suggestions, but not a lot of hard answers. Sorry! If I find more info on this topic, I'll try to post that.
In order to make SAS Web Report Studio (WRS) a better reporting tool, WRS will be conducting a few different usability tests on future design prototypes. We would love to get feedback on these designs from WRS users. In order to set up these tests, please take a five minute survey so we can place you in the appropriate usability test.