Complete novice needs help getting SQL Query into Crystal Reports XI

[Former Member]

Post Author: MissMarnie

CA Forum: Data Connectivity and SQL

So I was given an intro level web course and a monster reference guide in prep to format a report. One of our developers wrote me everything I need for the report into a SQL Query and now I'm supposed to format it in CR XII literally do not know what to do from here. I'm able to set up the correct server as a datasource, if that's useful, but I don't know how to make the querey into a bunch of formattable fields in CR. If anyone can walk me through this, I'd be so grateful. I've attempted to look up SQL query in both the help and the book but I keep hitting a wall. The help dialog says things like "press this button" with no reference to what "this button" is. I'm sure it's obvious to the knowledgeable but I'm in a complete fog. Thanks in advance

[Former Member]

Post Author: MissMarnie

CA Forum: Data Connectivity and SQL

Kai,Thanks so much for replying so quickly!Ok, so I'm using CR XIDatabase is Sybase I'm just now trying what you suggested and I believe that does the trick...brilliant! Thanks and thanks again.

[Former Member]

Post Author: synapsevampire

CA Forum: Data Connectivity and SQL

IF you're trying to get assistance with setting up a query as the source for a report, try posting your Crystal version and the database type.

Different software works differently.

In CR 9 and above, under the connection to the database you'll see Add Command. Select that and you can paste the query in.

As for not knowing how to generate a report, that requires experience, there's no generic solution of course..

-k