How t have the RDLC pie chart show ranges instead of individual values

Posted by Emad on Stack Overflow See other posts from Stack Overflow or by Emad
Published on 2010-04-20T20:10:00Z Indexed on 2010/04/20 20:13 UTC
Read the original article Hit count: 501

Filed under:

rdlc

I have some data coming from a custom dataset that look like the following example

Person Age

P1 20

P2 21

P3 30

P4 31

P5 40

And I want to develop a pie showing the age distribution against the age.

The point is that I want this Age to be shown in ranges. (20-29, 30-39, etc for example So we have: Slice with total number =2 (P1 + P2) as age is 20-29 (one at 20 and another at 21)

Slice with total number =3 (P3 + P4) as age is 30-39 (one at 30 and another at 31)

Slice with total number =1 (P5) as age is 40 (one at 40).

How can i customize the pie chart to aggregate values by ranges that I can define?

Related posts about rdlc

Reporting Services 2010 RDLC: Passing Querystring Parameters from an RDLC

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to build a simple RDLC report that shows some data, and has a 'select' link that sends the browser off to a certain url with some data in the querystring (a key). In the vs2010 report designer, I can double-click on the column, then select action, and there are a bunch of thigns that… >>> More
dynamically setting the size of a textbox in a RDLC report

as seen on Stack Overflow - Search for 'Stack Overflow'
Can a textbox's width in a local RDLC report be set dynamically using C#? I would like to auto size the horizontal width of the text box based on the data it contains. >>> More
Problem sub-total Matrix with rdlc report in vb.NET

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi everyone, I have a matrix and I need to add the money earned this year and past years. However, I must remove the money spent in past years. I must have the separate amount per year and the total of these amounts. This is what gives my matrix: Year = Fields!Year.value =formatnumber((sum(Fields… >>> More
When to use RDLC over RDL reports?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have been studying SSRS 2005 / 2008 in the past weeks and have created some server side reports. For some application, a colleague suggested that I look into RDLC for that particular situation. I am now trying to get my head around the main difference between RDL and RDLC. Searching for this information… >>> More
RDLC - Adding a Data Source in VS2010

as seen on Stack Overflow - Search for 'Stack Overflow'
Greetings. I have an RDLC file and am wanting to add a data source to it, although without any luck so far. The data source is a custom class written by myself (just to add, we do this all the time). We recently converted over to the VS2010 RDLC format which caused some problems, but we've made… >>> More

Developer IT