Hi, I want to be able to pass a SQL Query into a crystal report from aan 
asp page, so that it uses that for the report instead of using a stored 
procedure.

This means that it will need to produce reports on the fly. The report 
will be designed with the correct fields.

Can I pass this as a normal prompt parameter so that the report reads it 
as a SQL Query?

Thanks
Darren

Sounds like your clients are running local copies of Crystal Reports 
(yuk!). If this is the case, then maybe, just maybe, you could use ADO to 
create persistent (XML perhaps) recordsets at the server, then shuck them 
over to the clients, where they could recreate the recordsets to feed 
Crystal Reports. Then its simply a matter of setting the sources 
accordingly in Crystal Reports.

You might want to consider a Crystal Reports Enterprise installation. They 
have a server component that would make this task much easier - that is, 
if you can survive the installation and get all the permissions squared 
away.

Personally, I'd "86" Crystal Reports for a nice ASP/DHTML rendition...

Skip