Click here to Skip to main content
15,890,527 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
We have requirement in Crystal report where we have to implement 2 concept in one column. For eg: in below screenshot,  if we have numbers we need to sum up and display as one row.  if it is variable row. It should remain as single row.
Material Quantity Price
O Ring 1 5.61
O Ring 1 Fixed
O Ring 1 5.61
O Ring 1 Fixed

Output should be,
Material Quantity Price
O Ring 1 11.22
O Ring 1 Fixed
O Ring 1 Fixed

Kindly pour us some suggestions if any.

What I have tried:

This is the existing functionality of the report. Can you please help me in modifying it to get desired expected output.
If Not (Val({sm07.FNSM07StructLineNo}) <> 0 And Trim({SM07.FNSM07NodeID_BOM_SM}) <> "") Then  
(
    if {SM07.FNSM07InclFixPrice} = "0" or {InvParameters.FNInvParametersFixPriMatICU} = 0 then
        ToText ( {CalcMaterial.FNCalcMaterialOrderDiscount},{CalcTotals.FNCalcTotalsAmmdec})
    else 
        "Fixed"
)
Else
    ""
Posted
Updated 9-Apr-18 23:54pm

1 solution

Here is the workarround:
- First you have to make group by with Material and add SUM(Price)
- For "Fixed" or any static value you can define NULL
- Now in the display you can use expression like if value is NULL then display "Fixed" otherwise Value (as it is)
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900