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

Crystal Reports Error This Field Cannot Be Summarized

how will i do this? 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 if we had another column that summed each record by event date. 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 http://ogdomains.com/crystal-reports/crystal-reports-515.php

share|improve this answer answered Jun 15 '13 at 9:40 Waqar 1447 add a comment| up vote 0 down vote It doesn't say but I'm assuming the report is grouped by {Entries.AccountName}. Are you aComputer / IT professional?Join Tek-Tips Forums! Is there any other way without a subreport to do this process? When trying to calculate the weekly total, I get an error message that says 'this field cannot be summarized'. http://scn.sap.com/thread/1888084

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 NetScaler Citrix How to Bulk Add Group Price to Magento Products Video by: MagicienPro This tutorial demonstrates a quick way of adding group price to multiple Magento products. Now if I could sum that field based on that, and use select expert. I put the values I need to see at this level in the Detail b line.

The time now is 18:17. Join & Ask a Question Need Help in Real-Time? Just checking the "Supress if Duplicated" doesn't really work. Covered by US Patent.

mlmcc 0 LVL 34 Overall: Level 34 Crystal Reports 33 Message Active 1 day ago Expert Comment by:James06282009-04-10 Comment Utility Permalink(# a24120408) That's the thing. If the co-signer on my car loan dies, can the family take the car from me like they're threatening to? Is the following sentence correct? 'The time when the church dates back to is the 13th.' * Are electric bike speed limitations set in stone? http://stackoverflow.com/questions/17120751/this-field-cannot-be-summarized-in-crystal-report-errors I would need samantha kennedy, michael pheebles, and dylan jacobs when his break is equal to 28 minutes to show up only.

Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. 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! Join UsClose Register Help Remember Me? How do I get the last lines of dust into the dustpan?

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. http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4729 One of them counts the number of brown cows/ black cows / black and white cows and others, the other counts the number of grown up cows and calves. 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 How to code tridiagonal matrix with periodic elements How to politely decline my salary due to feeling I don't currently deserve it?

Why do Internet forums tend to prohibit responding to inactive threads? click site I have attached the rpt file. 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. Can a supine verb have arguments?

share|improve this answer answered Jun 16 '13 at 17:05 ca_wan 29115 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign 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 It would look something like this: Code: NumberVar g1_pa; //Initialize the variable to 0 at the start of every group if PreviousIsNull({tblSCHOOL.SCH_NAME}) or {tblSCHOOL.SCH_NAME} <> Previous({tblSCHOOL.SCH_NAME}) then g1_pa := 0; //Add news help.

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 Forgot your password? I know you woudln't have my database and or tables, but you could still throw some coding into it. 0 Message Author Comment by:jdbenike2008-09-10 Comment Utility Permalink(# a22441767) I guess

Which is probably a minor thing.

Join and Comment By clicking you are agreeing to Experts Exchange's Terms of Use. 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 Everytime that 1 occurs as you see I need that record for that employee for that date pulled from the results. The best way I can think of to do that would be to have a separate set of calculations that do the numbers at the Group1 level. -Dell_________________DecisionFirst Technologies - a

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 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? Browse other questions tagged crystal-reports crystal-reports-2008 or ask your own question. http://ogdomains.com/crystal-reports/crystal-reports-8-5-error-599.php 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

All rights reserved. Yet, I cannot use summarize or select expert because it won't allow it.