SSRS Query with hyperLink
-
Hi,
I have created a report in SSRS 2008R2 that displays Open Changes that are up for review.
Sample report
Change ID Change Type Title Scheduled Start Time
430 Emergency RHSAP242 - New WSR - Thursday - Wednesday - F1050005 21_7 – 10.5 [Thu] 11/11/2013 10:30:00 AM
431 Normal IDMS migrate employeeStatus/adminStatus change 11/13/2013 5:00:00 PM
How am I able to that when in the report if I click on the change ID (430) it will take me to the actual change same foe 431 etc.
Much appreciated - from what I have found I can not set it to do that.. I hope I am wrong.
Hope this helps...
Ford Fairlane
Rock and Roll Detective
-
It sounds like you are trying to do a drill-through report. This should get you started:
Drillthrough Reports (Report Builder 3.0 and SSRS)
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."-- Itzik Ben-Gan 2001
-
Alan.B (11/12/2013)
It sounds like you are trying to do a drill-through report. This should get you started:Appreciate the point in what looks the right direction.
Hope this helps...
Ford Fairlane
Rock and Roll Detective
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply