Installation and Upgrade Guides › Policy Server Installation Guide › Prerequisites for Running Reports Using Crystal Reports › Modify SiteMinder Reports to Use the Crystal Reports Data Source

Modify SiteMinder Reports to Use the Crystal Reports Data Source

By default, all of the SiteMinder reports .rpt files installed in the <siteminder_installation>\reports directory are configured to use the SiteMinder Reports Data Source, which is the data source that allows Crystal Reports to read from the logging database. If your Crystal Reports data source name does not match SiteMinder Reports Data Source, then you will have trouble running reports. You modify each reports file so that it uses the Crystal Reports data source name you created when you configured your ODBC Crystal reports data source.

To modify SiteMinder reports to user the Crystal Reports data source

1. Go to Start, Programs, Crystal Reports.
2. Open one of the SiteMinder Activity, Intrusion, Administrative, or Time Series reports (.rpt) files in Crystal Reports.
3. Select Database, Set Datasource Location.
4. Under Replace with, in the Set DataSource Location dialog, expand Create New Connection, ODBC (RDO).
5. Under Data Source name, in the ODBC (RDO) dialog, select the Crystal Reports data source name you created and click Next.
6. In the next ODBC (RDO) dialog:
   1. Enter the user name and password of the user who administers the Policy Server’s logging database.
   2. Make sure the correct name of the Policy Server’s logging database appears in the Database drop down menu.
   3. Click Finish.
7. Under Replace with, in the Set DataSource Location dialog:
   1. Expand <logging_database> -> dbo -> Stored Procedures.

      logging_database

      Specifies the name of the Policy Server’s logging database.

      Example: 60logs.

   2. Highlight the report name under Stored Procedures and under Current Data Source at the top of the dialog.

      Example: SmGetIntrusionAll;1

   3. Click Update.
8. In the Enter Parameter Values dialog, enter the appropriate parameters you want.

   Note: Oracle supports dates in the mm/dd/yyyy format. SQL database supports dd/mm/yyyy.

9. Click Close and save the report.
10. To preview the report, select Report, Refresh Report Data.

Note: To view SiteMinder reports using Crystal Reports, see the Policy Server Management guide.

More Information:

Configure an Oracle ODBC Crystal Reports Data Source

Configure a SQL Server ODBC Crystal Reports Data Source