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

Crystal Reports Error This Field Cannot Be Summarized

Can a wide body airliner land safely with a full fuel tank? Let's take an example: Order Table Order #, Total, Paid Order Items Table Order #, Line #, Description When you join the two tables you can no longer sum the total/paid Working hours for Casual employees are calculated based on different tablesso I have asub-report to calculate and pass back result to main report using a Shared NumberVar @EFTcasual. Browse other questions tagged crystal-reports or ask your own question. Check This Out

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}) That seems more like a running total that keeps adding a number down the line when I need it for each employee via eventdate(lines are seperating each event date on the With an and statement in that suprress formula area? Skip to Content Open navigation Account Settings Notifications Followed Activities Logout Search Your browser does not support JavaScript. http://scn.sap.com/thread/1888084

All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. You'll receive secure faxes in your email, fr… eFax How to use PRTG for Bandwidth Monitoring using NetFlow or Packet Snifffing Video by: Kimberley In this tutorial you'll learn about bandwidth I have seen several postings on this subject. features than to do it manually in the formulas.

Huffman compressor in Java How to correctly write "7 apples" according to the international system of units (SI) Random integers with differing probabilities how does 2*4*6....(2n) turn into 2^n* n! A 17th century colloquial term for children, in the way we use 'kids' today Can a wide body airliner land safely with a full fuel tank? 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 Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free.

Promoted by Recorded Future Are you wondering if you actually need threat intelligence? 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 You can then create a running total to sum the total/paid columns but will only evaluate on the change of your Order # group. great post to read asked 3 years ago viewed 5584 times active 3 years ago Upcoming Events 2016 Community Moderator Election ends in 3 days Get the weekly newsletter!

Animate finding the middle Why does the '!!' shortcut fail to execute the previously run command? 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 I am getting an error that says "field cannot summarized". Are you aComputer / IT professional?Join Tek-Tips Forums!

I have attached the rpt file. http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4729 If the co-signer on my car loan dies, can the family take the car from me like they're threatening to? Everytime 1 occurred I could just use select expert to filter out these results. i can't use the "insert summary" command coz the option is missing.

Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 23 http://digitalezines.com/crystal-reports/crystal-reports-error-91.html Related 1Crystal Reports Division Formula Not Calculating as Desired0Create summary in report footer by omitting suppressed records0Shared Sub-report variable displays last record's value0Return different datatypes crystal formula6Require multiple pages for a Join & Ask a Question Need Help in Real-Time? 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.

I'm probably not doing this the "right" way, but here's what I'm attempting. Too quick with the paste. Also if I create a formula @subTotal =Sum(@lineTotal) I get error "This field cannot be summarized". this contact form Plus I think I see where your going with this, but I think the results would still not be filtered the correct way.

LuaLaTeX: [draft] option clash for package graphicx when loaded after fontspec Did people in China resort to cannibalism during the reign of Mao? 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 There has got to be a way to do this, its so frustrating...

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

mlmcc 0 Message Author Comment by:jdbenike2008-09-15 Comment Utility Permalink(# a22479438) There has been a lot of details talked about. Shared variables are evaluated later in the generation (printing pass) and thus cannot be used in summaries. I'm not sure that that's doable in my report. Is there any other way without a subreport to do this process?

Does that make sense? i'd like to get the average of all the subtotals i've just summed up. 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. navigate here Connect with top rated Experts 16 Experts available now in Live!

You can suppress the new section. Forgot your password? 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 Called {@shortlunch}, which takes two other fields, with calculations in itself which basically calculate the lunch of a minor by taking their in punch, minus their pervious out punch.

Register now while it's still free! How do I get the last lines of dust into the dustpan? how can i do this? Am I just creating the subreport with the shortlunch field calculation in it?

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. This is the last thing you posted ''''''''''''''''''' Basically the subreport needs to look a lot like your current report but only do the ---------{@count lunch test}----------- if {@shortlunch} > 1799 Results-with-the-my-forumla.bmp 0 LVL 100 Overall: Level 100 Crystal Reports 94 Message Active today Expert Comment by:mlmcc2008-09-09 Comment Utility Permalink(# a22430072) Try this Right click the detail section in the left The first problem is that I end up with several duplicate lines.

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'. What is the difference between a point transformation and a vector transformation? 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 Their are no other ways to do this report.

but i also would like to get the grand total using this formula: subtotal of %sold divided by the no. In it, you'll get: The week's top questions and answers Important community announcements Questions that need answers see an example newsletter By subscribing, you agree to the privacy policy and terms Please make sure you are passing variable of array type. 0 Message Author Comment by:garyjgs2009-04-09 Comment Utility Permalink(# a24108828) This is the variable passed to the Main Report: //@SubFormula //Count So now I hafta filter the results by the ACTUAL time the employees worked which is caclulated with the {@shortlunch} field above and the previous function because that is the only

CONTINUE READING Join & Write a Comment Already a member? 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 help.