Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

String Field probs in CR10 / CE10 on a DB2 / UDB db

Status
Not open for further replies.

BruceBussell

Programmer
Jul 14, 2003
49
US

We are running CR10 / CE10 on a DB2 / UDB database on a backend Unix system, from an NT client.

Our local CR10 Report Designer environment uses ODBC and the CE10 backend uses DB2 drivers.

CR10 Report Designer interprets the DB2 / UDB String fields as TWICE as long as the db says they are. (ie) Db = String 12, but CR10 Report Designer shows it as String 24.

Then CE10 will not print or group on these DB2 / UDB String fields unliss we do Trim(Field) on each string field that we use in a report.

A report with many trimmed fields runs OK in CR10, but the report is VERY SLOW when we run the reports on the web using CE10, so that we have to close out the web page after 30 min plus.

Anybody know of a solution to our db/String handling problemn here. Could it be an ODBC or DB2 driver issue.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top