Queries

[korata]

I am using CR 8.5 against Oracle 9i:
First of all, is there any benefit to use Crystal Enterprise over ASP.Second,
I have three queries that i have written for an asp pages. and i am just wondering if i am able to use this three queries to generate the same report that i generate usig Crystal report:

 

[synapsevampire]

If you have SQL Queries already written (I assume that's what you mean), you can select More Data Sources, ADO and paste SQL in there, though I don't suggest doing so.

I would create Views from the Queries on the database side to allow for simplified maintenance and increase reusability.

BTW, Crystal can only use ONE recordset per report, so you may have to rethink your SQL.

-k