Creating reports and dashboards | Stimulsoft community forum

How do I write this so it will work with c# script? It was written with vb as the scripting engine. When I try to use the & operator in place of the AND it fails. How can I write it so c# will understand it?

SumIf(DataBand1,QueryResults.Invoice_Transaction_Gross_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 check what language you are using - VB or CSharp, and use correct operators.

Thank you.

Thanks for your answers. I finally figured that out on my own.

Hello,

You are welcome.

I tried to mimic what you showed in your sample report, but now I am getting the following. What could possibly cause this?

I am using data from SQL Server. You are using xml. Could this be the problem?


On the first page the VB2 variable in the textbox doesn't present the value returned from the expression. It just shows the value 0


On the second page the returned value of the expression on the first page shows instead of what should be the returned value from the expression on the second


page.

Hello,

Please send your report for analysis.

Thank you.

Here you go. Thank you!

Hello,

Please check that this component is higher in the Report tree.

Thank you.

It doesn't work no matter what order the components are in.