Using CR to write custom reports

I'm new with HQ but familiar with CR 8.5. I need to do a custom report utilizing the item table and need to know how to connect to the HQ DB. Using CR and from what I read the best way to connect to the HQ DB is using Ole DB, but I am not familiar with the DB structure. Does anybody has a datadictionary for the HQ DB?

Can someone please provide instruction in how to connect to the HQ DB?

Thanks.

Reply to
Carlos
Loading thread data ...

You can run Enterprise Manager or SQL Server Management Studio to connect to the database. There are no meta tables so each table and field has a relatively understandable name.

Management Studio is also helpful for writing advanced queries.

J Gill

formatting link

Reply to
J Gill

I'm new with HQ but familiar with CR 8.5. I need to do a custom report utilizing the item table and need to know how to connect to the HQ DB. Using CR and from what I read the best way to connect to the HQ DB is using Ole DB, but I am not familiar with the DB structure. Does anybody has a datadictionary for the HQ DB?

Can someone please provide instruction in how to connect to the HQ DB?

Thanks.

Reply to
Jeff

Reply to
GeneTreads

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.