Need help modifying SQL Query

[jpicks]

I am building a report in 8.5 that pulls data from several different views. The problem that I am having is that only the data from the first view that I add to the report is showing up.

When I selected Database -- Show SQL Query, only the first view shows up. I tried to manually enter the other views into the SQL statement, but they were immediately erased when I clicked OK.

My question is:

Is there any way to create a report using an SQL Query that you created elsewhere?

Any help would be greatly appreciated!!!

 

[Maximizer]

Greetings! For version R 8.5, why not just copy and paste to the Crystal SQL designer and then use the CR to 'hit' the saved file under the data explorer as the Crystal SQL designer file...

Thanks

JamesK
Crystal Reports 8.5 Certified Consultant (CRCC)
Authorized Crystal Engineer (ACE)

 

[synapsevampire]

If these Views are not linked, build subreports containing each Views data.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com