Crystal Reporting
Previous Topic  

How you access Crystal reports on supplied by ERSA is beyond the scope of this document..

Once into your Database, using your server connection information already supplied with the correct user ID and Password..

a crystal  report on this table rbh_tableview_TableStructures like this

SELECT [TableName]




  FROM [dbo].[rbh_tableview_TableStructures] where TableName like 'diag%'


substitute "RBH" with your Company TLA when you write your query

will give you the location of fields and tables

you could add further qualifications, e.g.

where fieldname like '%criteria%' to find tables and views with admission criteria

The Table tblTableStructures is updated here in the Talons Menu Application Setup