Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Date Grouping Post Reply Post New Topic
Author Message
dan231
Newbie
Newbie


Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
Quote dan231 Replybullet Topic: Date Grouping
    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?

Edited by dan231 - 01 Nov 2018 at 7:09am
Thanks,
Dan
IP IP Logged
dan231
Newbie
Newbie


Joined: 03 Oct 2014
Online Status: Offline
Posts: 13
Quote dan231 Replybullet 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?

Edited by dan231 - 01 Nov 2018 at 7:10am
Thanks,
Dan
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.