Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Better way to find dated items by month and graph? Post Reply Post New Topic
Author Message
ultraca
Newbie
Newbie
Avatar

Joined: 31 Mar 2011
Location: United States
Online Status: Offline
Posts: 23
Quote ultraca Replybullet Topic: Better way to find dated items by month and graph?
    Posted: 04 May 2011 at 3:56am
I have a report I created that shows sum of tickets per month, per user that were closed within a 12 month period.

Example:


When building this report I used the following function to identify tickets closed within a certain month.  I had to create 12 separate functions (for each month) to achieve the results I needed. But I am curious if there is a better way to do this?

if DateDiff ("m", {@Close Date conv}, CurrentDateTime) in 12 to 13 then 1 else 0
This function is then summarized (Sum) to show count of tickets closed 12 months ago.  The @Close Date conv is a function that converts my epoch DateTime.

While I do have the results I need I am now facing a new challenge with graphing the results.  I'd like to be able to see (in graph) the sum of all tickets closed per month but I am limited when I try to insert a chart using either Grouping or Advanced.  The only group I have is User and Advanced doesnt allow me (or at least I dont know how) to plot my total tickets per month against a per month axis.  I've tried so many different combos with data/available fields and getting nowhere.

I have the impression that my initial functions that are producing the results should be rewritten to allow my chart to be created correctly.

Thoughts?

Thanks for your time!


Edited by ultraca - 04 May 2011 at 3:56am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 04 May 2011 at 4:02am
assuming your data select process limits the data to only records closed in the last 12 months...
 insert a graph
use advanced
on change of closedate field, set the group to 'per month' (order option)
show value as distinctcount of your ticketnumber


Edited by DBlank - 04 May 2011 at 4:03am
IP IP Logged
ultraca
Newbie
Newbie
Avatar

Joined: 31 Mar 2011
Location: United States
Online Status: Offline
Posts: 23
Quote ultraca Replybullet Posted: 04 May 2011 at 6:25am
Almost there DBlank.



My sum's, in graph, arent doing what I expect though.  Interestingly, by adding consecutive values from my chart gives me the correct number from my Total Closed above:
533+493 = 1026 = 04/2010
493+586 = 1079 = 05/2010
586+771 = 1357 = 06/2010
...
...
354 + 42 = 396 = 04/2011

Not sure where I went wrong here but my Total Closed values are a sum of each months totals, which is what I based my chart on.


IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 04 May 2011 at 6:49am
the images are blocked in my current location.
what is your row level data for a group and how do you want it counted regardless of graph design at this point.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 04 May 2011 at 6:49am
also are there duplicate data that needs to be accounted for?
IP IP Logged
ultraca
Newbie
Newbie
Avatar

Joined: 31 Mar 2011
Location: United States
Online Status: Offline
Posts: 23
Quote ultraca Replybullet Posted: 04 May 2011 at 8:32am
If I understand your question correctly. My row level data is the # of tickets closed.  This is per user(Y axis), per month (X axis) so:

                       April 2010     May 2010     .....     .....
John Smith            15              4
Mark Smith            87              82
...
...
Total                      102            86

I want my graph to show the totals (value) per month (X axis)
--------------------------------------

About duplicate data, my initial report, my details are duplicated, because the username is repeated multiple time for each ticket matching the monthly criteria.  I had to select Hide on details and I am working with groups only.

Hope that helps clarify.  Sorry you cant see the images.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 04 May 2011 at 9:07am
hiding items do not exclude them from summaries. They still exist int he data that is being read so they have to be accounted for.
from an unhidden detail section view can you show me some sample (with duplicate data included) of a users records and then how you want it summarized.
IP IP Logged
ultraca
Newbie
Newbie
Avatar

Joined: 31 Mar 2011
Location: United States
Online Status: Offline
Posts: 23
Quote ultraca Replybullet Posted: 04 May 2011 at 9:32am
Correct, that wasnt my intention, it was just to get rid of the duplicate view.  My group gives me the correct summaries that I need.

What youre asking for is in the images I included, will you have a chance to see them soon from another location?

I would upload my actual report, but because you cant see the images, the link will be blocked too.
IP IP Logged
LoboX
Newbie
Newbie
Avatar

Joined: 22 Jun 2012
Location: Dominican Republic
Online Status: Offline
Posts: 4
Quote LoboX Replybullet Posted: 23 Jun 2012 at 5:28pm
i need help with that, but mine is regarding inventory any help
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.