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

Crystal Reports Error This Field Cannot Be Summarized

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 Covered by US Patent. Yet, now I need to filter out the shifts that are less then 6 hours. Results 1 to 3 of 3 Thread: This field cannot be summarized Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch his comment is here

Their is no actual table field that shows the break time. For your needs, it looks like you can create a calculated field using the sums that you already have in your category footer. in this power series? All Rights Reserved. weblink

Forgot your password? That suppress field with that code in just takes out the invidual lines where a 30 minute shift shows, but still leaves the other part of the shift on a seperate Please help if you can. However the '@PA-pupil' is based on a series of other formula & sums.

When running the report it doesen't finish and just sits. Thank you in advance for your help!!! Join our community for more solutions or to ask questions. under each category, i have 3 columns to get the no.

Why are the memory addresses of string literals so different from others', on Linux? I am getting an error that says "field cannot summarized". Below is the formula for the field that I am trying to summarize:If {@ActHrsWorked} < 5.00 then {@ActHrsWorked} elseIf {EMPLOYEE.SHIFT_ID} ='NO PARAMETERS' then {@ActHrsWorked} elseIf {EMPLOYEE.SHIFT_ID} = 'OFFICE' then {@ActHrsWorked} else{@ActHrsWorked} Some components may not be visible.

Here is the code for the fields that would involve this problem, or might involve this problem to better clarifty how this report works. SolutionsBrowse by Line of BusinessAsset ManagementOverviewEnvironment, Health, and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and, you mentioned on how to reset the value to zero with some code in the header or footer. The time now is 18:17.

To sum it you will need to have formulas in the main report to do the summing In the report header WhilePrintingRecords; Global NumberVar TeacherCount := 0; In a section after http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4729 i used this formula for the subtotals and grand total as well. Or how? So if we had another column that summed each record by event date.

Join the community of 500,000 technology professionals and ask your questions. http://comscity.net/crystal-reports/crystal-reports-error-91.html For a current record for a person like in the pages above there might be anywhere from 1 - 5 lines for punches for a certain day. 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. To sum it you Go to Solution 2 2 +1 4 Participants mlmcc(2 comments) LVL 100 Crystal Reports94 James0628(2 comments) LVL 34 Crystal Reports33 namanpatel LVL 6 Crystal Reports4 garyjgs 6

Reply With Quote 01-24-07,16:16 #2 trowe View Profile View Forum Posts Registered User Join Date Dec 2004 Location Connecticut Posts 85 I posted a reply to a simalar question here: http://www.dbforums.com/showthread.php?t=1606506 Does that make sense? LuaLaTeX: [draft] option clash for package graphicx when loaded after fontspec Did people in China resort to cannibalism during the reign of Mao? weblink You can see the '@PA-pupil' formula field on the very right hand side in GH2 that I am trying to sum in GH1.

We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly… Crystal Reports How to Receive an eFax Video by: j2 Global Internet Business Fax more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science The variable in the subreport does a Distinct Count of employees.

I do appreciate all the help and time you guys are giving to me.

Local NUMBERVAR PAT_DEP_AMT := 0; IF NextIsNull({MYOBJ.PAT_DEPOSIT}) = TRUE THEN ( IF {MYOBJ.PAT_DEPOSIT} = PREVIOUS({MYOBJ.PAT_DEPOSIT}) THEN ( PAT_DEP_AMT := 0; ) ELSE ( PAT_DEP_AMT := {MYOBJ.PAT_DEPOSIT}; ); ) ELSE ( IF Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud What happens if BB-8 rolls the wrong way? I also suppress Detail a.

Join the community of 500,000 technology professionals and ask your questions. how can i do this? Iam getting some major heat at work for this b/c I have been working on it so long. 0 Message Author Comment by:jdbenike2008-09-09 Comment Utility Permalink(# a22427550) {@count lunch} if http://comscity.net/crystal-reports/crystal-reports-gdi-error.html Get 1:1 Help Now Advertise Here Enjoyed your answer?

Basically the end result is that I need to get rid of all the records(seperated by lines) that show an employees lunch break(lunchlength) is greater then 30 minutes. Everytime that 1 occurs as you see I need that record for that employee for that date pulled from the results. how will i do this? Any other more complicated coding using variables?