I guess that means that you don't think I can do this in Crystal?
I was hoping to stay with Crystal so I could work in one tool and end up with the chart.
I'm OK with SQL. What was your thought?
Yes, we want to report on the same record twice, when it was created and when it was completed.
We want to chart them on a graph by week number.
There are different issues in the report when I use either the Created date or the Completed date week number, so I was thinking that maybe I would...
In Crystal Reports XI - Is there a way to use this formula;
DatePart("ww", ({CustomerSurvey.SurveyCompleteDate}),crWednesday) or
DatePart("ww", ({CustomerSurvey.CreatedDateTime}),crWednesday)
only use the current date range of the report, which in this case is year to date?
I'm trying to chart...
One data record with two dates, Created Date and Completed Date. and there are two status, Open and Completed. I would like two different chart lines, one for total sent and one for total completed.
Hope that helps.
I’m trying to create a line chart with two reporting lines for;
1) # of Surveys sent out per week
2) # of Surveys Completed per week
Note Week Starting on Wednesday and ending on Tuesday.
I have two groupings in the report; (that are working correctly)
1) DatePart("ww"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.