Creating reports and dashboards | Stimulsoft community forum

It seems that creating a Data Source from other Data source and grouping on a Calculated Column does not work.

To reproduce this, simply create a Data Source (MyDS) with
NAME (string) and VALUE (int)
then create a calculated column CALC_COL (int) as MyDS.VALUE + 1

Then create a new Data Source as Data from other Data Source, select MyDS as the source Data Source, in the Groups, select CALC_COL.

There are no errors when configuring this, but when the report is run, it does NOT group the column correctly. You would expect that all CALC_COL of the same value would be grouped together in the new datasource but they are not. The new data sources has exactly the same number of rows as the source data source ... it is not grouping correctly when the Group field is a calculated column.

My actual problem is that I want to create a data source that groups all rows together by month of a specific Date column in a data source. So I create a calcualted column in source data source as
Month(bpProcess.StartTime)
Then I group by that column. I would expect at most 12 rows in the new datasource, but because of the bug, it does not group the rows together.

Is there a workaround or fix to what I am trying to do?

Thanks!

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.

How would I create a Data source from other Data source to group all entries by the month of a date column? Basically I just want to count all the rows that happen in Jan, Feb, Mar, etc.

My first attempt was to create a calc column as Month(bpProcess.StartTime), and then group on that. Since I cant group on the calc column, how can that be accomplished?

Thanks

Hello,

Please send us your report with test data for analysis.

Thank you.

I have created/attached a simple report (with XML data from our website). It shows how I tried to create a Datasource from other datasource to group the date column by the month using a calculated field. It didn't work How else can I count all the rows with date fields that happen in Jan, Feb, Mar, etc.

Thanks

Hello,

Calculated columns cannot be used for sorting, filtering, grouping, relations, and some other places.
As a way, you can only try to modify the datasource.

Thank you.