Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Aptify strongly recommends that you use the base views in the entity definition database (typically, Aptify) as the source for SSRS reports rather than the base tables.
  • Aptify reports are list-driven. When you run a report, the system first creates a List that contains the records from the specified view. The system then uses this List as the source for the SSRS report. Therefore, to display the correct records in the report, you must add the vwListDetail base view as a data source for the report and link the vwListDetail.RecordID field to the ID field of the report's service.

    Info

    If you create an SSRS report that does not include vwListDetail as a data source, the report will display all records in the service rather than only those displayed in the selected view.

  • Do not define any Record Selection filters within SSRS reports, or attempt to create a report from a specific set of records from the selected view . Any filtering of the records should be done in the selected view.
  • Aptify provides two sample SSRS reports, Person Roster_SSRS (for Persons) and Invoice_SSRS (for Orders), with the baseline Aptify product. You can use either of these reports as a starting point for your custom reports.
  • Your SSRS report file (*.rdl) should be stored in a folder on the SSRS report server. 
  • Create an Object Repository Object record for your SSRS report. See the "Creating Object Repository Objects" section in the Object Repository chapter of the Aptify 5.5.1 Administration Guide for more details.
  • Add the new SSRS report to an entity as described in Adding Reports to an Entity.
     

...