Home > Features > Layout

Layout

---

Report Layout

ReportsDNA can generate a report using one of two formats: Table or Template.

Table

This layout will display load the data set directly into the current worksheet. It will display a row of field names followed by the data.

Example

ID	First Name	Last Name	Order
1	Jane	Doe	Milk
2	John	Doe	Butter
3	Eleni	Smith	Eggs

Template

This layout provides greater flexibility and allows for more advanced report formatting then Table Layout. It uses another worksheet as a template to detail how the report should be displayed. See Templates for additional information on their use.

Warning: Conditional formatting defined intin the template is lost if Group By is used in conjunction with Template layout.

---

Report Location

Use this feature to identify the location where you want the report generated. For example, if value is C5, then the report will start at cell C5 and columns will populate to the right, rows will populate down from that point.

Default value (if left blank): A4
Allowable Values: This field must be populated with the correct name of a cell on the spreadsheet.

---

Date/Time

ReportsDNA will populate the cell specified in this field with the report’s date/timestamp execution. This is useful to show when the report was generated.

Default value (if left blank): feature will be inactive
Allowable Values: This field must be populated with the correct name of a cell on the spreadsheet.

---

Record Count Text

ReportsDNA will store the number of records returned by the data source in the cell specified in this field.

Default value (if left blank): feature inactive
Allowable Values: This field must be populated with the correct name of a cell on the spreadsheet.

---

Center Header

Text specified here will be placed in the center section of the report's header.

Default value (if left blank): feature inactive
Allowable Values: Any text, Variables

See also