You've written a SQL Report that uses SQL Variables so that users can filter the output. The report's filters work fine, but you want two changes to the system-generated 'Define survey variables' screen: 1) Change the screen title and 2) Automatically click the 'Keep Visible' field. Here's how to make it happen.
To start here's the original system generated screen:
1) Right click on the 'Define survey variables' screen and select 'Edit Item Placement Configuration' from the context menu.
2) Enter the desired screen name in the Item Placement Tool's Description field. Click the 'Use description as form title'
3) Create a Universal Function of the Type = Macro. This UF should contain the following single command:
4) Save the UF and the IPT
5) Re-run the SQL Report and the changes are applied.
Here are the IPT and the UF:
The same UF can be used by any number of SQL Reports, but a separate IPT must be created for each unique Formtype Suffix used in the SQL Reports. (In this example the SQL Report's Formtype Suffix is set to 'BP'.)
Please sign in to leave a comment.