473,322 Members | 1,188 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Bars In Chart Are Displaying With The Same Height In Reportviewer Control In Winfom

6
I am developing an application which displays a chart using the reportviewer control. The issue is that all the bars in the chart are displaying at the same height when in actual fact,they should be at different heights because they have different values: (23,1,62,1,4)...how can i get the bars to represent the values that are shown in the series fields?.. Here is the code that generates the report:
Expand|Select|Wrap|Line Numbers
  1.  try
  2.         {
  3.  
  4.             MySqlConnection connection = HopeDB.GetConnection();
  5.             string selectStatement = " SELECT COUNT(benf_id)Id,NAME Disease FROM visit_history JOIN diagnosis ON(visit_history.diagnosis=diagnosis.id) GROUP BY name ";
  6.             MySqlCommand command = new MySqlCommand(selectStatement, connection);
  7.             MySqlDataAdapter adapter = new MySqlDataAdapter();
  8.             DataSet ds = new DataSet();
  9.             DataTable dt = new DataTable();
  10.             dt.TableName = "DataSet1";
  11.             adapter.SelectCommand = command;
  12.             adapter.Fill(dt);
  13.             adapter.Fill(ds);
  14.             reportViewer1.LocalReport.DataSources.Clear();
  15.             ReportDataSource source = new ReportDataSource("DataSet1", dt);
  16.             reportViewer1.LocalReport.DataSources.Add(source);
  17.             this.reportViewer1.RefreshReport();
  18.  
  19.         }
  20.  
And here is the chart generated from the code:
graph.jpg
Sep 21 '12 #1
0 1595

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Raghu | last post by:
I have developed a web portal that uses ReportViewer web control to connect to a remote SQL 2005 Report server and displays the reports on the client side. The asp.net page has been coded to...
4
by: Sevu | last post by:
I am working with ASP.NET.I am using ReportViwer Control to show my report.I like to add dropdownlist with in the reportviewer control. ( Not top to the control some thing like that).I need to...
1
by: Rich | last post by:
Hello, I am trying to use the Reportviewer control. I have been following an example from the web, and the instructions from the help files on set up a ..rdlc and binding it to the reportviewer...
0
by: Fred G. Sanford | last post by:
Firstly, I am a fairly new .Net developer, so please excuse any dumb/ignorant questions or comments. Thanks. I created a VWD Express project, which uses the ReportViewer control, on my local...
0
by: user | last post by:
The reportviewer control has a skinid property, but I am unable to create the theme in my .skin file. Ive created themes for controls that are of the format <asp:, but Im unable to create on...
10
by: AG | last post by:
I am trying to use a ReportViewer control in a VS 2005 web application project (not Website project). When I try to create a new report (local), I can't seem to find any method to create a...
7
by: AG | last post by:
I am using a ReportViewer control in an ASP.NET 2.0 WAP aspx page in remote processing mode. The report server is on a shared web host. Can anyone tell me or point me to an example of how to...
0
by: =?Utf-8?B?ZGF2ZTMuNQ==?= | last post by:
Are there any plans for a native WPF .Net Framework 3.5 ReportViewer Control? The WinForms ReportViewer Control can be used in a WPF application but it will not compile to a WPF Browser...
1
by: Larry Bud | last post by:
I have a reportviewer control. I programmatically set the local report path based on a drop down on a page. This allows the user to choose which format (RDLC file) to use when generating the...
1
by: ajaykhedekar | last post by:
I am Showing Mulitple MSRS Reports on Single ASP.Net WEB Page using Mulitple ReportViewer Controls. If User wants to Print the Reports, then user has to click Print button provided by ReportViewer...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.