Smartstaff
286
edits
Changes
Add details on how to pass criteria through within the URL
== 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.
'''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.
** This must be repeated for every criteria prompt configured on the report otherwise the results will not display.
* '''criteriatext''' is the @variable@ or criteria text you wish to pass to the criteria input specified.
==See Also==