Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2007
    Location
    Auckland New Zealand
    Posts
    120
    Provided Answers: 1

    Unanswered: First Time Using Crystal Reports

    Can I display the Output from this Query in a Crystal report

    Select DATENAME(dw,dDate) as Day, count(iStatID) as Total_Po
    from ListingStats Where IListingID = 5
    Group by DATENAME(dw,dDate)
    Order by DATENAME(dw,dDate)

    Do I Have to use a Dataset to populate the report?

    Wheres a Good tutorial For Using Crystal Reports?

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    On the database expert where you connect to the database you are using there is an optin to Add Command you can create a view from a sql statement here.

    So from your statement you could then select the fields Day and Total_Po and place them directly onto your report.

  3. #3
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    On the database expert where you connect to the database you are using there is an option to "Add Command" you can create a view from a sql statement here.

    So from your statement you could then select the fields "Day" and "Total_Po" and place them directly onto your report.

  4. #4
    Join Date
    Aug 2007
    Location
    Auckland New Zealand
    Posts
    120
    Provided Answers: 1
    Sorry Forgot I posted this, Ive figured out how to use them haven't tried the View method Ill give it a shot when Ive got some time, think I might use Flash and an Interactive Graph instead,

Posting Permissions

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