Difference between revisions of "Criteria Template"

From SmartWiki
Jump to: navigation, search
(Variables)
Line 1: Line 1:
 +
__TOC__
 +
 
The Criteria Template section on the [[Report Template]] tab of the [[Creating a Basic Report|Edit Report Page]] defines the criteria section of a custom report template containing the prompt(s) for report [[parameter]](s) when [[criteria|report criteria]] are used.
 
The Criteria Template section on the [[Report Template]] tab of the [[Creating a Basic Report|Edit Report Page]] defines the criteria section of a custom report template containing the prompt(s) for report [[parameter]](s) when [[criteria|report criteria]] are used.
  

Revision as of 09:37, 1 October 2013

The Criteria Template section on the Report Template tab of the Edit Report Page defines the criteria section of a custom report template containing the prompt(s) for report parameter(s) when report criteria are used.

The Criteria Template section accepts HTML code. When the Criteria Template is used, the report parameter prompt does not manifest as a pop-up when the report is run, but remains at the top of the page.

Example: A simple report is built as follows that prompts the user for the first name of a contact when run:

CriteriaTemplate-ReportBuilder.png

The default prompt for the report will appear as follows, a concatenation of the recordset and field name specified in the Report Builder:

CriteriaTemplate-DefaultPrompt.png

Right click on the page and choose the option in your browser that will expose the page HTML source. Then scroll down to and copy the section that contains the criteria table:

CriteriaTemplate-SourceTable.png

Then go to your Edit Report page, select the Report Template tab and paste the HTML code for the criteria table into the Criteria Template section:

CriteriaTemplate-PasteIntoTemplate.png

You can then edit the HTML code:

CriteriaTemplate-EditedTemplate.png

The resultant report, when run, will contain the criteria section you have defined at the top of the report:

CriteriaTemplate-ResultantReport.png


Variables

To show certain buttons on the criteria page, you can reference variables in the Criteria Template:

  • @submitbutton@
  • @exportbutton@
  • @fileexportbutton@

Notes

  • The Criteria template is not rebuilt when the report is rebuilt.

See Also