Home > Crystal Reports > Crystal Reports Cannot Summarize Formula Field

Crystal Reports Cannot Summarize Formula Field


So that is the dliema. 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 Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud 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} - have a peek here

Get 1:1 Help Now Advertise Here Enjoyed your answer? Join & Write a Comment Already a member? products" or "average(%sold subtotal), but an error "this field cannot be summarized" appears. So if i wanted to reset the value for each new eventdate per person, how would I do that? http://scn.sap.com/thread/1888084

Crystal Reports Cannot Summarize Formula Field

Results 1 to 2 of 2 Thread: Field cannot be summarized Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode is their another way to design the code to get the break time between the 1:16-146 or 3:57 to 4:13??? 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 Their is no actual table field that shows the break time.

Which, is basically the report iam using now so it had all the same fields. I even mentioned this to my boss and he is considering keeping us on this site and having the company cover for it. 0 LVL 100 Overall: Level 100 Crystal Connect with top rated Experts 22 Experts available now in Live! Everytime 1 occurred I could just use select expert to filter out these results.

Yet, the breakfules in the tables don't work that way, and the way it's pulling data is incorrect. Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Business Objects: Crystal Instead you need to think outside of the box and come up with another way to get the data you want. 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.

Summary Fields. Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... That suppress field with that code in just takes out the invidual lines where a 30 minute shift shows, but still leaves the other part of the shift on a seperate Insert.

Crystal Reports Whileprintingrecords

An analogy: You have two observers (group headers) of a field full of cows and calves(details). https://www.experts-exchange.com/questions/23712223/Crystal-Reports-error-This-field-cannot-be-summarized.html However the '@PA-pupil' is based on a series of other formula & sums. Crystal Reports Cannot Summarize Formula Field Login. Close this window and log in.

Hot Network Questions How to make my logo color look the same in Web & Print? navigate here I am hoping that someone will be able to tell me another way of doing this. I created a subreport based on a existing report. How to delete the lines from a file that do not contain dot?

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 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 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 Check This Out 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

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? Hell, ill pay for a year membership if I have to. 0 LVL 100 Overall: Level 100 Crystal Reports 94 Message Active today Expert Comment by:mlmcc2008-09-09 Comment Utility Permalink(#

Anyways This causes the report to never finish and just hangs up when I run it. 0 Featured Post Why You Should Analyze Threat Actor TTPs Promoted by Recorded Future After

Then summarize each section so that it equals to 1 if the problem occurs, then use select expert to filter out these records. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. stdarg and printf() in C The cost of switching to electric cars? The time now is 12:49.

help. http://i2.photobucket.com/albums/y12/jdbenike/untitled-1.jpg That's a picture of the results. Then pulling that back to the main report somehow and filtering the results? this contact form of products.

Reply With Quote July 21st, 2005,02:44 AM #2 Madhi View Profile View Forum Posts Senior Member Join Date Jul 2004 Location Chennai, India Posts 1,064 Re: Field cannot be summarized What Without knowing that, I still cannot tell whether you can simply use formulas that reference a different group level. I agree it should be in a later section though if done in the correct order it will work in the same section. Join & Ask a Question Need Help in Real-Time?

All rights reserved.