Creating reports and dashboards | Stimulsoft community forum

Hi,

i have a problem with sorting on DataBand, when I use Count function from other Databand.
I have databand "DataBandUchazec" and detail databand "DataBandUdaje".
In DataSource "PrijimaciRizeniUchazec" i have calculated column "SumaZnamek" that use Count function on databand "DataBandUdaje" (see the first attached image - "databand-sorting-calculated-column.png").
On DataSource "PrijimaciRizeniUchazec" i use sort by calculated column "SumaZnamek" (see the second attached image - "databand-sorting.png"), but sorting not working (see the third attached image - "databand-sorting-calculated-column.png").

What am I doing wrong?

In attachments i send MRT file and XML data.
I use Stimulsoft Report.Net version 2013.3.1800 and Stimulsoft Report.Web version 2014.1.1807.0.

Thanks, for help

Hello,

Unfortunatley, it is not possible to use the Calculated columns in sorting, filtering.

Thank you.

Thanks for your answer.

Is there any other solution? For example do not use calculated column and use just expression in text field?

Thank you.

Hello,

In your report the CalculationMode property set as Interpretation. For this mode there is no solution with current data.
For Compilation mode you can use the following expression in the Sorting for DataBandUchazec band:
Totals.Count(DataBandUdaje)

Thank you.

OK,

Thank you.

Hello,

Do not hesitate to contact us in case you have additional questions.
Thank you.