Hi,
I m using Reportviewer control to show my statistical reports
I need to show the report both in the form of table and chart
Scenario :
I have set of clients say (100 clients) in that I have various categories like age, sex, marital status and so on
Now I need to show report for each of these categories like this
Percentage of male, female ( with data and Chart)
Percentage of married, unmarried.. (with data and chart)
Percentage of below 18, Mean,Median,Mod e, Minimum and Maximum (with data and chart)
For all these I take each category as one datatable with data and count
ex:
Sex Count
Male 20
Female 80
This is the datatable I bind to the reportviewer table and chart
I am able to calculate the percentage in the table with the following expression
=Round((Fields! Count.value/Sum(Fields!Coun t.Value))*100,2 )
But When I give the same expression in Data region of Chart control I m not able to get the percentage I get 100%...
It does not take sum of the count values..
How to calculate the sum of count value of each row and give it in one expression so that I can calculate the percentage for each row automatically
It is bit urgent
Hope I m clear in my query
Thanks in advance
I m using Reportviewer control to show my statistical reports
I need to show the report both in the form of table and chart
Scenario :
I have set of clients say (100 clients) in that I have various categories like age, sex, marital status and so on
Now I need to show report for each of these categories like this
Percentage of male, female ( with data and Chart)
Percentage of married, unmarried.. (with data and chart)
Percentage of below 18, Mean,Median,Mod e, Minimum and Maximum (with data and chart)
For all these I take each category as one datatable with data and count
ex:
Sex Count
Male 20
Female 80
This is the datatable I bind to the reportviewer table and chart
I am able to calculate the percentage in the table with the following expression
=Round((Fields! Count.value/Sum(Fields!Coun t.Value))*100,2 )
But When I give the same expression in Data region of Chart control I m not able to get the percentage I get 100%...
It does not take sum of the count values..
How to calculate the sum of count value of each row and give it in one expression so that I can calculate the percentage for each row automatically
It is bit urgent
Hope I m clear in my query
Thanks in advance