SumDistinct function

LukasT · Post by **LukasT** » Thu Sep 09, 2010 9:25 am

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

Post by **Alex K.** » Fri Sep 10, 2010 8:13 am

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.

LukasT · Post by **LukasT** » Mon Sep 13, 2010 3:17 am

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...

Post by **Alex K.** » Mon Sep 13, 2010 4:01 am

Hello,

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

Thank you.

LukasT · Post by **LukasT** » Fri Nov 09, 2012 3:42 pm

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!

Post by **HighAley** » Mon Nov 12, 2012 7:11 am

Hello.

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

Thank you.

LukasT · Post by **LukasT** » Mon Nov 12, 2012 7:21 am

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?

Post by **HighAley** » Mon Nov 12, 2012 7:50 am

Hello.

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

Thank you.

LukasT · Post by **LukasT** » Mon Nov 12, 2012 8:11 am

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.

Post by **HighAley** » Mon Nov 12, 2012 1:41 pm

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.