Omega - Support Information

Page Updated: 11-10-11

Reporting - Q&A

This page consolidates the FAQs and knowledge database articles from the previous site.

FAQs

What versions of Crystal Reports are compatible with the Omega database?
Any version of Crystal Reports able to access Pervasive.SQL/Btrieve, either natively or via ODBC (Omega for Windows v2.1+), should work. Over the years I have used succesfully the following versions: Version 6 for Btrieve, 7, 8, 8.5, 9 and 10.
 
How do I link notes in reports? What are note IDs?
Notes are stored in the table ie_notes_table and linked to their 'parent' record via the note ID (or note occurrence) + the index number of the parent itself. The note ID identifies the type of note, i.e. the database table of the parent, e.g. board, customer part, tool version, etc. The note IDs are are follows:

Parent Table

Note ID

Board (pd_boardlib_table)

11

Customer part (pd_custpart_table)

12

Customer revision (pd_partrevs_table)

13

Tool version (pd_versions_table)

14

Quote (qt_quotes_table)

15

Sales order (so_orders_table)

16

Works order (wo_wrksordr_table)

24

Despatch (ds_despatch_table)

55

Invoice (in_invoices_table)

27

Customer returns (cr_returns_table)

108

Credit note (in_invoices_table)

113

Knowledge database

No articles

 

This site is copyright 2003-2017 Neil Hughes. All rights reserved.
Company and product names on this site may be trademarks or registered trademarks and are hereby acknowledged.

Contact (Support)
Email: support@support4omega.co.uk
Skype: support4omega

Contact (Website/other)
Email: admin@support4omega