Crystal Reports .NET DataSet problem

[alpineguy]

I've 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 doesn't come back with data, it breaks the schema and the report won't run. Is there any way to dynamically see if there's data coming back and just fill in a blank element? Or, maybe I should ask if there's an elegant way.

 

Any help is appreciated.

 

/cc

[hog]

can you not check the datasets recordcount property?

[JABE]

Or more specifically, check YourDataSet.Tables("YourDataTable").Rows.Count > 0.

[alpineguy]

*sigh* It wasn't 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. :)