Hi Tim,

As I understood, we're talking about a single table here.

What do you think should I do - create one SP that will return multiple resultsets or multiple SPs to return one resultset each? If the later, should I create multiple properties for each DS and use GetDataSet for each one?

Thanks in advance.

>The table name is defined by you in the business object or by the BLG when you create your business objects and can be changed by you. It can be accessed at runtime as:
>

>myBizObj.TableName;
>

>
>On most any of the data access method calls you can pass in a table name if you want to use something other than the default. Mere Mortals is basically ADO with lost of work done for you and additional stuff added. If you want to combine multiple tables into a single dataset, then you can do that like any other ADO type stuff.
>Tim
>
>>As a practice, you should give your result set table names the same name as the table names you used when you designed the query.
>>
>>I will read data into the same typed DS definition that I used to create the report schema, so I never have to worry.
>>
>>If Mere Mortals doesn't allow you pass in your own definition of your tables names from a typed DS, I'm guessing you'd have to "name" the names afterwards. (It's been a few years since I used MM).
>>
>>However, I believe that in the absence of meaningful names, you might be able to set the report dataset tables based on position/table number within the dataset. So if your report definition used 3 tables, you can pass in a dataset at runtime with a dataset that has the 3 tables in the same order. I don't care for that practice, but it *should* work - at least it worked the first time I ever tried it.