Report Summary's Value op_Div(Decimal Object) Error

Stimulsoft Ultimate discussion
Post Reply
harundemir13
Posts: 24
Joined: Thu Aug 01, 2019 1:22 pm

Report Summary's Value op_Div(Decimal Object) Error

Post by harundemir13 » Wed May 05, 2021 11:42 am

Hello,
I use GroupHeaderBand in the report. I want to get the quantity rate and I show this value in DataBand.
It possible using {colSumRunnig(DATA.quantity)} with GroupHeaderBand and it is not working true value by {Sum(DATA.Quantity)}.
After, I get an error message "There is no matching overloaded method for 'op_Div(Decimal.Object)' when I wrote this formula {IIF(DATA.quantity==0,0,DATA.quantity/colSumRunning(DATA.quantity))}.

In Summary, I want to get quantity rate values for all report quantity values and I can use GroupHeaderBand and I should be able to show rate value in DataBand. How use a formula for quantity rate?
Thank you,
Lech Kulikowski
Posts: 3665
Joined: Tue Mar 20, 2018 5:34 am

Re: Report Summary's Value op_Div(Decimal Object) Error

Post by Lech Kulikowski » Fri May 07, 2021 2:09 pm

Hello,

Please check the following expression:
{(DATA.quantity==0 ? 0 : DATA.quantity/(decimal)colSumRunning(DATA.quantity))}

Thank you.
harundemir13
Posts: 24
Joined: Thu Aug 01, 2019 1:22 pm

Re: Report Summary's Value op_Div(Decimal Object) Error

Post by harundemir13 » Tue May 11, 2021 12:32 pm

Hello,
Thank you for your response, it worked on designer. As I understand colsum function not supported in .net because it didn't work in .net app.
Thank you.
Lech Kulikowski
Posts: 3665
Joined: Tue Mar 20, 2018 5:34 am

Re: Report Summary's Value op_Div(Decimal Object) Error

Post by Lech Kulikowski » Wed May 12, 2021 8:14 am

Hello,

Could you explain your issue in more detail?

Thank you.
harundemir13
Posts: 24
Joined: Thu Aug 01, 2019 1:22 pm

Re: Report Summary's Value op_Div(Decimal Object) Error

Post by harundemir13 » Mon May 17, 2021 6:16 am

Hello,
Colsum function ran in the report with using this {(DATA.quantity==0 ? 0 : DATA.quantity/(decimal)colSumRunning(DATA.quantity))} but this function's use didn't print value in the report when preview .net app.
Thank you.
Lech Kulikowski
Posts: 3665
Joined: Tue Mar 20, 2018 5:34 am

Re: Report Summary's Value op_Div(Decimal Object) Error

Post by Lech Kulikowski » Mon May 17, 2021 11:09 am

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.
harundemir13
Posts: 24
Joined: Thu Aug 01, 2019 1:22 pm

Re: Report Summary's Value op_Div(Decimal Object) Error

Post by harundemir13 » Tue May 18, 2021 7:44 am

Hello,
I don't send a report but I got the same situation in demo.stimulsoft.com with attachment file
Thank you
NestedGroups.mrt
(289.24 KiB) Downloaded 63 times
Lech Kulikowski
Posts: 3665
Joined: Tue Mar 20, 2018 5:34 am

Re: Report Summary's Value op_Div(Decimal Object) Error

Post by Lech Kulikowski » Wed May 19, 2021 11:32 am

Hello,

Unfortunately, cSum is not implemented in the Interpretation mode. Sorry.

Thank you.
harundemir13
Posts: 24
Joined: Thu Aug 01, 2019 1:22 pm

Re: Report Summary's Value op_Div(Decimal Object) Error

Post by harundemir13 » Thu May 20, 2021 6:49 am

Hello,
Thank you for your response.
Lech Kulikowski
Posts: 3665
Joined: Tue Mar 20, 2018 5:34 am

Re: Report Summary's Value op_Div(Decimal Object) Error

Post by Lech Kulikowski » Fri May 21, 2021 12:25 pm

Hello,

You are welcome.
Post Reply