>>Sorry, I'm not much help there. We do very little reporting out of our system, generally simple textual reports.
>>
>>Could you use something like DataSet.WriteXML to create an xml file to use with the designer?
>
>My problem is in finding a way to use the sproc to create the schema of the dataset. Once I have a dataset with the right schema at design time I can take it from there. I just find defining all those datasets to match my sprocs will be tedious and I am hoping to avoid it.
I feel the problem. I remember I had a similar issue when using SP generating multiple result sets and I manually set up each dataset. I used them in Crystal Reports, but I guess it does not really matter.
If it's not broken, fix it until it is.
My Blog