Difference between revisions of "Report URL"
From SmartWiki
Lorena Ruiz (talk | contribs) |
|||
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| + | == Linking to a Specific Report == | ||
| + | |||
In order to add a link to a specific report to a [[portal]], or to create a link elsewhere in the system, you need the [[URL]] of the report in question. | In order to add a link to a specific report to a [[portal]], or to create a link elsewhere in the system, you need the [[URL]] of the report in question. | ||
| Line 16: | Line 18: | ||
The syntax for the report URL will be: | The syntax for the report URL will be: | ||
| − | http://''your url''/userreport/ur_viewreport.jsp?nextlevel=1&reportid='' | + | http://''your url''/userreport/ur_viewreport.jsp?nextlevel=1&reportid=''report id''&reportname=''report name'' |
where: | where: | ||
''your url'' is the URL used to access your copy of SmartSimple, for example ''grants.smartsimple.us'' | ''your url'' is the URL used to access your copy of SmartSimple, for example ''grants.smartsimple.us'' | ||
| − | '' | + | ''report id'' is the [[reportid|unique ID number of the report]] |
''report name'' is the name of your report, with spaces between words replaced with the plus sign "+" | ''report name'' is the name of your report, with spaces between words replaced with the plus sign "+" | ||
| + | |||
| + | '''NOTE:''' If you do not include the report name parameter then the report will display with the stored report name. | ||
| + | If the report link has a report name parameter included then the report displays with the name passed in the parameter. | ||
| + | |||
| + | == Passing Criteria into a Report via the URL == | ||
| + | |||
| + | If the report is configured to prompt for criteria and you would like to pass the criteria through within the URL using a variable or hard-coded text, the syntax is: | ||
| + | |||
| + | http://''your url''/userreport/ur_openreport.jsp?nextlevel=1&reportid=''report id''&reportname=''report name''&''cf_x_123456''=''criteriatext'' | ||
| + | |||
| + | * '''ur_openreport.jsp''' will tell the system to open the results of the report (bypass the criteria prompt screen) | ||
| + | * '''cf_x_123456''' is the html field id of the input field for the criteria as displayed within the report criteria prompt screen. | ||
| + | ** ''x'' represents the order in which the criteria is prompted (starting at 0). | ||
| + | ** ''123456'' represents the unique id given the prompt field. | ||
| + | ::- To retrieve this criteria prompt identifier, run the report normally to bring up the criteria prompt page. | ||
| + | ::- Right-click on the prompt input field with your mouse and select Inspect or Inspect Element. | ||
| + | ::- A portion of the HTML code for the page will display and the selected element will be highlighted. Within the highlighted section, search for the text within '''id="'''''cf_0_1050_0'''''"'''. | ||
| + | ::- Copy the ID for use in your URL. Repeat for all prompts on the page. | ||
| + | * '''criteriatext''' is the @variable@ or criteria text you wish to pass to the criteria input specified. | ||
| + | |||
| + | |||
==See Also== | ==See Also== | ||
* [[reportid|Determining the report ID]] | * [[reportid|Determining the report ID]] | ||
* [[Creating a Portal Interface]] | * [[Creating a Portal Interface]] | ||
| + | * [[Creating a Public – Internet Enabled Report]] | ||
[[Category:Reports]] | [[Category:Reports]] | ||
Latest revision as of 14:26, 12 July 2017
Linking to a Specific Report
In order to add a link to a specific report to a portal, or to create a link elsewhere in the system, you need the URL of the report in question.
To retrieve the report's URL:
- Hover your cursor over the Run Report icon
for the report whose URL you wish to retrieve. - Right-click on the icon and copy the link location*.
- Paste the report URL into a word processing program, or directly into the URL setting on the Portal Set-up page.
* Note: different Internet browsers use different terminology for copying the link location. Mozilla Firefox uses Copy Link Location Internet Explorer uses Copy Shortcut Chrome uses Copy link address etc.
The syntax for the report URL will be:
http://your url/userreport/ur_viewreport.jsp?nextlevel=1&reportid=report id&reportname=report name where: your url is the URL used to access your copy of SmartSimple, for example grants.smartsimple.us report id is the unique ID number of the report report name is the name of your report, with spaces between words replaced with the plus sign "+"
NOTE: If you do not include the report name parameter then the report will display with the stored report name. If the report link has a report name parameter included then the report displays with the name passed in the parameter.
Passing Criteria into a Report via the URL
If the report is configured to prompt for criteria and you would like to pass the criteria through within the URL using a variable or hard-coded text, the syntax is:
http://your url/userreport/ur_openreport.jsp?nextlevel=1&reportid=report id&reportname=report name&cf_x_123456=criteriatext
- ur_openreport.jsp will tell the system to open the results of the report (bypass the criteria prompt screen)
- cf_x_123456 is the html field id of the input field for the criteria as displayed within the report criteria prompt screen.
- x represents the order in which the criteria is prompted (starting at 0).
- 123456 represents the unique id given the prompt field.
- - To retrieve this criteria prompt identifier, run the report normally to bring up the criteria prompt page.
- - Right-click on the prompt input field with your mouse and select Inspect or Inspect Element.
- - A portion of the HTML code for the page will display and the selected element will be highlighted. Within the highlighted section, search for the text within id="cf_0_1050_0".
- - Copy the ID for use in your URL. Repeat for all prompts on the page.
- criteriatext is the @variable@ or criteria text you wish to pass to the criteria input specified.
