Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Field Cannot be Summarized Post Reply Post New Topic
Author Message
Freddie
Newbie
Newbie


Joined: 20 Dec 2011
Online Status: Offline
Posts: 4
Quote Freddie Replybullet Topic: Field Cannot be Summarized
     Posted: 20 Dec 2011 at 10:05am
Let me preface this with the fact I am a "Newbie Crystal Writer" and using Crystal 11... 
 
formula 1 titled daysdiff  
{date.due} - previous{date.due}  - this works fine and I get a number.
(ex. 34)
 
Formula 2  titled <30days
If {daysdiff} < 30 then 1 else 0 
 
this works fine as well..
 
Problem is when i try to do a running total on count of unique ppl with 
<30days.  I cannot see the "field" from Running Totals and am told "Field Cannot be Summarized" when i try other stuff.  
 
Please help!  this is making me crazy and all I want to get is a count of ppl that have <30days difference in dates!    Anything will be helpful here!   
Crystal 11
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 20 Dec 2011 at 11:37am
you cannot summarize a field that uses previous()
instead make the running total use htat as an evaluation formula
Naem= whatever
field to summarize= a primary key
type= count (or distinct count if you have duplictes you need to handle)
evaluate= use a formula
{date.due} - previous{date.due} < 30
reset=never (if you have no group summary you need to show)
place in footer (and detail section if you want to see the row level increments)
IP IP Logged
Freddie
Newbie
Newbie


Joined: 20 Dec 2011
Online Status: Offline
Posts: 4
Quote Freddie Replybullet Posted: 22 Dec 2011 at 3:57am

Unfortunately that did not work...

any other suggestions?

Crystal 11
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 22 Dec 2011 at 4:00am
can you expalin what did not work as the process should give you what you need.
IP IP Logged
Freddie
Newbie
Newbie


Joined: 20 Dec 2011
Online Status: Offline
Posts: 4
Quote Freddie Replybullet Posted: 22 Dec 2011 at 4:04am
Its giving me a count of all the dates listed one item may have 6 "date.due" and it is just counting each of those ... this is how i wrote the formula... 
 
{date.due} - previous({date.due}) < 30
 
its not looking at <30 i think .. some date.due may be over 30 and its just doing a count on all date.due


Edited by Freddie - 22 Dec 2011 at 4:05am
Crystal 11
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 22 Dec 2011 at 4:34am
Can you post some sample rows of the data and how you want to count to appear?
IP IP Logged
Freddie
Newbie
Newbie


Joined: 20 Dec 2011
Online Status: Offline
Posts: 4
Quote Freddie Replybullet Posted: 22 Dec 2011 at 4:50am

I finally got it to work!  Its a variation of what you gave me!  thank you!

I created a field called {date.due  - 30} and the formula for that was {date.due} - 30

that gave me a new date of the original date - 30 days.

So, I then created a running total and on that formula stated to count if the {date.due-30} < previous({date.due})

I did the count and it is working!  Thanks for helping me think "outside the box" .
 
Crystal 11
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 22 Dec 2011 at 4:53am
glad you got it Thumbs%20Up
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.