Creating reports and dashboards | Stimulsoft community forum

Hello,

I am trying to find each line item of type "Return", and multiply the quantity by -1 if true, by +1 if false.

I am using the following expression in my databand filter: I am receiving the error: "Cannot implicitly convert type 'object' to 'bool'
What cast am I missing or doing wrong?


Thanks,
David

Hello,

Please send us your report with test data which reproduces the issue for analysis.

Thank you.

Aleksey wrote:Hello,

Please send us your report with test data which reproduces the issue for analysis.

Thank you.

Hi Aleksey, thanks as usual for the response!

Attached is a version of the report that is receiving the casting error.

The image below is almost what I need.
https://ibb.co/jqH5ka

But what I need to do in the designer is change the quantity of all return transactions to a negative.
The ultimate goal would be to add a group summary summarizing the positive int issue transactions, and the negative int return transactions.

i.e.
return -10
return -5
issue 25
total 10



in addition to the IIF function, I did also try using the ternary operator, but ran into the same error. I am open to any other suggestions!

Thanks in advance!
David

Sorted it out!

I applied this directly to the Quantity data source, instead of adding to the databand filter Thank you though for your response!


David

You are welcome, David!

Have a nice day!