Thread: Crystal Reports 8.5 - SQL Expressions

Crystal Reports 8.5 - SQL Expressions

From
"Juan Ignacio Lalla"
Date:
Hello,
 
I'm using Crystal Reports 8.5 against PostgreSQL Database Server 8.1.
The thing is that when I try to use an SQL Expression Field in Crystal, doesn't work (it does work when I don't use it).
 
Returns the following error:
Error in compiling SQL Expression:
Cannot find parser table file(s).
 
The expression is the folowing:
{fn SUBSTRING( TABLE."column", 1, 250 )}
 
(column datatype is "text")
 
This sentence worked against other databases, but not against PostgreSQL...
 
Has anybody pass through this situation?

 

Thanks for your assistance,

Juan

Attachment

Re: Crystal Reports 8.5 - SQL Expressions

From
mike
Date:
Last I tried, a few years ago, Crystal 8.5 would not work at all with
PostgreSQL.  Version 9 works but the later service packs handle it much
better.

Can you browse the table data through the database expert?

Mike

On Wed, 2006-07-12 at 10:23 -0300, Juan Ignacio Lalla wrote:
> Hello,
>
> I'm using Crystal Reports 8.5 against PostgreSQL Database Server 8.1.
> The thing is that when I try to use an SQL Expression Field in
> Crystal, doesn't work (it does work when I don't use it).
>
> Returns the following error:
> Error in compiling SQL Expression:
> Cannot find parser table file(s).
>
> The expression is the folowing:
> {fn SUBSTRING( TABLE."column", 1, 250 )}
>
> (column datatype is "text")
>
> This sentence worked against other databases, but not against
> PostgreSQL...
>
> Has anybody pass through this situation?
>
>
> Thanks for your assistance,
>
> Juan
>
>