Page 1 of 1

Use grouping in a chart

Posted: Thu Apr 05, 2012 2:49 am
by aaronrc
I'm using the designer (9.1) from Reports.Net 2012.1. I need to be able to produce a chart from my data set where the X axis is a grouped by column and the Y axis is a count of the records. Is that possible?

Each time I try and use a Count function in the chart's Value (Y axis) expression field I get an error and I also can't see any way to specify a column should be grouped in the Argument (X axis) expression.

I do have a sample report and data but can't see any attach button.

Update: Upload button appears after posting. In the attached report I need the chart to have two columns one for each of the two "inserted" column dates and the values for each column should be 3 and 4 which are the count of the number of records for each of the "inserted" values.

Use grouping in a chart

Posted: Fri Apr 06, 2012 7:33 am
by HighAley
Hello.
aaronrc wrote:I'm using the designer (9.1) from Reports.Net 2012.1. I need to be able to produce a chart from my data set where the X axis is a grouped by column and the Y axis is a count of the records. Is that possible?

Each time I try and use a Count function in the chart's Value (Y axis) expression field I get an error and I also can't see any way to specify a column should be grouped in the Argument (X axis) expression.

I do have a sample report and data but can't see any attach button.

Update: Upload button appears after posting. In the attached report I need the chart to have two columns one for each of the two "inserted" column dates and the values for each column should be 3 and 4 which are the count of the number of records for each of the "inserted" values.
You should create Data Source from other Data Source. Look at the attached report template.

Thank you.