Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VS2008 C# SQL CrystalReports , +
Hi,
 
I want to set data source dynamically to a Crystal Report in C# Winform application..
But when I create the crystal report with "Using the Report Wizard", it shows all records fields in crystal report..
 
I checked the SQL Query in Crystal Report -> Right click on "Database Fields" in Field Explorer and then click on "Show SQL Query..."
It show simple connection, which fetch all records from two tables..
 
How to set that SQL Query dynamically???
 
I tried to set dataset, when I call the Crystal report, but it does not worked... Frown | :-(
My C# code is :-
OleDbConnection con = new OleDbConnection("Provider=Microsoft.jet.oledb.4.0; data source=" + Application.StartupPath + @"\DataInfo1.mdb;Persist Security Info=true;User Id='Admin'; password=;");
 
con.Open();
 
OleDbDataAdapter da = new OleDbDataAdapter(@"SELECT ct.custID, c.custName, c.custAdd,ct.custTranDate,ct.custTranType,ct.custPaidAmt,ct.custDueAmt, c.custArea FROM custTransaction ct left JOIN custDetails c ON ct.custID = c.custID where ct.custID='CUST-000002' and ct.custTranDate BETWEEN #2/28/13# AND #3/1/13#", con);  
          
DataSet ds = new DataSet();
da.Fill(ds);
 
CrystalReport1 cr = new CrystalReport1();
cr.SetDataSource(ds);
this.crystalReportViewer1.ReportSource = new CrystalReport1();
this.crystalReportViewer1.Show();
Please help me.
 
Thanks in Advanced.
Posted 6-Mar-13 5:38am
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

u r problem is over here
this.crystalReportViewer1.ReportSource = new CrystalReport1();
u have to use as follows
this.crystalReportViewer1.ReportSource = cr;
this.crystalReportViewer1.Refresh();
hope it will help
also check following link...
http://csharp.net-informations.com/crystal-reports/csharp-dynamic-crystal-reports.htm[^]
  Permalink  
v2
Comments
Jayanta Chatterjee at 6-Mar-13 11:16am
   
Thankss a Lottttttttt Sir...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 6 Mar 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100