Solved

How do i place more than one chart in crystal reports using xsd

Posted on 2009-04-13
6
319 Views
Last Modified: 2012-06-22
I have created a crystal report with 2 charts. For this i have pulled data from xsd file which contains two datatables. Those two charts get filled with these two tables.

My problem is when i run the report these two charts getting linked and data is changing in the charts depending upon link.

I am getting data from datatables correctly. But when shown in charts they are changing.? Can any one give solution.
MySqlConnection sqlConn = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLConnectionstring"].ToString());
                MySqlCommand comd;
                comd = new MySqlCommand();
                comd.Connection = sqlConn;
                comd.CommandType = CommandType.StoredProcedure;
                comd.CommandText = "usp_AreaByWeek";
 
                comd.Parameters.Add("?ProjID", MySqlDbType.Int32);
                comd.Parameters.Add("?inputDate", MySqlDbType.Datetime.ToString());
                comd.Parameters[0].Value = Convert.ToInt32(ddlProjTitle.SelectedItem.Value);
                comd.Parameters[1].Value = DateTime.Parse(txtStartDate.Text).ToString("yyyy-MM-dd");
if (ds.Tables[2].Rows.Count > 0 || ds.Tables[3].Rows.Count > 0)
                        {
                            myreport.Load(Server.MapPath("Reports\\SampleAreaByWeek.rpt"));
                            myreport.Database.Tables[0].SetDataSource(ds.Tables[3]);
                            myreport.Database.Tables[1].SetDataSource(ds.Tables[2]);
 
 
                            CrystalReportViewer1.Visible = true;                           
                            CrystalReportViewer1.ReportSource = myreport;
                                                   }

Open in new window

0
Comment
Question by:apramod
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 24133784
Where do you assign DS1 and DS2?

Are you using 2 data sourcesw for the report?
In general this is not supported by Crystal.
You probably need to put one in a subreport.

Are the charts in the same section?

mlmcc
0
 

Author Comment

by:apramod
ID: 24134980
I am pulling the data from two stored procedures into a xsd file.
I missed the two lines of code there where i initialize the dataset ds.
From xsd file i have taken two tables(one for each stored proc) and passing it to crystal report.

I am using only one datasource.
As i said when you place two charts they are getting linked either by two common column text or value, so even if you use subreport then also they will be linked? If they are linked data changes.

0
 
LVL 101

Accepted Solution

by:
mlmcc earned 500 total points
ID: 24144385
If you use a subreport you can use different data sources say 2 XSD files thus there is no link between them.

mlmcc
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 24663452
I believe the answer of using subreports is the way you need to go.  In each subreport you select 1 table so there is no link made between the tables.

mlmcc
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question