Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JHear6

    Week Numbers for Local Date Range (if that makes sense)

    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?
  2. JHear6

    Week Numbers for Local Date Range (if that makes sense)

    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...
  3. JHear6

    Week Numbers for Local Date Range (if that makes sense)

    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...
  4. JHear6

    Line Chart not showing second line of data - Survey Results Report

    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.
  5. JHear6

    Line Chart not showing second line of data - Survey Results Report

    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"...

Part and Inventory Search

Back
Top