|
In order to simplify the process developing Web-based
reports, Chesapeake Data Systems has developed a product - the CDS Banded
Report Writer - that reads an “HTML Template” (which specifies both the
text that appears on the report and where the data is to be placed) and merges
the data from an SQL query or stored procedure. Within the
template, the analyst can specify “headers”, “detail lines”, and “footers”.
Additionally, fields can be summed, decimal points can be inserted, and records
can be counted.
The “HTML Template” uses the concept of “banded
reports”, with lines in the template specifying the various report components.
Layout instructions (e.g., for “control breaks” and “control sub totals”) are
specified by enclosing the “layout commands” between the characters “[[” and
“]]”. “Merge fields” for data are specified by enclosing the names of the
fields between the characters “<<” and “>>”. For example:
|
[[GroupHeader2]]<<BreakField2>> |
|
|
|
|
Group Header Label 2 <<BreakField2>> |
|
|
|
|
[[GroupHeader1]]<<BreakField1>> |
|
|
|
|
Group Header Label 1 <<BreakField1>> |
Labelx |
Labely |
Labelz |
|
[[Detail]] |
|
|
|
|
Detail Labels |
<<Fieldx>> |
<<Fieldy>> |
<<Fieldz>> |
|
[[GroupFooter1]] |
|
|
|
|
Group Footer Label 1
|
|
|
<<Sum Fieldz>> |
|
[[GroupFooter2]] |
|
|
|
|
Group Footer Label 2
|
|
|
<< Sum Fieldz>> |
|
[[ReportFooter]] |
|
|
|
|
Report Footer Label
|
<<SUM cnt>> |
|
<< Sum Fieldz>> |
Click a link
below to get more information on this product:
If you have any questions or suggestions or you
are interested in purchasing the report writer product, please email us at
info@chesdata.com |
