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]

      ,[FieldName]

      ,[FieldOrder]

      ,[Type]

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

GO


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