[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Graph pulling LTD data while report is "Next30Days"

Posted on 2008-11-06
5
Medium Priority
?
270 Views
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

0
Comment
Question by:dsabine
  • 2
4 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 22898009
What is LTD?

Where is your graph.  

mlmcc
0
 

Author Comment

by:dsabine
ID: 22898216
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.

Thanks!
0
 
LVL 101

Expert Comment

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

mlmcc
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 23179577
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

830 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