December 14, 2023 at 2:00 am
Hello!
I have a report that lists all reports in folders on the report server, if you click on the report name I want it to open a new tab with that report.
So I am not sure where I am going wrong. I am building my URL link to other reports on the server as such: This is ReportPath2 coming from my SQL:
'http://epqbissi01/ReportServer/Pages/ReportViewer.aspx?%2fReports/' +b.ReportFolder +'/'+ Replace(a.name,' ','%20') + '&rs:Command=Render&rc:LinkTarget=_blank'
While it does open another tab it just opens the "http://epqbissi01/Reports/browse/" folder on the server. What am I missing?
I have also tried the ="javascript:void(window.open('Fields!ReportPath2.Value','_blank'))" way and the same thing happens
December 15, 2023 at 2:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 21, 2023 at 5:14 pm
You may have already found your solution, but here's how I have it configured in one of my reports. I've obfuscated some names. In my case, the report is under 3 layers of folders. I didn't want to take the chance of fat fingering anything so I kept everything:
="javascript:void(window.open('http://MyServer/ReportServer/Pages/ReportViewer.aspx?%2fFolder1%2fFolder2%2fFolder3%2fMyReport&MyParameter=" & Fields!ID.Value & "','_blank'))"
I did my best to translate this to what you have and came up with (fingers crossed....):
="javascript:void(window.open('http://epqbissi01/ReportServer/Pages/ReportViewer.aspx?%2fReports%2f' & b.ReportFolder & '%2f' & Replace(a.name,' ','%20') & "','_blank'))"
To troubleshoot, add a text box in your report that just renders this portion:
'http://epqbissi01/ReportServer/Pages/ReportViewer.aspx?%2fReports%2f' & b.ReportFolder & '%2f' & Replace(a.name,' ','%20')
And see if that generates a usable link.
Good luck!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply