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

Crystal Reports Error This Field Cannot Be Summarized

Look for the previous threads for a solution.DebiEdited by: Debi Herbert on Mar 31, 2011 2:32 PM 0 Likes 0 View this answer in context 3 replies Share & Follow Privacy 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 Get 1:1 Help Now Advertise Here Enjoyed your answer? 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 weblink

Why does the Minus World exist? Forgot your password? Why did Borden do that to his wife in The Prestige? 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_________________DecisionFirst Technologies - a Protiviti Enterprise http://scn.sap.com/thread/1888084

I do appreciate all the help and time you guys are giving to me. Could someone please help me Thank You untitled.bmp 0 Comment Question by:jdbenike Facebook Twitter LinkedIn Email https://www.experts-exchange.com/questions/23712223/Crystal-Reports-error-This-field-cannot-be-summarized.htmlcopy LVL 100 Active today Best Solution bymlmcc The only thing you could try would Join Us! *Tek-Tips's functionality depends on members receiving e-mail. The field names for those two values are VP_TIME.INPUNCHDTM, AND VP_TIME.OUTPUNCHDTM Report-Ran.pdf 0 Message Author Comment by:jdbenike2008-09-10 Comment Utility Permalink(# a22442247) keep in mind those are seperate lines of records

  1. 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.
  2. 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'.
  3. The Previous function can only run when the report is printed thus you can't do a summary on a function that uses previous.
  4. The way to overcome this is to create a group using the key.
  5. Experts Exchange Xpdf - PDFfonts - Command Line Utility to List Fonts Used in a PDF File Video by: Joe In this seventh video of the Xpdf series, we discuss and
  6. Global.asax Application_Start not hit after upgrade to Sitecore 8.2 What crime would be illegal to uncover in medieval Europe?
  7. Join & Ask a Question Need Help in Real-Time?
  8. Nine times out of ten reporting requirements… Crystal Reports Crystal Reports 8 - Error 533 PESStartPrintJob Article by: slfede Hello everyone, Hope you find this as helpful as we did.

Because even if we get the short lunch values to only show less then 30 minutes it will just keep hitting values less then 30 till it finds one, then suppress Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. mlmcc Go to Solution 23 8 2 Participants jdbenike(23 comments) mlmcc(8 comments) LVL 100 Crystal Reports94 31 Comments Message Author Comment by:jdbenike2008-09-08 Comment Utility Permalink(# a22418026) The count sum field Which, is basically the report iam using now so it had all the same fields.

I agree it should be in a later section though if done in the correct order it will work in the same section. Their is no actual table field that shows the break time. Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc. http://stackoverflow.com/questions/17120751/this-field-cannot-be-summarized-in-crystal-report-errors to get the %sold, my formula is qty.sold/stocks.

ect. The negative effect on performance and maintainability is just not worth the easy ride they give the report writer. I also have aformula to [email protected] [email protected] + @EFTcasual My problem is that then I cannot get agroup subtotals and a grand total of my @lineTotal. Hot Network Questions move to directory that was no directory How to make my logo color look the same in Web & Print?

Join & Ask a Question Need Help in Real-Time? http://www.forumtopics.com/busobj/viewtopic.php?p=915591&sid=4e6169cb0046841d50e7c5ae7b1b0ca6 Browse other questions tagged crystal-reports crystal-reports-2008 or ask your own question. Is there any other way without a subreport to do this process? Yet, now I need to filter out the shifts that are less then 6 hours.

How can I ask about the "winner" of an ongoing match? http://homeshareware.com/crystal-reports/crystal-reports-error-cannot-find-dsn-in-connection-string.html Antonym for Nourish Is privacy compromised when sharing SHA-1 hashed URLs? When does “haben” push “nicht” to the end of the sentence? Reply With Quote Quick Navigation Crystal Reports Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft

Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! On 1941 Dec 7, could Japan have destroyed the Panama Canal instead of Pearl Harbor in a surprise attack? 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 check over here Everytime 1 occurred I could just use select expert to filter out these results.

When ever I try to sum up this formula, I get an error message "This field cannot be summarized". Join the community of 500,000 technology professionals and ask your questions. Does that make sense?

www.decisionfirst.com Back to top foxyPrincipal MemberJoined: 22 Oct 2007Posts: 178Location: North West, UK Posted: Tue Oct 16, 2012 5:51 amPost subject: Re: crystal reports xi field cannot summarized I really cant

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? It should read: TeacherCount := TeacherCount + TeachersCoreClassCt; Also, just to clarify, that formula needs to be in a separate section from the subreport, to make sure that it is evaluated Join Now For immediate help use Live now! 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.

First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Anyways This causes the report to never finish and just hangs up when I run it. 0 Featured Post Looking for New Ways to Advertise? Any other more complicated coding using variables? this content Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free!

I have a formula in Group2 level that I need to sum in Group1. Summary Fields. Yet, I don't think that's possible. 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

Life would be great. Join Now For immediate help use Live now! Not the cleanest way, but if Crystal won't let you summarize... mlmcc 0 Message Author Comment by:jdbenike2008-09-15 Comment Utility Permalink(# a22479438) There has been a lot of details talked about.

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} - Thank you IP Logged RitaInHood Newbie Joined: 07 Jul 2008 Online Status: Offline Posts: 25 Posted: 05 Nov 2008 at 10:22am This might be similar to a problem I had So how do I do that? products" or "average(%sold subtotal), but an error "this field cannot be summarized" appears.

Even if I will end up paying for it, I think it will be far more worth the value if we get this to work. Shared variables are evaluated later in the generation (printing pass) and thus cannot be used in summaries. Here is the code for the fields that would involve this problem, or might involve this problem to better clarifty how this report works.

Back to Top