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

Crystal Reports Error This Field Cannot Be Summarized

mlmcc 0 Message Author Comment by:jdbenike2008-09-15 Comment Utility Permalink(# a22479438) There has been a lot of details talked about. how can i do this? Something like this In the main report add a formula to the report header WhilePrintingRecords; Shared NumberVar ShorLunchCount; '' Group by employee then date In the date group header add the Any suggestions? 0 Message Author Comment by:jdbenike2008-09-08 Comment Utility Permalink(# a22421002) These are the fields and the layout in the picture attachment. http://swirlvision.com/crystal-reports/crystal-reports-515.html

of products. 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 ect. Too quick with the paste.

Yet, now I need to filter out the shifts that are less then 6 hours. We explain the basics for creating useful threat intelligence. 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 I think this is due to the fact I have to sum the duration time by each ticket, but I don't know how to work around it.

What is the difference between a point transformation and a vector transformation? I am assuming this is because the formula I am trying to sum is based on other sums itself. 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 What happens if BB-8 rolls the wrong way?

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! Their is no actual table field that shows the break time. Privacy Policy Site Map Support Terms of Use Not endorsed by or affiliated with SAP Register| Login Want to sponsor BOB? (Opens a new window) Index|About Sponsors| Contact Us| http://stackoverflow.com/questions/17120751/this-field-cannot-be-summarized-in-crystal-report-errors how does 2*4*6....(2n) turn into 2^n* n!

Are you aComputer / IT professional?Join Tek-Tips Forums! Is their another way to get breaktime between two punches on seperate lines of data besides this code snippet? """{@lunchoutpunch} - Previous({@OUTPUNCH2})""" Like, The example below is for lacey meinhardt, first Can a supine verb have arguments? I am hoping that someone will be able to tell me another way of doing this.

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 http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4729 Is there anyway that I can do this? 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 All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission.

The main report is grouped by employees then by location. his comment is here 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 I also suppress Detail a. That takes me back to my original 'cannot summarize' error because of the {@count lunch test} field [email protected] lunch test field--------- {@shortlunch} > 1799 then 1 else 0 and {@shortlunch} refrences

I can't just count the rows because it will count both proper rows and duplicate rows. Shared variables are evaluated later in the generation (printing pass) and thus cannot be used in summaries. or one in the footer. this contact form Unless we do a column with 0 and 1's and then do a sum of that column based on eventdate, then filter...

Thank you in advance for your help!!! www.decisionfirst.com Back to top foxyPrincipal MemberJoined: 22 Oct 2007Posts: 178Location: North West, UK Posted: Fri Nov 16, 2012 8:06 amPost subject: Re: crystal reports xi field cannot summarized hilfy wrote: I I would need samantha kennedy, michael pheebles, and dylan jacobs when his break is equal to 28 minutes to show up only.

Join the community of 500,000 technology professionals and ask your questions.

in this power series? Covered by US Patent. To view at the "Group 3" level, I Hide the Group 3 Header/Footer and add a detail row (Detail b). 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 wide body airliner land safely with a full fuel tank? Now if I could sum that field based on that, and use select expert. help. navigate here To start viewing messages, select the forum that you want to visit from the selection below.

So if i wanted to reset the value for each new eventdate per person, how would I do that? The start reason has breakrules, but there is code behind those rules so everytime a break 30 minute rule occurs it can happen anytime after 24 minutes. TikZ:Anchor current page north west isn't where expected Did people in China resort to cannibalism during the reign of Mao? Hot Network Questions Infinite Fibonacci sums - diverge or converge How to respond to your boss's email about a coworker's accusation?

Then summarize each section so that it equals to 1 if the problem occurs, then use select expert to filter out these records.