SSRS Report template

This ticket is to capture the standard report templates for Artena. Updated as part of standard reports review process 2017/2018.
----
h5. Template Links (template masters are kept in svn)

https://repo/svn/CustomWork/trunk/All/SMSS-19767

[Artena Standard Report Template - Portrait.rdl|https://jira.smss.org.nz/secure/attachment/94238/94238_Artena Standard Report Template - Portrait.rdl|Artena Standard Report Template - Portrait.rdl attached to SMSS-19767]^!https://jira.smss.org.nz/images/icons/link_attachment_7.gif!^

[Artena Standard Report Template - Landscape.rdl|https://jira.smss.org.nz/secure/attachment/94239/94239_Artena Standard Report Template - Landscape.rdl|Artena Standard Report Template - Landscape.rdl attached to SMSS-19767]^!https://jira.smss.org.nz/images/icons/link_attachment_7.gif!^

!pr_1.png!


----
h5. Template Layouts

*Portrait*

* *Report - PageSize*
** height - 29.7cm
** width - 21.0cm
* *Report - Margins*
** left - 1.0 cm
** right - 1.0 cm
** top - 0.5 cm
** bottom - 0.5 cm
* *Body - Size*
** Width - 19cm
** Height - varies with report
* *Page Header*
** Height = 2cm
** Image - Artena Logo
*** File :
[!https://jira.smss.org.nz/secure/thumbnail/94233/94233__thumb_94233.png!|https://jira.smss.org.nz/secure/attachment/94233/94233_ArtenaReportLogo.png|ArtenaReportLogo.png attached to SMSS-19767]
Original path : \\zodiac\Keep All Staff\Templates\Logos\Artena new\ArtenaReportLogo.png
*** Location: Left 0cm Top 0cm
*** Height : 2cm
*** Width : 2cm
 ** Text Box - Report Title
*** Location : Left 2cm. Top 0cm
*** Width : 17cm
*** Font: Arial, Bold, 22pt
*** Text alignment : Text Align : Left, Vertical Align : Middle
*** Padding : 10pt,2pt,2pt,2pt
*** Height: 2cm
* *Page Footer*
** Height = 0.8cm
** Line
*** Location: Left 0cm Top 0cm
*** Endpoint horizontal 19cm, vertical 0cm
** Text box - Date report run and by who
*** Location: Left 0cm Top 0.4cm
*** Height : 0.6cm Width : 13cm
*** Font: Arial, 8pt
*** Text alignment : Text Align : Left, Vertical Align : Middle
*** Expression - {quote}="Produced on " & Format(Now(),"yyyy-MM-dd") & " by " & User!UserID{quote}
** Text box - Page numbering
*** Location: Left 13cm Top 0.4cm
*** Height : 0.6cm Width : 6cm
*** Font: Arial, 8pt
*** Text alignment : Text Align :Right, Vertical Align : Middle
*** Expression - {quote}="Page " & Globals!PageNumber & " of " & Globals!TotalPages{quote}

----
*Landscape*

* *Report - PageSize*
** height - 21.0cm
** width - 29.7cm
* *Report - Margins*
** left - 1.0 cm
** right - 1.0 cm
** top - 0.5 cm
** bottom - 0.5 cm
* *Body - Size*
** Width - 27cm
** Height - varies with report
* *Page Header*
** Height = 2cm
** Image - Artena Logo
*** File :
[!https://jira.smss.org.nz/secure/thumbnail/94233/94233__thumb_94233.png!|https://jira.smss.org.nz/secure/attachment/94233/94233_ArtenaReportLogo.png|ArtenaReportLogo.png attached to SMSS-19767]
Original path : \\zodiac\Keep All Staff\Templates\Logos\Artena new\ArtenaReportLogo.png
*** Location: Left 0cm Top 0cm
*** Height : 2cm
*** Width : 2cm
 ** Text Box - Report Title
*** Location : Left 2cm. Top 0cm
*** Width : 25cm
*** Font: Arial, Bold, 22pt
*** Text alignment : Text Align : Left, Vertical Align : Middle
*** Padding : 10pt,2pt,2pt,2pt
*** Height: 2cm
* *Page Footer*
** Height = 0.8cm
** Line
*** Location: Left 0cm Top 0cm
*** Endpoint horizontal 27cm, vertical 0cm
** Text box - Date report run and by who
*** Location: Left 0cm Top 0.4cm
*** Height : 0.6cm Width : 13cm
*** Font: Arial, 8pt
*** Text alignment : Text Align : Left, Vertical Align : Middle
*** Expression - {quote}="Produced on " & Format(Now(),"yyyy-MM-dd") & " by " & User!UserID{quote}
** Text box - Page numbering
*** Location: Left 13cm Top 0.4cm
*** Height : 0.6cm Width : 14cm
*** Font: Arial, 8pt
*** Text alignment : Text Align :Right, Vertical Align : Middle
*** Expression - {quote}="Page " & Globals!PageNumber & " of " & Globals!TotalPages{quote}

----
*General Rules for Report Body*

* *Default Font*
** Arial, 10pt

* *Field heights and spacing*
** work in 0.6cm. A text field that is single line will be set to  0.6cm tall
** A space between rows set to 0.6cm

* *Table Headers*
** Arial, 11pt, bold

* *Dates*
** always set to "yyyy-MM-dd"