I'm developing an application in VB.NET using Visual Studio 2008.
I've successfully used the Microsoft Reporting Wizard to generate reports from an SQL server database and from SQL compact database files.
I've created an untyped dataset containing a single table in my main form. My application is filling the table with data at runtime and displaying the data in a datagridview.
Is it possible to report the contents of the table contained in the untyped dataset object in the form? The reporting wizard doesn't seem to offer me the option of choosing the dataset as my datasource.
I've tried adding and configuring the dataset in the solution explorer. This dataset IS visible to the report designer now, but I can't work out how to refer to it from my code!! Should it be an embedded resource? How do I get at it from the code? That must be a simple one to solve!
Or, am I just going about the whole thing the wrong way?!