Opening SSRS drill through Report in a new Tab or Window
In order to Open a SSRS Drill through Report in a New Tab or window we have to use Javascript.
Case first-Report in new Tab without fields or Parameters
Opening Drill down Report in a new tab without parameters and fields
First you have to Select the Drill through values textbox
Properties
Text box Properties
Action
Write below javascript code
Inside javascript function add URL of the drill through Report
="javascript:void(window.open('http://abc.com/Reports/Testing/Drilldowntest.rdl ','_blank'))"
This will open your Report in a new tab
Case second-Passing Fields and opening in new Tab
When you are Passing the Fields values ie (Text box values to the drill through Report)
--Replace Report Name and with your Report Name and field Name with your drill through Report Parameter Name
="javascript:void window.open(" &"'"& Globals!ReportServerUrl &"/Pages/ReportViewer.aspx?"
&Globals!ReportFolder &"/Drilldowntest.rdl
&Low="&Fields!Low.Value &"
','_blank')"
DrilldownTest.rdl-Change to YOur REport Name
Low-Replace it with Your Report drill through parameter Name
Low.Value-Replace it your field Name
Case Third Passing Fields as well as Parameters with IIF conditions and opening report in a new tab
="javascript:void window.open(" &"'"& Globals!ReportServerUrl &"/Pages/ReportViewer.aspx?"
&Globals!ReportFolder &"/Drilldowntest.rdl
&Low="&Fields!Low.Value &"
&High="&Fields!High.Value &"
&Project=" &IIf(Parameters!Project.Value="","A",Parameters!Project.Value) & "
','_blank')"
DrilldownTest.rdl-Change to YOur REport Name
Low-Replace it with Your Report drill through parameter Name
Low.Value-Replace it your field Name
Same with High
Project-Replace it with your Child or drill through Report Paramter Name
Project.value-Project is your Main Report Parameter Replace it with your Main Report Parameter.value
Note the above all javascript is to open Report in new tab if you want to open report in new window name the window and adjust the Properties as below
="javascript:void window.open(" &"'"& Globals!ReportServerUrl &"/Pages/ReportViewer.aspx?"
&Globals!ReportFolder &"/Drilldowntest.rdl
&Low="&Fields!Low.Value &"
','RUWindow','left=370,top=180,width=940,height=300,status=no,menubar=no,scrollbars=no,location=yes'" & ")"
i am not getting the report url opened in new tab. Instead it is opening in the same tab.
ReplyDeleteThis comment has been removed by the author.
DeleteHi Can you paste the code, also try by adding target="_blank" in the last as case second in the post.
DeleteThis page was really helped me. Thanks a lot.
ReplyDeleteGenerally, I don't post comments on any blogs but this time I searched for this kind of stuff and nothing was worked and last I found yours and altered ur's java script to fit for my scenario and it did really works and that happiness made me to drop a comment on your blog.
Once again Thank u:)
Welcome, That's make my post worth.
DeleteThanks It Saved Lot of time Appreciate !!!
ReplyDeleteWelcome, Thanks for your precious comment.
DeleteIt is working but when I right click and open in new tab then a blank screen is coming.
ReplyDeleteOnly the click is working and not the right click
FYI...
DeleteBelow is my code I am using.
="javascript:void window.open(" &"'"& Globals!ReportServerUrl &"/Pages/ReportViewer.aspx?"
&Globals!ReportFolder &"/OperationalOverShortLinkedReport
&pProductId="&Fields!ProductId.value &"
&pResourceId="&Fields!ResourceId.value &"
&pFlowDate="&Parameters!pFlowDate.Value &"
','_blank')"
The drill press can configure a change in speed by manually pulling the belt across a stepped arrangement of pulley.visit here
ReplyDeleteIt is not the ideal choice of drill to use for applications such as driving screws. Since the speed is not variable and the drill only operates at a higher RPM, you would likely either strip the screw head or snap the head off the screw if you tried.https://simplehandyman.co.uk/best-sliding-compound-mitre-saw-uk-reviews/
ReplyDeleteHey there, if you want to get tableau certified then you must need to pass the tableau certification exam and for that you must take help from tableau certification practice tests
ReplyDeleteImpressive web site, Distinguished feedback that I can tackle. Im moving forward and may apply to my current job as a pet sitter, which is very enjoyable, but I need to additional expand. Regards. how to make A BOW DRILL
ReplyDeleteThanks for this post. I want to read the parameter value and assign it to the parameters of new report. But unable to do that.
ReplyDeleteWhat a fantabulous post this has been. Never seen this kind of useful post. I am grateful to you and expect more number of posts like these. Thank you very much. Impact Wrench Guides
ReplyDeleteI'm trying to use this code but keep getting RSItemNotFound when clicking the text box contents. Can I specify the report server url explicitly?
ReplyDelete="javascript:void window.open(" &"'"& Globals!ReportServerUrl &"/ReportViewer.aspx?"
&Globals!ReportFolder &"/IncomeStatementSubreportLongDesc.rdl
&prmRevenueExpenseTransferType="&Fields!Revenue_Expense_Transfer_Type.Value &"
','_blank')"
Great post, and great website. Thanks for the information! footcare tools
ReplyDeleteI am definitely enjoying your website. You definitely have some great insight and great stories. footcare drills
ReplyDelete