Hi All,

Please help me to select tables in order to create Report for Sales CQ 8.1C using SAP CR 2013 as per attached example.

Thank you.
Victor

Hello Victor,

If you have the report defined in Crystal 8.5, then open the report in that version of Crystal and select the same fields from the ODBC connection in Crystal 2013. The names of the fields have only undergone minor changes to conform to ODBC naming conventions.

You can use the DataDictionary Exporter tool, installed with all Adagio modules, to place the SalesCQ dictionary in Excel. Use /ODBC on the command line to get the fields named by their ODBC compliant names.

Hi Andrew,

Thank you for your reply.
Tables in CR 8.5:
CQW81 O/E Quote Header
CQW81 O/E Quote Detail

It looks like I need to use the following tables:
ACOEQuoteHeader__aa81coqx
ACOEQuoteHeader__aa81coqx

In SAP CR 2013 using ODBC impossible to select two tables (as soon is one selected adding anothe table crashes the CR)
Please let me know if I'm selecting right tables and how to link them.

Thank you very much.
Victor

Perhaps it's a typo on your part, but your second table should be ACOEQuoteDetail_. Unfortunately, CQ doesn't have a composite to join these tables for you. I'm not even sure that a composite can be wired to a report.

Crystal crashing when two tables are linked is a Crystal error. Try the remedies in the linked post.