Friday, February 10, 2012

Calling Subscription screen inside Report viewer

Hello

I use SQL Server 2005 Reporting Service to develop all my Reports. i design the report and deploy to the report server. i have created a Web application where i use the above report to be shown inside a ReportViewer page.

when any user view's the report i also want to give them the subscription screen inside the report viewer. BIG QUESTION is how do i call the subscription screen of a specific report inside the report viewer?

any help is appreciated

/Chandresh Soni

Assuming a clickable link is an appropriate solution here, and assuming that these are RDLs rather than RDLCs (which it seems they are), and if you really want to do it inside the report definition itself, realize that the subscription page is just like any other URL.

You should be able to have a textbox that says "click here to go to the subscriptions page for this report" that navigates to a URL using something similar to this expression for the navigation link:

Code Snippet

="http://YourServer/Reports/Pages/Report.aspx?ItemPath=" &
Globals!ReportFolder & "/" & Globals!ReportName
& "&SelectedTabId=SubscriptionsTab"

... but there is no real advantage to putting this inside the report, IMHO. Why not just something like this expression as a hyperlink in the header of your ReportViewer ASPX page?

>L<

|||

Hello Lisa,

thanks for looking at my problem. you solution works but still have a problem. when i use a link as you suggested in my report viewer the user gets the subscription page but after he completes he is redirected again to show Report manager with all reports.

I have a.rdl file which i show in my web page. but i use this http://<servername>/reportserver?folder name/reportname

this gives me control to show only report with out showing the report manager's header and other details.

eg http://gloss.asp.net/ReportServer?%2fDMS_Reports%2fHB107_Dashboard&rcBig SmileocMap=false

/Soni

|||

Chandresh, if you don't want them to see the report manager, you shouldn't be sending them to the report manager <s>.

You can interrogate current subscriptions, using the RS SOAP interfaces. You then display whatever limited interface to your users you want, and provide any updates back to RS with SOAP interfaces. Doesn't this make more sense?

>L<

|||

hi again,

many thanks, do you know where can i find more documentation on using RS SOAP API

/Chandresh soni

|||You could start here... http://msdn2.microsoft.com/de-de/library/ms155376.aspx

Or here http://msdn2.microsoft.com/de-de/library/ms155376.aspx

>L<

No comments:

Post a Comment