Print Page | Close Window

Date Grouping Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Technical Questions Forum Discription: Formulas, charting data, Crystal syntax, etc. URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22689 Printed Date: 28 Apr 2024 at 10:32am Topic: Date Grouping Posted By: dan231 Subject: Date Grouping Date Posted: 01 Nov 2018 at 6:30am I have a report that lists out all the dates from a month selected and then shows amounts sold on that date. I am trying to get a CSV of just date and amount in order to create a graph. My issue is that when I group by the date field, I get a random set of dates under each group. I have no idea how or why this is happening. Any ideas? ------------- Thanks, Dan Replies: Posted By: dan231 Date Posted: 01 Nov 2018 at 7:08am I fixed this by using ToText(date_field},"MM/dd/yyyy") Now, whats the best way to add a goal field? I have 1 goal for the month, how can I add a column for just this 1 number? ------------- Thanks, Dan

Print Page | Close Window