Reports based on Crystal Query

[magicboy]

I have several reports based on Crystal Queries (.qry files) against an old Informix database.

I now need to port these reports to a SQL/Server database and put a VB front end on them to allow them to be run by end users.

I think that in order to do this I need to convert the reports to use ADO and then use the RDC SetDataSource method from within the VB app to point the report at a query constructed from the user input.

I cannot find a way of changing an existing report based on a query to use ADO other than completely rewriting it.

Does anyone have any ideas or any better way of achieving this?

 

[bjrollet]

Why not recreate the .qry files as views in your SQLServer dbase and base the reports off them? Should be easy enough, and all you should have to do then is set location of the dbase.

 

[magicboy]

Thanks, a view might be a good way to do it but I cannot seem to use set location to point my report at the view as opposed to the query.

If my report was based upon database tables I would get the dialogue allowing me to map each table onto a new location.

As my report is based on a query I can just select the new view but the report seems to do nothing with it.

Any ideas???

 

[VinayS]

According to crystal decisions knowledge base article Id: c2007877: You cannot convert a report's database driver when reporting off a ctystal query. That is, a report originally created off a QRY file cannot be changed to report directly off an Oracle table or view. The report must be recreated