Report Header Tags (Additional)
To create a report you can add various tags allowing you to specify various parameters. These tags can be written anywhere in the query so that they can be reported as a simple comment.
To specify external data, use the following tags. You can create Header Tags using the Report Templates Management dialog box.
| /*InputData:=Param1,Param2*/ | Used to replace a string value in the report query by another user value. |
| Param1 (String) | - Question regarding the expected value |
| Param2 (String) | - Value to be replaced in the global Query |
| /*InputList:=Param1,Param2; Query:=SqlQuery*/ | Used to replace a string value in the report query by another user value selected in List. |
| Param1 (String) | - Question regarding the expected value |
| Param2 (String) | - Value to be replaced in the global Query |
| SqlQuery (String) | - SQL statement with value in first column |
| Please note that you must NOT use a variable name (EXTERNAL DATA) with the ">" character if you need to use the .HSQ file in the Command Line, because this character is a redirection character. | |
| /*InputList:=Param1,Param2; Values:=Value1|Value2|...*/ | Used to replace a string value in the report query by another user value in List |
| Param1 (String) | - Question regarding the expected value |
| Param2 (String) | - Value to be replaced in the global Query |
| Value1.. (String) | - Value list separated by | (pipe) |
| /*InputGrid:=Question,VARIABLE; Query:=select xxxxx*/ | Used to replace a string value in the report query by another user value in grid format (multiple choice check boxes). The result of this selection will be displayed in the form Row1,Row2,Row3 etc. that can be used in a "like2: Col like (VARIABLE) |
| Question (String) | - Question regarding the expected value |
| Variable (String) | - Value to be replaced in the global Query |
| Select (String) | - Required SQL query |
 Notes
| |
| Other Tags | |
| Include:= | Used for including a file in another. For example: /*Include:=FileName.hsq*/ |
| Tags not visible to the user | |
| Description:= | Description of HSQ file: /*Description:=descriptiontext*/ |
| FileTitle:= | Title of HSQ file: /*FileTitle:=filetitle*/ |
Before starting, HTML Report will open a dialog box with the Question (Param1) and wait for you to input an answer. Once the value has been entered, HTML report will then replace each occurrence of the variable (Param2) with your response.
For Example:
/*InputData:=Please specify a Table name for the report,TABLE_NAME_VARIABLE*/
/*#CwDocTab#Lev:=.......*/
Select ....
Where TabNam='TABLE_NAME_VARIABLE' <- this string will be replaced by the user value
See Also
Report Header Tags | Report Templates Management dialog box
