crystal-reportscrystal-reports-formulas
Conditional formula SUM in Crystal Reports does not work
I am making a custom sum formula in my Crystal Report. The key is to sum records when another cell has a specific value. For example... I have 2 rows with 3 records for each. If the value in the first row is 1 in two records, I want to sum those 2 records in the other row. You can find my example which is not working. Regards.
if {sp_rptInternal;1.Tax_Rate_Percentage}=10.00
then
Sum ({sp_rptInternal;1.Sell_Price})
UPDATE 1: Values(bold) from the red rectangle needed to be placed inside my custom table below. UPDATE 2: I tried grouping with Image 2 and 3, but it is not working.
Image 1.
Image 2.
Image 3.
Solution
The only possible way is to make shared/global variables which can be used anywhere, in every section of the report, dynamically. Source can be provided from code-behind or via formula.
- Remove login requirements for Crystal Report
- Find instance of a formula on a report when it's been hidden
- Formula to change how a number is displayed in crystal reports
- Crystal report 2008: How to extract "Report Custom Function" content from the rpt file
- Intermittent Crystal Reports error "The request could not be submitted for background processing."
- Crystal Reports: "Failed to Save Document" after changing Datasource
- Crystal Report- how to round decimal in crystal report?
- How to group by one field and sort by another field with Crystal Report
- Crystal Report Running Total
- In Crystal Reports I have a Parameter field + 2 years
- In Crystal Reports, How do I count all the rows in the Details section and place that count in the header?
- Crystal Reports Error in ASP.NET Core MVC. Could Not Load File
- "Database logon failed" in Crystal Reports when using System DSN for MySQL Server
- Is there a way how to fix the size of textboxes in crystal report?
- Crystal Reports Exception: The maximum report processing jobs limit configured by your system administrator has been reached
- How to find Datasource in Crystal reports
- Crystal Reports - Access All Rows Returned by a Query Instead of One at a Time
- How to implement Crystal Reports in Java EE
- Problem with visual basic 2022 and crystal report
- I am receiving a color formatting error when trying to run a Crystal Report in Personify
- Can I use Crystal Reports in Visual Studio 2022?
- Multi group with multi column in crystalreport
- How to add a JNDI to a Crystal report bean?
- Crystal Reports RecordSelectionFormula does not work
- Crystal Report Issue with IIS - ( bobj is undefined , Crystal report not displaying )
- Crystal Reports for VS 2008 - "The user function manager DLL (ufmanager.dll) could not be found."
- Crystal Reports 9 - Create parameter fields in batch instead of creating one by one
- How to use Interleaved 2 of 5 barcode font in Crystal Reports
- Crystal Report - Add bottom margin on all pages for the text object with 'can grow' parameter active
- IS NULL configuration assistance please