How do I access a specific report with parameters using a URL?
17 December, 2015
I have created Guest role and user, and it is indeed possible to access the report using a funky URL like:
http://my_server/RunReport.i4;01c3fed5-35c1-4ab8-b758-697309f43f97=28ee661f-fca1-4dac-9a93-72bc663bbe34?reportUUID=dd256635-333b-41fc-a6d1-26c0478852c5&primaryOrg=1&clientOrg=12001&01c3fed5-35c1-4ab8-b758-697309f43f97=28ee661f-fca1-4dac-9a93-72bc663bbe34
1)
This URL is not very user friendly. I would prefer something like:
http://my_server/RunReport.i4?ReportName=MyReport1
Is this possible?
2)
The report is defined with a userprompt filter.
How do I pass the value to be used in the filter in the URL?
http://my_server/RunReport.i4;01c3fed5-35c1-4ab8-b758-697309f43f97=28ee661f-fca1-4dac-9a93-72bc663bbe34?reportUUID=dd256635-333b-41fc-a6d1-26c0478852c5&primaryOrg=1&clientOrg=12001&01c3fed5-35c1-4ab8-b758-697309f43f97=28ee661f-fca1-4dac-9a93-72bc663bbe34
1)
This URL is not very user friendly. I would prefer something like:
http://my_server/RunReport.i4?ReportName=MyReport1
Is this possible?
2)
The report is defined with a userprompt filter.
How do I pass the value to be used in the filter in the URL?
Hi Guest,
Thanks for sending in the questions. Hopefully we can help provide some clarification!
[quote="">1) This URL is not very user friendly. I would prefer something like:
http://my_server/RunReport.i4?ReportName=MyReport1
Is this possible?[/quote]
Your report URL definitely looks a bit over-complicated, but regardless of that, unfortunately you cannot reference a report via 'ReportName' (as mentioned in your example). As it stands, 'reportUUID' or 'reportID' must be used.
For Example:
http://localhost:7171/RunReport.i4?reportUUID=370cf271-0b78-4e55-ba81-cf4a71e29acf&primaryOrg=1&clientOrg=1
Apologies if this doesn't present the most user friendly look/feel.
[quote="">2)The report is defined with a user prompt filter. How do I pass the value to be used in the filter in the URL?[/quote]
This is possible by adding the filter + filter ID to the end of the report URL.
'&filter'+filterID='YourFilteredValue'
For example:
http://localhost:7171/RunReport.i4?reportUUID=879d3175-1d40-4495-a4d4-45a24e781e53&primaryOrg=1&clientOrg=1&filter55558=Asia
The only tricky part here is identifying the filter ID. The easiest solution I've found is to right click the filter entry box in your browser (I used chrome) and click inspect element:
The element containing the filter ID should be automatically highlighted:
You should then be able to use that numeric value (highlighted in yellow) with the previously mentioned syntax to add a filter to your report URL.
Anyway, hopefully this information has been helpful. Please let us know if you have any other questions or concerns.
Kind Regards,
Dustin
Thanks for sending in the questions. Hopefully we can help provide some clarification!
[quote="">1) This URL is not very user friendly. I would prefer something like:
http://my_server/RunReport.i4?ReportName=MyReport1
Is this possible?[/quote]
Your report URL definitely looks a bit over-complicated, but regardless of that, unfortunately you cannot reference a report via 'ReportName' (as mentioned in your example). As it stands, 'reportUUID' or 'reportID' must be used.
For Example:
http://localhost:7171/RunReport.i4?reportUUID=370cf271-0b78-4e55-ba81-cf4a71e29acf&primaryOrg=1&clientOrg=1
Apologies if this doesn't present the most user friendly look/feel.
[quote="">2)The report is defined with a user prompt filter. How do I pass the value to be used in the filter in the URL?[/quote]
This is possible by adding the filter + filter ID to the end of the report URL.
'&filter'+filterID='YourFilteredValue'
For example:
http://localhost:7171/RunReport.i4?reportUUID=879d3175-1d40-4495-a4d4-45a24e781e53&primaryOrg=1&clientOrg=1&filter55558=Asia
The only tricky part here is identifying the filter ID. The easiest solution I've found is to right click the filter entry box in your browser (I used chrome) and click inspect element:
The element containing the filter ID should be automatically highlighted:
You should then be able to use that numeric value (highlighted in yellow) with the previously mentioned syntax to add a filter to your report URL.
Anyway, hopefully this information has been helpful. Please let us know if you have any other questions or concerns.
Kind Regards,
Dustin