possible to have multiple datasources in a single XML file?

[misterstick]

could someone point me at a resource that tells me how to set an XML file to have multiple record formats so that these and the relationship between them can be read by SSRS?

i have two problems.

1. i need to pass the parameters used to create the dataset as part of the dataset. there may be any number of these with arbitrary names and datatypes. i'd like to do this generically so that i don't have to code them all individualy. an array of name, value pairs would be jim-dandy.

2. i need to pass master/detail record sets to reports. given that there may be large numbers of records, passing the master once for each detail is not an option.

many thanks in advance,


mr s. <

 

[misterstick]

ok, so here's a microsoft article that explains one way to do it.

http://msdn2.microsoft.com/en-us/library/aa964129.aspx

i've not checked whether it does what i want, but here's hoping.


mr s. <

 

[misterstick]

unfortunately, it's a pile of crap: flaky, ornery, much too simplistic.

what i'd like is this kind of structure:

<xml...>
<datafile>
<parameters><parameter...</parameters>
<master key=1><field...</master>
<detail key=2><field...</detail>
<master key=2><field...</master>
<master key=3><field...</master>
<detail key=1><field...</detail>
<detail key=2><field...</detail>
</datafile>
</xml>

and refer to an outside schema to specify how master and detail are linked to each other.

i'm not holding my breath...



mr s. <