What URL should I give to run the report directly..

Question

What URL should I give to run the report directly..

mw_sql_developer

SSCoach

Points: 19445
More actions
November 14, 2017 at 7:28 am

#340445

Question: I am trying to get a report to run immediately. What I mean is if I paste the following URL on the browser it should run the report and display the results.
Instead it opens the report with the parameter field "RepParameterSet" empty.
http://mhpdw2/Reports/Pages/Report.aspx?ItemPath=%2fMyContigo%2fDO_NOT_USE%2fSubReportWithMemberInfoUsedByWaiverFinance&RepParameterSet=50,>64,E,201711

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Thom A SSC Guru Points: 99126 More actions · Answer 1

Try using the ReportServer address. Possibly... http://mhpdw2/ReportServer/Pages/ReportViewer.aspx?%2fMyContigo%2fDO_NOT_USE%2fSubReportWithMemberInfoUsedByWaiverFinance&RepParameterSet=50

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

mw_sql_developer SSCoach Points: 19445 More actions · Answer 2

Hey! It works.... Thanks a lot!

--Works http://mhpdw2/ReportServer/Pages/ReportViewer.aspx?%2XXXXXXXXXXXXXXXXXXXX%2fDO_NOT_USE%2fSubReportWithMemberInfoUsedByWaiverFinance&rs:Command=Render&RepParameterSet=50,>64,E,201711

mw_sql_developer SSCoach Points: 19445 More actions · Answer 3

Hey Thom:
The above URl works fine.. But I need it to open in a new browser window ( or tab )

. I wanted to now call this link from another SSRS report and have it open in a new browser window. So I followed a help tip in the internet and added the following: When i click on the cell it does not do anything......

See the attached 2 images and leg me know whether I am doing something wrong

="void(window.open('http://mhpdw2/ReportServer/Pages/ReportViewer.aspx?%2XXXXXXXXXXX%2fDO_NOT_USE%2fSubReportWithMemberInfoUsedByWaiverFinance&rs:Command=Render&RepParameterSet=" + "50,>64,E," + Fields!YYYYMM.Value + "')"

Thom A SSC Guru Points: 99126 More actions · Answer 4

Not sure I'm afraid, I'm not a javascript programmer/developer. At a guess, however, maybe you have Javascript disabled in your browser.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Sue_H SSC Guru Points: 90860 More actions · Answer 5

For the go to URL and opening a new window, it needs to be java script. Something like:
="void(window.open('http://YourPathToReport','_blank'))"

Sue

mw_sql_developer SSCoach Points: 19445 More actions · Answer 6

Sue_H - Tuesday, November 14, 2017 1:04 PM
For the go to URL and opening a new window, it needs to be java script. Something like:
="void(window.open('http://YourPathToReport','_blank'))"
Sue

="void(window.open('http://www.google.com','_blank');"

I tried but it does not work

mw_sql_developer SSCoach Points: 19445 More actions · Answer 7

mw112009 - Tuesday, November 14, 2017 3:14 PM
Sue_H - Tuesday, November 14, 2017 1:04 PM
For the go to URL and opening a new window, it needs to be java script. Something like:
="void(window.open('http://YourPathToReport','_blank'))"
Sue
="void(window.open('http://www.google.com','_blank');"
I tried but it does not work

for some odd reason , when posting, this removed the first part which says void(

mw_sql_developer SSCoach Points: 19445 More actions · Answer 8

mw112009 - Tuesday, November 14, 2017 3:15 PM
mw112009 - Tuesday, November 14, 2017 3:14 PM
Sue_H - Tuesday, November 14, 2017 1:04 PM
For the go to URL and opening a new window, it needs to be java script. Something like:
="void(window.open('http://YourPathToReport','_blank'))"
Sue
="void(window.open('http://www.google.com','_blank');"
I tried but it does not work
for some odd reason , when posting, this removed the first part which says void(

IT removes the word J-A-V-A-S-C-R-I-P-T

Sue_H SSC Guru Points: 90860 More actions · Answer 9

Deploy it and try. I don't think it works in preview from the designer.

Sue

mw_sql_developer SSCoach Points: 19445 More actions · Answer 10

 ="j-a-v-a-s-c-r-i-p-t:void window.open(" &"'" & Globals!ReportServerUrl & "/Pages/ReportViewer.aspx?" & Globals!ReportFolder & "/SubReportWithMemberInfoUsedByWaiverFinance&rc:Parameters=False&RepParameterSet=50,>64,E," & Fields!YYYYMM.Value & "','_blank')"

I purposely placed some dash characters so that this site will not remove the word J-A-V-A-S-C-R-I-P-T from the code above.
Sue; you were close... Jus those extra parenthesis had to be removed!

Greate JOB!

mw_sql_developer SSCoach Points: 19445 More actions · Answer 11

mw112009 - Tuesday, November 14, 2017 3:29 PM
="j-a-v-a-s-c-r-i-p-t:void window.open(" &"'" & Globals!ReportServerUrl & "/Pages/ReportViewer.aspx?" & Globals!ReportFolder & "/SubReportWithMemberInfoUsedByWaiverFinance&rc:Parameters=False&RepParameterSet=50,>64,E," & Fields!YYYYMM.Value & "','_blank')"
I purposely placed some dash characters so that this site will not remove the word J-A-V-A-S-C-R-I-P-T from the code above.
Sue; you were close... Jus those extra parenthesis had to be removed!
Greate JOB!

THANKS EVERYONE IT WORKS!

Sue_H SSC Guru Points: 90860 More actions · Answer 12

mw112009 - Tuesday, November 14, 2017 3:29 PM
="j-a-v-a-s-c-r-i-p-t:void window.open(" &"'" & Globals!ReportServerUrl & "/Pages/ReportViewer.aspx?" & Globals!ReportFolder & "/SubReportWithMemberInfoUsedByWaiverFinance&rc:Parameters=False&RepParameterSet=50,>64,E," & Fields!YYYYMM.Value & "','_blank')"
I purposely placed some dash characters so that this site will not remove the word J-A-V-A-S-C-R-I-P-T from the code above.
Sue; you were close... Jus those extra parenthesis had to be removed!
Greate JOB!

Interesting....it was taken from a report working on a couple of servers so I would bet that wouldn't have been it. It could be that your tests had one extra parenthesis from what I can tell. If you ignore the javascript void, etc and start at the first parenthesis you were trying: (window.open('http://www.google.com','_blank');"
That's how it pasted anyway.
Pasting or inserting hyperlinks can sometimes be a nightmare with this forum software. I given up at least a couple of times every week.

Sue

mw_sql_developer SSCoach Points: 19445 More actions · Answer 13

I removed the parenthesis between the words VOID and window.OPEN . That is the only major difference. Now it works!