About SSRS reports

Infor Mongoose can be used to create and generate SQL Server Reporting Services (SSRS) reports.

Note: Although Mongoose still supports the creation and production of SSRS reports, they are now deprecated. Instead, we encourage the use of the Report type form or DataViews to create reports within Mongoose.

As with other types of reports, SSRS reports are typically made up of different sections. Most reports have these sections:

Page header
Report header
Data section
Page footer

Some reports include additional features, such as notes.

SSRS has four container classes. Three of these are subclasses of the Tablix class: Lists, Tables, and Matrices. The fourth container class is the Rectangle. Data stored in a Tablix object can be filtered, sorted, and grouped. Tablix objects also change their size and shape to best fit the space provided by a particular output format. Rectangles are used to contain other objects, like tablix objects, textboxes, images, and so on. Rectangles are useful to restrain the movement of objects, such as tables, as they grow. This is especially important for reports like "label reports," where precise control of object positioning is required.

In general, most reports use a rectangle for the report header, page header, page footer, and one or more tables for detail data. In some instances, where there is a parent-child relationship to data, a list format can be used for the parent data, and one or more tables for the child data.

Virtually any element or component of an SSRS report can be formatted independently of the others. You can format the backgrounds of each section separately, and the text fonts and colors as well.