mw112009 (9/28/2016)
Sue_H:I know how to do the XL Query stuff.
Unfortunately that still leaves us having to do further scanning to get the name of the table etc.
I have pasted a section from the XML. If you see we have to first check whether the report has a query and then we have to scan the entire section between the <CommandText> and </CommandText> part and then we don't know whether MHPEDI834 is an table or view ?
<Query><DataSourceName>TransferDB</DataSourceName>
<QueryParameters><QueryParameter Name="@ID">
<Value>=Parameters!ID.Value</Value></QueryParameter></QueryParameters>
<CommandText>
SELECT ID, MemberEDIData
FROM MHPEDI834
WHERE (ID = @ID)
</CommandText>
</Query><Fields>
<Field Name="ID">
<DataField>ID</DataField><
Correct as Reporting Services has no knowledge of all the details of the data sources used. It wouldn't know whether something is a view or a table, it just knows the commands that are executed against the data source since that is what is used when rendering the report.
Sue