4D v14.3
QR SET HTML TEMPLATE
- 4D Language Reference
-
- Quick Report
-
- QR BLOB TO REPORT
- QR Count columns
- QR DELETE COLUMN
- QR DELETE OFFSCREEN AREA
- QR EXECUTE COMMAND
- QR Find column
- QR Get area property
- QR GET BORDERS
- QR Get command status
- QR GET DESTINATION
- QR Get document property
- QR Get drop column
- QR GET HEADER AND FOOTER
- QR Get HTML template
- QR GET INFO COLUMN
- QR Get info row
- QR Get report kind
- QR Get report table
- QR GET SELECTION
- QR GET SORTS
- QR Get text property
- QR GET TOTALS DATA
- QR GET TOTALS SPACING
- QR INSERT COLUMN
- QR New offscreen area
- QR ON COMMANDUpd
- QR REPORT TO BLOB
- QR REPORTUpd
- QR RUN
- QR SET AREA PROPERTY
- QR SET BORDERS
- QR SET DESTINATIONUpd
- QR SET DOCUMENT PROPERTY
- QR SET HEADER AND FOOTER
- QR SET HTML TEMPLATE
- QR SET INFO COLUMN
- QR SET INFO ROW
- QR SET REPORT KIND
- QR SET REPORT TABLE
- QR SET SELECTION
- QR SET SORTS
- QR SET TEXT PROPERTY
- QR SET TOTALS DATA
- QR SET TOTALS SPACING
QR SET HTML TEMPLATE
| QR SET HTML TEMPLATE ( area ; template ) | ||||||||
| Parameter | Type | Description | ||||||
| area | Longint |
|
Reference of the area | |||||
| template | Text |
|
HTML template | |||||
The QR SET HTML TEMPLATE command sets the HTML template currently used for the Quick Report area. The template will be used when building the report in HTML format.
The template uses a set of tags to process the data in order to either retain a layout close to the original report or to adopt your own custom HTML.
Note: You first need to call QR SET DESTINATION to set the output to HTML file.
<!--#4DQRheader--> ... <!--/#4DQRheader-->
The HTML contents that are included between these tags come from the column titles. You will typically use these tags to define the title row of the report.
<!--#4DQRrow--> ... <!--/#4DQRrow-->
The HTML contents that are included between these tags are repeated for each data row (including detail and subtotal rows).
<!--#4DQRcol--> ... <!--/#4DQRcol-->
The HTML contents that are included between these tags are repeated for each data column within a row. The column order will remain identical to the order in the report. When used in conjunction with <!--#4DQRcol;n--> ... <!--/#4DQRcol;n-->, the tags <!--#4DQRcol--> ... <!--/#4DQRcol--> will only go through the columns whose contents are not inserted using <!--#4DQRcol;n--> ... <!--/#4DQRcol;n-->.
For example, in a report that has five columns, you choose to use <!--#4DQRcol;2--> ... <!--/#4DQRcol;2--> to insert data from the second column, <!--#4DQRcol--> ... <!--/#4DQRcol--> will go, for each row, through columns 1, 3, 4, and 5. These last tags ignore the column whose contents are published using <!--#4DQRcol;2--> ... <!--/#4DQRcol;2-->.
<!--#4DQRcol;n--> ... <!--/#4DQRcol;n-->
The HTML contents that are included between these tags are extracted from the column in the report whose number is “n”. If, for example, you want to display a different column order in the HTML output for a three-column report, you could use:
<!--#4DQRrow--> <!--#4DQRcol;3--> ... <!--/#4DQRcol;3--><!--#4DQRcol;2--> ... <!--/#4DQRcol;2--><!--#4DQRcol;1--> ... <!--/#4DQRcol;1--> <!--/#4DQRrow-->
In this example, the columns are inserted in the opposite order of the report.
<!--#4DQRfont--> ... <!--/#4DQRfont-->
The HTML contents that are included between these tags will be assigned the font of the current column or cell.
<!--#4DQRfont--> will be replaced by an HTML font definition and <!--/#4DQRfont--> will be replaced by the matching closing tag (</font>).
<!--#4DQRface--> ... <!--/#4DQRface-->
The HTML contents that are included between these tags will be assigned the font style of the current column or cell.
<!--#4DQRface--> will be replaced by an HTML face definition and <!--#4DQRface--> will be replaced by the matching closing tag (</face>).
<!--#4DQRbgcolor-->
This color tag will be replaced by the current color for the current cell.
<!--#4DQRdata-->
This tag will be replaced by the current data for the current cell.
<!--#4DQRlHeader--><!--#4DQRdata--><!--/#4DQRlHeader-->
<!--#4DQRcHeader--><!--#4DQRdata--><!--/#4DQRcHeader-->
<!--#4DQRrHeader--><!--#4DQRdata--><!--/#4DQRrHeader-->
These tags will be replaced respectively by the data in the left, center or right header.
<!--#4DQRlFooter--><!--#4DQRdata--><!--/#4DQRlFooter-->
<!--#4DQRcFooter--><!--#4DQRdata--><!--/#4DQRcFooter-->
<!--#4DQRrFooter--><!--#4DQRdata--><!--/#4DQRrFooter-->
These tags will be replaced respectively by the data in the left, center or right footer.
If you pass an invalid area number, the error -9850 will be generated.
Product: 4D
Theme: Quick Report
Number:
750
Created: 4D 2003
4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)
