frankj_nz wrote:

>Did anyone work with any reporting products with FIreBird, for example
>Crystal Report, Active Report?
>
>I am wondering if I can use a stored procedure or view as the
>datasource to design a report.
>
>I know the worst case is I have to retrieve data by code and assign to
>each report fields at runtime.
>
>Thanks
>
>frank
>
>

Frank,

I use Crystal Reports 7.5 or 7.0 (can't remember and I am a bit lazy to
go to about box right now :-) ) with IBPhoenix ODBC driver. I have a
quick look on Crystal XI and it works ok too, no exaustive testing so far.

Works very well, I have reports bases on view, on joinned tables, or
joinned tables and views, and Selectable stored procs, you cannot mix in
CR SP's and tables or views, CR doesn't allow this (at least the version
I have in hands).

Besides the problems/limitations on CR the both works quite well.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br