...
- 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.
- In general, do Do not define any Record Selection filters within SSRS reports. Filtering within the report itself can result in incomplete reports that do not contain all of the records in a , 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.
- You can find a report's SSRS report (*.rdl) file in the C:\Program Files\Aptify 5.5 folder on a client computer that has recently run the report.
- Alternatively, you can download the report file to your client computer's C:\Program Files\Aptify 5.5 folder by right-clicking the report's Object Repository Objects record in the Object Repository Administration dashboard and selecting Download Object from the pop-up menu.
- If the entity in which the report is to be associated with has field level security enabled, the Verify on First Refresh option must be cleared under the Crystal Report Options.
...