BI Report Formatting Guidelines

Query Tab

Ø  If only one query, name it ‘Query_report name’.  If multiple, it should have the ‘Query_’ prefix with something that reflects the query’s purpose. (e.g. The name of the fact table it uses)

Report Tab

Ø  If only one tab, it should match the report title.  If multiple, it should briefly reflect the purpose of the sub-report.

Report Header

Ø  Report Title – Arial, Bold, Left Aligned, (should match report name, font sizes may vary)

Ø  NO Refresh Date!

Report Block

Ø  Column Headers – Arial, 9 (font size may vary), Bold, Wrapped, Auto Height, Measures Right Justified, Dimensions Left Justified

Ø  Table Data – Arial, 8 (font size may vary), Measures Right Justified, Dimensions Left Justified

Note ----> Font can be changed based on your requirement

Page Header / Footer

Ø  Nothing to be placed in the header, choose to not display it or make it smaller

Ø  Footer should contain the page number – Arial, 10, Right Justified

o   Displayed as:     Page 1 of 5

o   Formula ="Page "+Page()+" of "+NumberOfPages()

Paper Size / Page Orientation

Pick from these options:

Paper Size	Page Orientation
Letter	Portrait/Landscape
Letter	Landscape
Legal	Landscape

Printing

Ø  Ask BI&A Functional Analyst about the default print output for the report and tailor the report for best viewing in that output

o   i.e. PDF or Excel

§  Adjust margins accordingly