edit "Show SQL Query" Crystal XI no universe

[random621]

I've been reading some past postings about people like myself who in Crystal 8.5 would use the Show SQL Query window to edit & modify the SQL query only to find that in newer versions of Crystal starting at 9 through XI this feature is unavailable.

It sounds like you have to have a universe setup, then start a query from that universe so that you can add a command (and paste in your SQL statement).

Other recommendations involve using views or stored procedures on your database instead.

Unfortunately for me, someone who spends only about 10 hours a month working in Crystal, this all seems a bit daunting.

Can someone tell me if me understanding of the problem is correct and if it is, how do I go about setting up a universe?

Can I do the "Add Command" function in Crystal XI without a Universe?

thanks.

rm

 

[Turkbear]

Hi,
Yes..
The add command is simply a way to send your own Sql code to the database.

Once created it can be used like any table/view for reporting ( can be linked to other tables, for instance).
NOTE:
it is only in existance when it is being used, since it is an ad-hoc query, not a view ..






To Paraphrase:"The Help you get is proportional to the Help you give.."