Changing the default layout for reports

Report layouts can be formatted to complement your organization’s corporate design standards. Out-of-the-box reports can be updated to modify physical characteristics such as Colors, Fonts, and Page size and margins (IQA reports only), by making changes to the Report formats settings on the Staff site.

Note: Reports that are created from an IQA query will no longer use the Report formats settings after they have been saved. For more information on options for saving your IQA generated reports, see Generating a standalone SSRS report using IQA.

Available layout parameters

The Report formats settings are located on the Staff site at Settings > RiSE > Report formats. To change your report layouts, enter a value for the parameter you wish to modify and Save your changes. The available parameters are as follows:

Colors

Note: You can use a color name available in SSRS, or a hex value for the colors.

  • Page header text (SSRS.PageHeaderForegroundColor)
    • Default - Black
  • Page header background (SSRS.PageHeaderBackgroundColor)
    • Default - White
  • Page footer text (SSRS.PageFooterForegroundColor)
    • Default - Black
  • Page footer background (SSRS.PageFooterBackgroundColor)
    • Default - White
  • Separator bars and organization name (SSRS.SeparatorLineColor)
    • Default - #02567B
  • Group header text (SSRS.GroupHeaderForegroundColor)
    • Default - Black
  • Group header background (SSRS.GroupHeaderForegroundColor)
    • Default - #A8E1E9
  • Column header text (SSRS.FieldHeaderForegroundColor)
    • Default - White
  • Column header background (SSRS.FieldHeaderBackgroundColor)
    • Default - #034D7D

Fonts

  • Page and column headers (SSRS.HeaderFont)
    • Default - Arial
  • Report detail (SSRS.DetailFont)
    • Default - Arial

Page size and margins (IQA reports only)

Note: These settings are only used by reports that are generated from the Report tab of an IQA query.

  • Unit of measure (SSRS.UnitOfMeasure)
    • Inches (in)
  • Page width: Portrait mode (SSRS.PortraitTotalWidth)
    • Default - 8.5
  • Page width: Landscape mode (SSRS.LandscapeTotalWidth)
    • Default - 11
  • Top margin (SSRS.TopMargin)
    • Default - .17
  • Bottom margin (SSRS.BottomMargin)
    • Default - .17
  • Left margin (SSRS.LeftMargin)
    • Default - .17
  • Right margin (SSRS.RightMargin)
    • Default - .17

Formatting user-created reports

For reports that are not IQA-based, users can create their own reports by modeling the template of the out-of-the-box iMIS reports.

To do this, download the SSRS Sample Template report from $/Samples/ReportingServices, then open the report in your SSRS reporting tool.