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

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

apramodAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
If you use a subreport you can use different data sources say 2 XSD files thus there is no link between them.

mlmcc
0
 
mlmccCommented:
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
 
apramodAuthor Commented:
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
 
mlmccCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.