I agree that reverse could have been more appropriate, but I already designed the report and all the datasets, so the only step that remains is to write the SP and match the tables :)

Thus I need to know the structures I made for my tables to code the SP.

>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. :)