Creating reports and dashboards | Stimulsoft community forum

Hello,
I have requirement for SumDistinct function... do you have any solution for this requirement? Will you implement this function?
Thank you

Hello,

This function is not in the designer, but you can add this to the code of the report.
Please see the sample report in attachment.

Thank you.

Hello Aleksey,
I am sorry, but this solution is absolutely unusable... We have approximately 2000 base templates of reports now converting to Stimulsoft format using automatic process. So we can't add manually into every report special code. Especially when we have this functions complicated like this:
sum(column1 for group x DISTINCT column2)
It will be very helpfull if you implement this often used function into your designer-functions...
Thank you for your advice...

Hello,

Unfortunately, on this moment we do not have plans to develop this feature. Sorry.

Thank you.

Hello,
I am back with need of some solution for next case - I need SumDistinct function which will be looking for distinct values of one column (expression) but do sum for second column (expression).... SumDistinct(dataSource, distinct column/expression, sum column/expression)... we have a lot of reports, where this function is important and we are not able to do this manually by using AfterPrint event.... please help me...
Thank you!

Hello.

You could use SumDistinct() function. It already exist in our product.
Do you have any problems with it?

Thank you.

Hello Aleksey,
I know about SumDistinct function, but it can sum only the same column for which is looking for distinct values. I need standalone parameter for distinct values and for sum values.... Do you understand what I mean?

Hello.

Unfortunately, there is no such function. You could implement it like in the sample in the one of previous posts.

Thank you.

I know, that I am able to do it using AfterPrint event, but we are converting thousands of reports to Stimulsoft automaticly and we are not able to solve all SumDistinct functions manually using AfterPrint event... Our old reporting system has this function, so I think this is common usable function, which should be even in your system.

Hello.

Please, send a detailed description of the function that you need to support@stimulsoft.com and we'll consider a possibility of its implementation.

Thank you.