Creating reports and dashboards | Stimulsoft community forum

Hi Stimulsoft team,

Currently working on some reports that should be able to dynamically render age bucket columns. To do this, I generate a second data source table that acts as a pointer to the aging-bucket cutoff fields in the first data source table.
To then get a summation of the aging buckets, I use a SumIf function inside the cross data band inside the group footer and report footer. However, this does not render correctly

I've attached a sample report with some embedded data. To explain, the cross band in the group footer and report footer bands should be showing a bucket summary for each bucket e.g. 30-60, 60-90 etc, but only shows 0. It's like it is not applying the age breaks correctly.
This may look a little weird so let me know if I need to explain better.

Kind Regards,
Michael

Hello,

You CrossDataBand1 is used as the data source - AgeBreaks, but in the expression, are uses columns from the DataSource1. It is not correct.

Thank you.

Hi Lech,

Yes, this is what was intended. The cross band outputs 1 sum per item in AgeBreaks, but the sum is over the values shown in DataBand1, which are from DataSource1.

Is there any way to make this approach work? Do summaries not work across data sources in cross bands?

Much obliged,
Michael

Hello,

Unfortunately, it's difficult to give specific advice. We don't fully understand your task or the calculations you're using to calculate the sums.

Thank you.

Hello Lech,

I understand, our use case does seem quite strange. I've attached an annotated image that might help explain.

Our product lets the user specify in data how many age buckets they want and their values, so I was trying to use the cross band to dynamically create the correct number of age bucket fields and the summaries relevant for the report.
The age bucket values in the databand are correct, for instance the first line is 48 days old so shows "714" in "30-60". However, the sum doesn't function correctly. Is this just a limitation of the software?

Apologies if this explanation doesn't help much, I do realise this is a strange requirement. If this can't work, I'll try to find a way to modify the template programmatically to achieve the desired results.

Thanks,
Michael

Hello,

We need some time to investigate the issue, we will let you know about the result as soon as possible.

Thank you.