Issue with Chart and Filter/Sort with MasterComponent

[MatthiasU]

Hello,

I have a template with two datasources and a relation between them. I have placed a DataBand for the master datasource and a DataBand and a Chart showing data from the second datasource.

My problem: the chart did not consider the defined filter/sort properties.

Please see attachement for a simplified sample with defined sort.


Thanks & Regards,
Matthias

[Alex K.]

Hello,

We need some additional time for investigating the issue.
We will let you know about the result.

Thank you.

[Alex K.]

Hello,

Sorry for the delay with response.

In this case, your XML data provided without XML schema. When in sorting specify a column, ADO.NET uses the amAssetValue column as string type in sorting.
Please try to set the expression for sorting instead select column: AssetData.amAssetValue. In this case, sorting produced with our internal engine methods. Also, you can specify XML schema for your data.

Thank you.

[MatthiasU]

Hello,

still did not work as expected.

I have changed the datasource to xml with schema. But the chart sort is the same as the sort of DataBand2. If I replace the chart through a second panel with an additional DataBand, the sort is considered correctly.

Please check again with new attachement.

Many thanks.


Regards,
Matthias

[Alex K.]

Hello,

We couldn't reproduce this bug.
Please try to check the last prerelease build.

Thank you.

[MatthiasU]

Hello,

no, it's still not working. The sort order of the chart is always the same as the sort order of the databand. Please try to switch ascending/descending or change the sort column to txValueShort1.

Thanks & Regards,
Matthias

[Alex K.]

Hello,

Please try to use the additional data source for the Chart.

Thank you.

[MatthiasU]

Hello,

thanks. But it seems to be just a workaround, with a high bug potential for report developers. It's not intuitive that I have to duplicate my datasource & datarelation just for this.

How is it implemented? Do you create two Datatables in this case? Could lead to high memory consumption...

Is there no way to fix the issue?


Many thanks & Regards,
Matthias

[Alex K.]

Hello,

It is a feature of the engine.
In this case, you place on one band two components which are working with one data source. And each of them when rendered, changes position in the data source for working with data rows. In this case, you should use two different data source or use them on the different DataBand components.

Thank you.

[MatthiasU]

Hello,

OK, I have find out, that it works great, when I put the chart in an additional panel. That's not intuitive...but I can live with this solution.

In my opinion, the chart should be handled always as he is placed in a panel, because you can't put another similar control (like databand) directly in a databand. Maybe as an global option?

Is there any possibility to modify your "engine feature"?


Thank you.