Creating reports and dashboards | Stimulsoft community forum

I don't understand why I am getting an error ') expected' when I try to replace the 'QueryResults.Invoice_Transaction_Broker_Commission_Amount' with 'Switch(QueryResults.Invoice_Transaction_Broker_Commission_Amount = DBNull.Value, 0, QueryResults.Invoice_Transaction_Broker_Commission_Amount != DBNull.Value, QueryResults.Invoice_Transaction_Broker_Commission_Amount)' in the following expression.


{SumIf(DataBand1,QueryResults.Invoice_Transaction_Broker_Commission_Amount,QueryResults.Invoice_Transaction_Charge_Code_Description="Property & Casualty Premium"
AND QueryResults.Invoice_Production_Reporting_Date>= VI2
AND QueryResults.Invoice_Production_Reporting_Date<=VI3)}

{SumIf(DataBand1,Switch(QueryResults.Invoice_Transaction_Broker_Commission_Amount = DBNull.Value, 0, QueryResults.Invoice_Transaction_Broker_Commission_Amount != DBNull.Value, QueryResults.Invoice_Transaction_Broker_Commission_Amount), QueryResults.Invoice_Transaction_Charge_Code_Description="Property & Casualty Premium"
AND QueryResults.Invoice_Production_Reporting_Date>= VI2
AND QueryResults.Invoice_Production_Reporting_Date<=VI3)}

Hello,

Please send us your report for analysis.

Thank you.

Can you evaluate the report without data? I can't give you the data because it is proprietary.

Please see the attached. Is this enough to evaluate?

Hello,

We need some additional time to investigate the issue, we will let you know about the result.

Thank you.

Hello,

Please check the following expression:
{SumIf(DataBand1,Switch(QueryResults("Invoice_Transaction_Broker_Commission_Amount") = DBNull.Value, 0,
QueryResults("Invoice_Transaction_Broker_Commission_Amount") <> DBNull.Value, QueryResults.Invoice_Transaction_Broker_Commission_Amount),
QueryResults.Invoice_Transaction_Charge_Code_Description="Property & Casualty Premium" AND QueryResults.Invoice_Production_Reporting_Date >= VI2 AND QueryResults.Invoice_Production_Reporting_Date <= VI3)}

Thank you.