2117215 - Removing quotes from Crystal Reports query for a Postgres Database in a .NET Application

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'})

Crystal Reports for Visual Studio ( version 13 )

Postgres version 9.3

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