How do I populate Crystal Reports, using a DataTable?

[Pierre]

Hi,

Can anyone tell me how I can populate Crystal Reports, using a DataTable in C#?

Regards,
Pierre

[Brent Thompson]

pi***********@p sitek.com (Pierre) wrote in message news:<db******* *************** ***@posting.goo gle.com>...

Hi,

Can anyone tell me how I can populate Crystal Reports, using a DataTable in C#?

Regards,
Pierre

Pierre,

This is how you do it using OLEDB, and a table view in MSSQL. This assumes
you have setup your report viewer with the wizard.

-------------------------

dataSet21.Clear ();
oleDbDataAdapte r1.Fill(dataSet 21,"your_table_ view");

CrystalReport2 custReport = new CrystalReport2( );
custReport.SetD ataSource(dataS et21);

TableLogOnInfo logOnInfo = new TableLogOnInfo( );
logOnInfo = custReport.Data base.Tables["your_table_vie w"].LogOnInfo;
ConnectionInfo connectionInfo = new ConnectionInfo ();
connectionInfo = logOnInfo.Conne ctionInfo;
// Set the Connection parameters.
connectionInfo. DatabaseName = yourcatalog;
connectionInfo. ServerName = workstationID;
MessageBox.Show (connectionInfo .ServerName);
//connectionInfo. Password = "yourpasswo rd";
//connectionInfo. UserID = "youruserid ";
custReport.Data base.Tables ["Vw_Address_Lab el"].ApplyLogOnInfo (logOnInfo);
crystalReportVi ewer1.ReportSou rce = custReport;
crystalReportVi ewer1.Refresh() ;
crystalReportVi ewer1.RefreshRe port();
-----------------------

[Pierre Basson]

Hi Brent,

Thanks, but I am still have major difficulty getting Crystal Reports to
work properly.

I have three tiers i.e. ASP.Net, Business Logic Layer and the Data
Access Layer. I get the data back from an stored proc on a SQL 2000
database and then manipulate the DataTable in the Business Logic layer,
filtering out certain records, in order to obtain the data which needs
to be displayed on the report.

The problem I am having, is populating the unbound "fields" on the
actual report with data. The report is being displayed, but I cannot
find documentation on populating the actual fields.

Does anyone PLEASE know of a way in which I can do this?

Thanks,
Pierre

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!