Home > Crystal Report > Crystal Report Field Cannot Be Summarized

Crystal Report Field Cannot Be Summarized

Here’s how to do it right. You may have to register before you can post: click the register link above to proceed. 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. 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 http://outwardsound.com/crystal-report/crystal-reports-convert-memo-field-to-string.html

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 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 of stocks, qty.sold and the %sold. 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}.

First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. There has got to be a way to do this, its so frustrating... Forgot your password? To start viewing messages, select the forum that you want to visit from the selection below.

Then summarize each section so that it equals to 1 if the problem occurs, then use select expert to filter out these records. Something like: SUMPERCENT = Sum(qty_sold)/Sum(stocks) Reply With Quote 01-25-07,02:27 #3 LimaCharlie View Profile View Forum Posts Registered User Join Date Oct 2005 Posts 119 hi trowe, i already got the sum Join them; it only takes a minute: Sign up This field cannot be summarized in crystal report errors up vote 0 down vote favorite I was be able to output a By joining you are opting in to receive e-mail.

I don't know of any way to make sure that the formula is evaluated after the subreport if they're in the same section. Crystal recognizes it as a number. results.bmp 0 Message Author Comment by:jdbenike2008-09-09 Comment Utility Permalink(# a22430676) There is also two supress sections in there. Join the community of 500,000 technology professionals and ask your questions.

What I have found works is placing the following code in the Detail b/Suppress code behind:Copy Code{?View} <> '1' or ( {MyTable.Group1Field} = Previous ({MyTable.Group1Field}) and {MyTable.Group2Field} = Previous ({MyTable.Group2Field}) and I wentwithlockwelle suggestion and created a formula to accumulate a subtotal that I then display at GF1 IP Logged Printable version Forum Jump -- Select Forum -- Announcements Talk with the How to react? So if one punch is more then 30 minutes, I need all the records for that eventdate to go away. 0 Message Author Comment by:jdbenike2008-09-09 Comment Utility Permalink(# a22431161) Try

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 Why is the reduction of sugars more efficient in basic solutions than in acidic ones? 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 and Comment By clicking you are agreeing to Experts Exchange's Terms of Use.

When running the report it doesen't finish and just sits. his comment is here 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 usage of "le pays de..." Should I allow my child to make an alternate meal if they do not like anything served at mealtime? At delivery time, client criticises the lack of some features that weren't written on my quote.

but i also would like to get the grand total using this formula: subtotal of %sold divided by the no. mlmcc 0 Message Author Comment by:jdbenike2008-09-09 Comment Utility Permalink(# a22429922) when I create a new field to the details section called ---------{@count lunch test}----------- if {@shortlunch} > 1799 then 1 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 this contact form I agree it should be in a later section though if done in the correct order it will work in the same section.

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 to get the %sold, my formula is qty.sold/stocks. To view at the "Group 3" level, I Hide the Group 3 Header/Footer and add a detail row (Detail b).

IP Logged LuisSantos Newbie Joined: 22 Jul 2008 Location: Australia Online Status: Offline Posts: 11 Posted: 09 Nov 2008 at 6:42pm thank you both lockwelle RitaInHood.

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 Is there anyway that I can do this? 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 A guy scammed me, but he gave me a bank account number & routing number.

The formula will still be evaluated. Close Box Join Tek-Tips Today! stdarg and printf() in C What exactly is the alpha in the `Dirichlet Distribution`? http://outwardsound.com/crystal-report/crystal-report-viewer-cannot-find-dll.html This is Experts Exchange customer support.

Join Us! *Tek-Tips's functionality depends on members receiving e-mail. pls. 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 However the '@PA-pupil' is based on a series of other formula & sums.

This quick video will show you how to change your primary email address. 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 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 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

Experts Exchange Create a Query and Grouped Report and Modify Design using Access Video by: crystal Access reports are powerful and flexible. Great for personal to-do lists, project milestones, team priorities and launch plans. - Combine task lists, docs, spreadsheets, and chat in one - View and edit from mobile/offline - Cut down Suggested Solutions Title # Comments Views Activity Crystal Reports Formula Field 17 55 204d dynamically populate report text based on command data 7 33 139d Crystal Reports Swap Columns 2 36 So above value 1000 and 300 is not what i wan to show and debit or credit will be 0 eg accountname debit credit cash...........700......0 Above case is ok so far

I have attached the rpt file. I can't just count the rows because it will count both proper rows and duplicate rows. Privacy Policy Site Map Support Terms of Use Register Help Remember Me? help.