•CSV
There are not a lot of style/branding options for the .CSV output of reports, but you can include the criteria that was used to generate the report (similarly to the HTML output).
1.Open the Registry from the AudienceVie Desktop.
2.Navigate to the System::Application::Business Intelligence and Reports::Report Output node.
3.Enter yes in the 'CSV Criteria Headers Enabled (yes/no)' field.
This is set to no, by default.
4.Click 'Apply'.
A banner confirms that the Registry was updated.
You can configure the following report and BI output styles to meet your needs using the following Registry - System::Application::Business Intelligence and Reports::Reporting Styles nodes:
•Report Criteria Style: Defines the style of the report/BI criteria section at the top of the extract.
•Table Data Row Style: Defines the style of the rows that contain numerical data within tables.
•Empty Line Style: Defines the style of empty lines within the report/BI.
•Table Header Row Style Level 1: Defines the style of the primary header rows within tables.
•Table Header Row Style Level 2: Defines the style of the secondary header rows within tables.
•Table Header Row Style Level 3: Defines the style of the tertiary header rows within tables.
•No Result Table Style: Defines the style of the report when the selected criteria returns no results.
•Page Footer Style: Defines the style of the footer (page numbers).
•Report Session Information Style: Defines the style of the session information that appears in the uppermost line in the header.
•Report Title Style: Defines the style of the title.
•Table Total Row Style Level 1: Defines the style of the total rows within tables.
•Table Total Row Style Level 2: Defines the style of the subtotal rows within tables.
•Table Total Row Style Level 3: Defines the style of the sub subtotal rows within tables.
You can also add your company's logo to the top of extracted HTML and .PDF reports and business intelligence queries by adding the image's absolute URL to the Registry - Registry::EN::Application::Business Intelligence and Reports::Reports node's 'Header Logo Image' field. The logo will automatically scale to 140px wide by 70px high so the image should have a width to height ratio of 2:1. The same image is used for all reports and business intelligence extracts.
Each of the Reporting Style nodes listed above allow you to define the following style elements:
Field |
Description |
Background Color |
Defines the background colour of the report/BI. Click to select a colour. |
Font |
Defines the font. This is set to Helvetica, by default. |
Font Size |
Defines the font size in pts. |
Font Style |
Defines the font style: •normal •bold |
Height |
Defines the height of the section in pixels. The height is based on 100 dpi. If you want to set this field to an 81/2" you would enter 850 in the field. |
Padding |
Defines the padding within the cell/around text in pixels. This field is only applicable to the font nodes. |
Text Alignment |
Defines the alignment of the text within the section: •left •center •right |
Text Foreground Colour |
Defines the foreground colour of the report/BI. Click to select a colour. |
Width |
Defines the width of the section in pixels. The width is based on 100 dpi. If you want to set this field to an 11" you would enter 1100 in the field. |
Hint Labels within report outputs can be configured using the applicable Registry - Registry::EN::Application::Business Intelligence and Reports::Report Labels node. |