Click here to Skip to main content
13,042,421 members (137,808 online)
Rate this:
Please Sign up or sign in to vote.

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... :-(
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=;");
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();
CrystalReport1 cr = new CrystalReport1();
this.crystalReportViewer1.ReportSource = new CrystalReport1();

Please help me.

Thanks in Advanced.
Posted 6-Mar-13 4:38am

1 solution

Rate this: bad
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;

hope it will help
also check following link...[^]
Jayanta Chatterjee 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)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.170713.1 | Last Updated 6 Mar 2013
Copyright © CodeProject, 1999-2017
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