sql server 2005 reporting services and xml data (Full Version)

All Forums >> [Ask XML questions here] >> .NET programming discussions



Message

pragaw -> sql server 2005 reporting services and xml data (15 June 2007)

Hello,

Has anybody worked with xml and sql reporting? Is web service the only way to go about it? I have an xml file accessible through a url and xslt sheet in the application directory to transform data for the application. I have troubles with reporting on that xml file. My connection string is the url pointing to the xml. What would be the syntax for the <query> tag?

thank you



subodhk -> RE: sql server 2005 reporting services and xml data (31 July 2008)

Yes I was facing the same problem too.
Just in the query section give this simple query.
<Query>
<ElementPath>root/directory/file</ElementPath>
</Query>

Inside the query give the element path which you want to query.
This should solve your problems



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
6.640625E-02