Naomi, I do this in reverse...

Many times, I've done it this way...

- Create and test a stored proc in SSMS

- Write a simple .NET program to read the results of the stored proc into a dataset....provide my own table names....and then write it out to an XML/XSD file (some people will write reusable utilities to do this....

- Design the CR report from the XSD file

- in the actual application at runtime, push a dataset with the same structure (hence the value of typed datasets) into the report object.

I hate to advertise, but if you're doing this for work, I'd really recommend getting my VS reporting book. A few things need updating for 2008, but the reporting methodology in the book is still valid and is being used by many.


You don't need no stinkin' printouts. :)