Symptom
I am using a report template (this template was created with Oracle database) to generate report for PostgreSQL database.
I use RowsetController.GetSQLStatement() function to get the query from the report template, in order to print the query in a trace file.
The query I get looks like this:
SELECT "TABLE_NAME"."COLUMN_1" FROM "TABLE_NAME" "TABLE_NAME" WHERE ("TABLE_NAME"."COLUMN_1">={ts '1899-12-30 00:00:00'} AND "TABLE_NAME"."COLUMN_1"<{ts '2014-09-27 00:00:00'})
But in PostgreSQL database, table and column names are in small letters.i.e. table_name column_1
After removing quotes the query would look like this SELECT TABLE_NAME.COLUMN_1 FROM TABLE_NAME TABLE_NAME WHERE (TABLE_NAME.COLUMN_1>={ts '1899-12-30 00:00:00'} AND TABLE_NAME.COLUMN_1<{ts '2014-09-27 00:00:00'})
Read more...
Environment
Crystal Reports for Visual Studio ( version 13 )
Postgres version 9.3
Product
Keywords
Removing quotes, Crystal Reports query, Postgres, .NET, Crystal Reports developer for Visual Studio .NET , KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.