Results 1 to 3 of 3

Thread: command query?

  1. #1
    Join Date
    Oct 2010
    Posts
    51

    Unanswered: command query?

    I created a report using the Wizard and like the way it looks, but I cannot figure out how to set the command query. Currently it is directly linked to a table. Depending on parameters though, I will need to query different sql and get the same report.

  2. #2
    Join Date
    Oct 2010
    Posts
    51
    Okay, I figured out the command query with parameters. Just had to learn the syntax for the parameters.

  3. #3
    Join Date
    Oct 2010
    Posts
    51
    Sorry for those of you that may be learning Crystal Reports like me, I realize my previous post wasn't a very descriptive solution.

    In the Database Expert window, I drilled down into the Create New Connection. Then I selected the database type I wanted to use and rather than picking a table. You pick Add Command and then insert your sql statement with your parameter in the format {?varName}.

    Hope that helped someone.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •