Reporting Services XML query: displaying all the columns of a datatable

Question

Hi everyone,

          <Query>
          <Method Namespace="http://schemas.mycompany.com/ourproduct/2010/09" Name="GetSomethingRequest">
          <Parameters>
          <Parameter Name="Parameters" Type="XML">
          </Parameter>
          </Parameters>
          </Method>
          <SoapAction>
                http://schemas.mycompany.com/ourproduct/2010/09/IService/GetReportData
          </SoapAction>
          <ElementPath IgnoreNamespaces="True">
GetSomethingResponse{}/Data{}/diffgram{}/ReportDataSet{}/EntityMembers
 </ElementPath>
</Query>

EntityMembers is the resulting datatable, but when running the query all the columns on the table are not displayed. I know I could specify the columns that I need using something like this {column1, column2, column3}, however I would rather have a way to get them without specifying them. Thanks in advance.

Answer 1

Try the Reporting Services group.

The Tabllix control in Pivot mode can do rows-to-columns conversion but you need to know some structure beforehand.

Answer 2

Hi wBob,

I don't understand your reply. Could you please explain in more details? Thanks.

Answer 3

I think you would be better asking this question on a Reporting Services newsgroup?

I do know of the Matrix control in SSRS, which can pivot data when column names are unknown, eg

http://msdn.microsoft.com/en-us/library/ms157334(v=sql.100).aspx

Answer 4

Thanks. I will do that.