Home > Crystal Reports > Crystal Reports Error This Field Cannot Be Summarized

Crystal Reports Error This Field Cannot Be Summarized

This quick video will show you how to change your primary email address. Now if I could sum that field based on that, and use select expert. Something like this In the main report add a formula to the report header WhilePrintingRecords; Shared NumberVar ShorLunchCount; '' Group by employee then date In the date group header add the Hot Network Questions move to directory that was no directory How to make my logo color look the same in Web & Print? have a peek here

Let me know if you need it in the header, because there's a more complex way of setting this up that might work for that. -Dell Hi, This works fine when So, I add the following formula (named ProperRowCount) to the Detail b line (suppressed).Copy CodeIf {MyTable.Group1Field} = Previous ({MyTable.Group1Field}) and {MyTable.Group2Field} = Previous ({MyTable.Group2Field}) and {MyTable.Group3Field} = Previous ({MyTable.Group3Field}) Then 0 and Summary... but there's one thing more i'd like to do. http://scn.sap.com/thread/1888084

First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Cheers, Foxy_________________Foxy Back to top KMBPrincipal MemberJoined: 11 Feb 2004Posts: 310Location: Birmingham, UK Posted: Thu Oct 11, 2012 4:05 amPost subject: Re: crystal reports xi field cannot summarized The only way Is there anyway that I can do this? Not the cleanest way, but if Crystal won't let you summarize...

  • Also if I create a formula @subTotal =Sum(@lineTotal) I get error "This field cannot be summarized".
  • So the {@shortlunch} field does not show select expert and I need to not have any records less then 1800 seconds show grouped by eventdate for each employee.
  • Join them; it only takes a minute: Sign up This field cannot be summarized in crystal report errors up vote 0 down vote favorite I was be able to output a
  • mlmcc 0 Message Author Comment by:jdbenike2008-09-09 Comment Utility Permalink(# a22429922) when I create a new field to the details section called ---------{@count lunch test}----------- if {@shortlunch} > 1799 then 1
  • So if i wanted to reset the value for each new eventdate per person, how would I do that?
  • You may have to register before you can post: click the register link above to proceed.
  • James 0 Featured Post Maximize Your Threat Intelligence Reporting Promoted by Recorded Future Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program.
  • mlmcc 0 LVL 34 Overall: Level 34 Crystal Reports 33 Message Active today Expert Comment by:James06282009-04-10 Comment Utility Permalink(# a24120408) That's the thing.

Also, does the subreport basically look exactly the same besides this count lunch field? 0 Message Author Comment by:jdbenike2008-09-15 Comment Utility Permalink(# a22479465) Then you go on saying use this On 1941 Dec 7, could Japan have destroyed the Panama Canal instead of Pearl Harbor in a surprise attack? A total of the Distinct Count of employees is need by Location. 0 Comment Question by:garyjgs Facebook Twitter LinkedIn Email https://www.experts-exchange.com/questions/24310003/Crystal-Reports-Field-Cannot-Be-Summarized-Error.htmlcopy LVL 100 Active today Best Solution bymlmcc Summary functions are Any ideas on how to solve this problem?

You can then create a running total to sum the total/paid columns but will only evaluate on the change of your Order # group. and, you mentioned on how to reset the value to zero with some code in the header or footer. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. In addition to Waqar's solution, I'd replace the formula with something easier. {@DebitBalance} IF {Entries.Debit} > {Entries.Credit} THEN {Entries.Debit} - {Entries.Credit} ELSE 0 {@CreditBalance} IF {Entries.Debit} < {Entries.Credit} THEN ABS({Entries.Debit} -

Join them; it only takes a minute: Sign up This field cannot be summarized crystal report error up vote 0 down vote favorite I've got the problem about crystal report. So I need a way to get select expert to work with the calculated lunch length with the previous function, or create a seperate field which counts every time the error Anne Berndt February 08, 2011 at 21:48 PM 0 Likes Correct Answer Jason Long replied February 11, 2011 at 16:19 PM At this time, this appears to be the solution...Copy Code Their is no actual table field that shows the break time.

This will use the same logic as the Group2 formulas but will not reference any of them. http://www.forumtopics.com/busobj/viewtopic.php?p=915591&sid=4e6169cb0046841d50e7c5ae7b1b0ca6 I always do it in a later section to ensure it works since it is too easy to get the order wrong if it is in the same section. I am getting an error that says "field cannot summarized". For example, if the subreport is in a Location group footer section, create another Location group footer section below that and put the formula there.

Close Box Join Tek-Tips Today! navigate here Join Us! *Tek-Tips's functionality depends on members receiving e-mail. or one in the footer. However, the formula in Group2 is based on sums in Group2._________________Foxy Back to top hilfyForum EnthusiastJoined: 16 Apr 2007*3Posts: 1546Location: Atlanta, GA Posted: Fri Oct 12, 2012 8:35 amPost subject: Re:

Something like: SUMPERCENT = Sum(qty_sold)/Sum(stocks) Reply With Quote 01-25-07,02:27 #3 LimaCharlie View Profile View Forum Posts Registered User Join Date Oct 2005 Posts 119 hi trowe, i already got the sum What happened to FN-1824? Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Business Objects: Crystal Check This Out Too quick with the paste.

The Previous function can only run when the report is printed thus you can't do a summary on a function that uses previous. Then, in the main report I did this.. ---------{@count lunch test}----------- if {@shortlunch} > 1799 then 1 else 0 Then sum them usiing a running total. mlmcc 0 Message Author Comment by:jdbenike2008-09-15 Comment Utility Permalink(# a22479438) There has been a lot of details talked about.

So when it should be zeroed simply add the first formula.

So on the first attached picture above I would need Jordan Ferry, Jason Rodavich, Andrew Scrima, Dylan Jacobs, and David Brooks not to show up at all. I'm using two tables, one table identifies the ticket as belonging to a group, and another table keeps tracked of the duration of time each group owned it.Therefore, I created the I think this is due to the fact I have to sum the duration time by each ticket, but I don't know how to work around it. Some components may not be visible.

My expected out is:Agent# of Cases# Out of Compliance%Jim Jones503264%My question is, can I change something in the formula so I can sum it up? Join Now For immediate help use Live now! i can't use the "insert summary" command coz the option is missing. http://haywirerobotics.com/crystal-reports/crystal-reports-cannot-open-control-file-error.html MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses Vendor Services Groups Careers Store Headlines Website Testing Ask a Question

Select the formula you have done on the field and change from max to sum Change Location to Group Footer Do the same again and this time select the Report Footer