Crystal Reports--How to use my SQL

[teddie]

I'm using VB5 and Oracle8. I have a query which pulls all of the information for my report. I've made reports in Crystal Reports before pulling in a query saved in Access. Could you step me though creating a report using SQL in Crystal Reports?

[Serge]

Its not hard. First you would need to create a DSN (Data Source Name) for your database. I assume that you know how to do that.

Then when you start Crystal Reports....select Custom, then select ODBC/SQL. It will ask you to select one of the available DSNs, you would select the one you've just created. Then it will show you all available field from your Stored Procedure or Query. The rest is just the same as if it would be for Access.

Regards,

------------------

Serge

Software Developer
Serge_Dymkov@vertexinc.com
Access8484@aol.com