Cannot see all database views in Crystal Reports



Description of Issue

Users unable to view some views in Crystal Reports



Context
  • Munis all versions

  • Self-hosted, OnPrem Clients

  • Tyler Hosted, SaaS Clients



Cause

Crystal reports application hides some database views when there are too many to objects to list



Resolution
  1. In Crystal Reports application, click File in the top menu and select Options

  2. Click Database Tab.

  3. In the area named Data Explorer, uncheck Stored Procedures option.

  4. Click OK

Restart the Crystal Reports application. All database views will now be visible.



Additional Information