Bug in configuring Sorting Column

[jay@bplogix.com]

There is a bug which does not support selecting a sorting column (5. Behavior, Interaction, Sorting Column) that has a period in it.

The reason this is important is that when you create a Data Source from other Data Source, and create Results in the new data source, by default the tool uses a period in the column names it creates. For instance when you add a Column Amount, select Aggregate Function of Avg, it creates a column named Amount.Avg.

Now you can't sort on that column if it appears in a data band. You can try to select it, but notice that when you hit the dropdown again that it is not selected.

Perhaps when configuring Results in the New Data Source tab, you should not use the period in the Name of the new columns. I think it would be better to use an underscore, createing names like Amount_Max, Dollars_Avg, Name_Count, etc.

[jay@bplogix.com]

Possibly related, charts and databands do not seem to support using a calculated column as the sort field. I can configure and run the report with a calc column a sort field, but when run, the results on the chart or databand are not sorted.

[Alex K.]

Hello,

Calculated columns cannot be used for sorting, filtering, relations, and some other places. In .NET versions they are removed from the selection list. We will try to remove them as soon as possible.

Thank you.

[jay@bplogix.com]

That is too bad about the limitations with Calcuated columns

What about the other issue that does not allow columns with a period in it (for instance Result columns from Data source from other Data source)?

Thanks

[Alex K.]

Hello,

Can you please send us a sample report with test data which reproduces the issue for analysis.

Thank you.

[jay@bplogix.com]

I attached a simple report that shows that one of the header columns cannot be used to sort the results ... the one with the period character in the column name. This column was created from the data from other datasource. That automatically places periods in results columns.

This does not show the problems with Calculated Columns (soirting, filtering, relations, etc). Do you want me to create a sample showing those problems as well? Are the Calculated columns ever going to support these features?

Thanks

[Alex K.]

Hello,

Please check the modified report in attachment.

Thank you.