Crystal Error This Field Cannot Be Summarized
Contents |
SAP Crystal ReportsWhere is this place located?All Places SAP Crystal Reports 3 Replies Latest reply: Apr 1, 2011 3:15 PM by Clifton Bardwell Tweet This Field Cannot Be Summarized Clifton crystal report this field cannot be summarized Bardwell Mar 31, 2011 7:46 PM Currently Being Moderated Using Crystal
Crystal Reports Cannot Summarize Formula Field
Reports XIOk, I have a report with three group levels. I've done the "Detail" level, now I'm working crystal whileprintingrecords on "rolling up" the report so that I can view at a higher level. I'm probably not doing this the "right" way, but here's what I'm attempting. To
Crystal Reports Variables
view at the "Group 3" level, I Hide the Group 3 Header/Footer and add a detail row (Detail b). I also suppress Detail a. I put the values I need to see at this level in the Detail b line. The first problem is that I end up with several duplicate lines. Just checking the "Supress if Duplicated" doesn't really work. What I have found works is placing the following code in the Detail b/Suppress code behind:{?View} <> '1' or ( {MyTable.Group1Field} = Previous ({MyTable.Group1Field}) and {MyTable.Group2Field} = Previous ({MyTable.Group2Field}) and {MyTable.Group3Field} = Previous ({MyTable.Group3Field}) )The problem is that I have to count the displayed rows and show that value in the Group 2 Header. I can't just count the rows because it will count both proper rows and duplicate rows. So, I add the following formula (named ProperRowCount) to the Detail b line (suppressed).If {MyTable.Group1Field} = Previous ({MyTable.Group1Field}) and {MyTable.Group2Field} = Previous ({MyTable.Group2Field}) and {MyTable.Group3Field} = Previous ({MyTable.Group3Field}) Then 0 Else 1Finally, to get the "correct" row count, I sum ProperRowCount by Group3:Sum({@ProperRowCount}, {MyTable.Group3Field}At this point I get an error that the field ({@ProperRowCount} cannot be summarized.Why can't I sum {@ProperRowCount}? Crystal recognizes it as a number. 2132Views Re: This Field Cannot Be Summarized Debi Herbert Mar 31, 2011 8:32 PM (in response to Clifton Bardwell) Current
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up This field cannot be summarized in crystal report errors up vote 0 down https://scn.sap.com/thread/1925382 vote favorite I was be able to output a crystal report and this is about accounting logic. some of the column appear in my crystal report is eg. accountname debit credit cash..........1000...300 I want the column debit minus column credit (1000-300) if the result is positive (+) then 700 will appear in that debit column If the result is negative (-) then the value appear in credit column and i http://stackoverflow.com/questions/17120751/this-field-cannot-be-summarized-in-crystal-report-errors wan to remove the negative sign. So above value 1000 and 300 is not what i wan to show and debit or credit will be 0 eg accountname debit credit cash...........700......0 Above case is ok so far and now i end up like this In crystal report formula editor i have @creditbalance, and inside it has formula: if Sum ({Entries.Debit}, {Entries.AccountName})>Sum ({Entries.Credit}, {Entries.AccountName}) then formula= Sum ({Entries.Debit}, {Entries.AccountName})-Sum ({Entries.Credit}, {Entries.AccountName}) end if So it can give me as i wanted to show (the 700 and 0 part) The problem is i create another formula @TotalDebitBalance Sum ({@DebitBalance}) It error said "This field cannot be summarized", Then how to sum up the value i get from @debitBalance. Note: @TotalDebitBalance i plan to put it at report footer section where all grant total usually placed there, where @debitbalance i put it at Group Header section. crystal-reports crystal-reports-2008 share|improve this question asked Jun 15 '13 at 6:12 zahid mahmood 46112 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote Right click the report. Insert. Summary Fields. 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 Re
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to https://www.experts-exchange.com/questions/23712223/Crystal-Reports-error-This-field-cannot-be-summarized.html Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Crystal Reports error, "This field cannot be summarized" Want to Advertise Here? Solved Crystal Reports error, "This field cannot be summarized" Posted on 2008-09-08 Crystal Reports 1 Verified Solution 31 Comments 4,621 Views Last Modified: 2011-10-19 I am working on an existing crystal report report that is trying to calculate break times for all minor employees and finding all minors that worked more then 6 hours without a 30 minute break. Based on the tables I have and not having the ability to create new ones in the environment, I have one field that grabs the actual 'lunch time'. Called {@shortlunch}, which takes two other fields, with calculations in itself which basically calculate the this field cannot lunch of a minor by taking their in punch, minus their pervious out punch. Their is no actual table field that shows the break time. 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. Which is Group 3 because their are multiple lines for each record. http://i2.photobucket.com/albums/y12/jdbenike/untitled-1.jpg That's a picture of the results. The Lunch Length column is the last filter I need to be filtered. So I created another field called {@count} with the code if {@shortlunch} > 1799 then 0 else 1 Then I created another field called {@count sum} with the code sum({@count sum},{@GROUP3}) This is when I get the cannot summarize error message. The only way I figured to show this data is to show a '1' for when the infraction incurs, and create another column that sums that's column 'cause it will only happen once. Then use select expert to say anytime '1' incurs do not show that record. Could someone please help me Thank You untitled.bmp 0 Question by:jdbenike Facebook Twitter LinkedIn Google LVL 100 Active today Best Solution bymlmcc The only thing you could try would be to save the time