a question for client use design to edit report

[RickyHuang]

when client buy a ERP product

and client use report.design in runtime to edit report

Does the report has watermark "DEMO" ?

another question

in expression

it is work
{IIF(CS230.SumSaleAMT!=0,(CS230.Profit/CS230.SumSaleAMT)*100,0)}

but it is not work
{IIF(Sum(CS230.SumSaleAMT) != System.Convert.ToDecimal(0.00) ,(Sum(CS230.Profit)/Sum(CS230.SumSaleAMT)) * 100,0)}
the error message told me,I try to divide by 0

how can i do?

thanks a lot

[Jan]

Hello,

when client buy a ERP product

and client use report.design in runtime to edit report

Does the report has watermark "DEMO" ?

No, it does not.

but it is not work
{IIF(Sum(CS230.SumSaleAMT) != System.Convert.ToDecimal(0.00) ,(Sum(CS230.Profit)/Sum(CS230.SumSaleAMT)) * 100,0)}
the error message told me,I try to divide by 0

Try following:

Code: Select all

{Sum(CS230.SumSaleAMT) != 0d ? (Sum(CS230.Profit)/Sum(CS230.SumSaleAMT)) * 100,0) : 0}

Thank you.