Re: Crystal Reports 8.5 - SQL Expressions

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
>
>