Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Is it possible in SSRS? Expand / Collapse
Author
Message
Posted Friday, September 20, 2013 1:00 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 14, 2014 5:16 AM
Points: 45, Visits: 352
I would like to create a drill through action that calls a report (passes parameters ) and the detailed report has to be downloaded(exported into excel).

please find the attached image for reference.
in the image when i click on "111" in the level - I report then the level - II report has to be downloaded.


  Post Attachments 
Untitled.png (17 views, 8.61 KB)
Post #1497006
Posted Friday, September 20, 2013 1:09 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 14, 2014 5:16 AM
Points: 45, Visits: 352
the drill through action has to download/export the datailed level report...
Post #1497010
Posted Monday, September 23, 2013 6:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 6, 2014 7:41 AM
Points: 41, Visits: 165
Hi

Yes it is possible.
I have already done it but under the same report.

If you want to call another report, you have to use the functionality "Jump to report"
This is possible when ou right click on the textbox where you want to configure the "Jump":

See attachment.


  Post Attachments 
JumpToRepor.jpg (15 views, 62.45 KB)
Post #1497351
Posted Monday, September 23, 2013 10:29 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 14, 2014 5:16 AM
Points: 45, Visits: 352
Sry ... If I am not clear in explaining my requirement.

when I click on the 1st level report figure say "111" then and there the detailed level report has to be download.

plz refer the attached image once.

thanks for your response.
Post #1497463
Posted Monday, September 23, 2013 9:56 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 20, 2014 8:32 PM
Points: 3,062, Visits: 2,672
You should be able to do this by using the "go to URL" action (not the "Go to Report" action).

You will need to create a string that is the full URL for a request to reporting services to run the report with the required parameters and with the render format set to EXCEL. Have a look at http://technet.microsoft.com/en-us/library/ms154040.aspx and http://msdn.microsoft.com/en-us/library/ms155391.aspx (and the related items in msdn) - these should get you started.



Post #1497638
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse