Skip to Content
author's profile photo Former Member
Former Member

Complete novice needs help getting SQL Query into Crystal Reports XI

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2007 at 11:29 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 03, 2007 at 11:43 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.