Graph pulling LTD data while report is "Next30Days"

Posted on 2008-11-06
Last Modified: 2008-12-15
I have a report that I have Group Selection setup to pull cases for the Next30Days. We have different CaseTypes and we want to show a GroupTotal based on Case Types for the same 30 day period or whatever date parameter we are pulling from. I've added the graph to the report and it is pulling all cases for LTD. I've put the SQL query from Crystal below. Any help would be greatly appreciated.
SELECT "tblCases"."CaseDate", "tblCases"."NumberCases", "tblCustomers"."CustomerName", "tblCustomers"."ShippingCity", "tblCustomers"."ShippingState", "tblCases"."CaseStatus", "tblDoctors"."FirstName", "tblDoctors"."LastName", "tblCaseTypes"."CaseTypeName", "tblCases"."Notes"

 FROM   (("ATR0605_003LIVE"."dbo"."tblCases" "tblCases" INNER JOIN "ATR0605_003LIVE"."dbo"."tblDoctors" "tblDoctors" ON "tblCases"."Doctorid"="tblDoctors"."DoctorID") INNER JOIN "ATR0605_003LIVE"."dbo"."tblCustomers" "tblCustomers" ON "tblCases"."CustomerID"="tblCustomers"."Customerid") INNER JOIN "ATR0605_003LIVE"."dbo"."tblCaseTypes" "tblCaseTypes" ON "tblCases"."CaseTypeID"="tblCaseTypes"."CaseTypeID"

 ORDER BY "tblCaseTypes"."CaseTypeName"

Open in new window

Question by:dsabine
    LVL 100

    Expert Comment

    What is LTD?

    Where is your graph.  


    Author Comment

    Life to Date......but I've just figured it out. Report was pulling all cases and then had a Group on Cases - Next30Days. I setup a date parameter to pull between two dates and now it is reporting correctly.

    LVL 100

    Expert Comment

    Great.  Click the DELETE QUESTION link in the question box and follow the prompts to accept your last comment as the solutiion.

    LVL 1

    Accepted Solution

    PAQed with points refunded (500)

    EE Admin

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now