Crystal Reports .NET DataSet problem

A

alpineguy

Member
Joined
Jun 20, 2003
Messages
10
Location
Santa Barbara, CA
Ive gotten my report to do its thing with an ADO.NET DataSet, however...

I have a stored procedure that may or may not come back with data to fill the DataSet. If it doesnt come back with data, it breaks the schema and the report wont run. Is there any way to dynamically see if theres data coming back and just fill in a blank element? Or, maybe I should ask if theres an elegant way.

Any help is appreciated.

/cc
 
*sigh* It wasnt the blank data at all. In the Crystal Reports tutorial on ADO.NET, they never put the table names in the DataAdapters. This is problematic if you are only giving one DataSet to the report with multiple tables:

DataAdapter summaryDA = new DataAdapter( "exec blah.dbo 1", myConnection );
DataAdapter xutilDA = new DataAdapter( "exec blahxutil.dbo 1", myConnection );
DataSet myDataSet = new DataSet();
// Then you fill, but REMEMBER TO SPECIFY TABLE NAME

summaryDA.Fill( myDataSet, "MCSSummary" );
xutilDA.Fill( myDataSet, "MCSSummaryXUtil" );

Then all is well. :)
 
Back
Top