How do I create a Crystal Report based on SQL I created in another app

[JamonTerrell]

I've created some decently complex SQL in another application (MS Query Analyzer) and I'd like to use it as a base for my Crystal Report. The only catch is, I can't use a .qry file created with Seagate SQL Designer because the report won't be able to find the external file when imported into an application. (The application I need it to be imported in is a closed-source externally developed application).

Please let me know any ideas that might assist.

Thanks in Advance,
Jamon

 

[JamonTerrell]

I forgot to mention, It's crystal Reports 8.5, so I can't just put it in as a SQL command like you can in 9.

Thanks,
Jamon

 

[vidru]

You could turn your query into a stored procedure, then use that as your data source. Or will that not work for your application?

-dave

 

[JamonTerrell]

I was leaning toward creating a view as my solution, but I wanted to get confirmation that this was the most correct way of doing it. Thanks.