Crystal Report not displaying data

I'm trying to get a Crystal Report to display database data and it doesn't seem to want to, all I get is the headers for the columns but it doesn't display the actual data. I know I have data since I've broken on the datatable and seen it's populated. Am I going about this the wrong way This method works with the app currently but it was developed in VS2003 without TableAdapters. I have a xsd with a bunch of table schemes in it that are used for all reports. The old reports work fine still, the only difference is that the new report has TableAdapters instead of DataAdapters to fill the dataset. Can someone shed some light for me cuz I'm stuck and the help isn't very helpfull. I'm feeling either I'm messing a step or not setting something correctly. I've got the code below to show how I'm doing this.

Thanx in advance for any help,
Evan Brown

DataSet1 m_DataSet = new DataSet1();

DataSet1TableAdapters.spCAUTAuditGetFullAuditDataTableAdapter m_TableAdapter =
new ReportTest.DataSet1TableAdapters.spCAUTAuditGetFullAuditDataTableAdapter();

DataSet1.spCAUTAuditGetFullAuditDataDataTable m_Table =
new DataSet1.spCAUTAuditGetFullAuditDataDataTable();

CrystalReport1 m_Report = new CrystalReport1();

m_Report.SetDataSource( m_DataSet );
m_TableAdapter.Fill( m_Table, 479 );

crystalReportViewer1.ReportSource = m_Report;
crystalReportViewer1.RefreshReport();

Answer this question

Crystal Report not displaying data

Harrie Nak

Hi,

I need your help

I am new to Crystal Report...

I need to know how to work with the reports using C# and Crystal Report in a simple program which will pass the data to the report in SQL statement..

let's say I have staff record and I want to pass something like:

select * from staff_data where staff_id = txtStaff_id.Text
Douglas Lellis
Nevermind I figured out what I was doing, not using the table in the dataset is what I was not doing. Stupid :P

Evan
Crystal Report not displaying data

Answer this question