Change report from using .QRY file to inside SQL

[Marichele]

I want to change where my report is getting data. Right now it is using a Crystal query file. I want to drop the query and use a view instead. I don't want to have to redesign the report.

Thanks,
Mary

 

[hann944]

I have the same issue. The only way I think I can without entirely re-design the report is create a command (9 and above). Then copy and paste the SQL there and then repoint the fields to the command instead of the query. Still there has to be a better solution.

I also considered Business Views but these cases should not be business views (not what they made for) they should be SQL inside Crystal.

Hannibal

 

[synapsevampire]

You should start a new thread as this one is over a year old.

Crystal queries were never a good idea, and lots of people have been burned by their proprietary nature, and why I am avoiding Business Views.

CR 9 can use Crystal Queries:

http://support.businessobjects.com/library/kbase/articles/c2012662.asp

-k

 

[kskid]

If you have an Oracle database, then you can do the following.

Go into Crystal SQL and copy the sql statements

Logon to Oracle SQL or have your database administrator do it for you.

CREATE VIEW [i]V_TABLE[/i] AS
(
Paste your Crystal Designer SQL statement here
)

V_TABLE is a view name of your choice

Cheers,
-LW