How get single row from xml file

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

How get single row from xml file

Author

Topic

kallu
Starting Member

6 Posts

Posted - 2007-11-20 : 05:24:03

hi,
I am to SSRS.I using following xml file .
<Sales>
<Region value = “West”>
<Name>Vinod Krishnan</Name>
<Detail>
<Country name = “USA” amount = “12345678.90” />
<Country name = “Canada” amount = “898545.03” />
</Detail>
</Region>
<Region value = “East”>
<Name>Kylan Mylappillii</Name>
<Detail>
<Country name = “India” amount = “333348.00” />
<Country name = “China” amount = “678912.34” />
<Country name = “Indonesia” amount = “100000.00” />
</Detail>
</Region>
</Sales>

I wrote query in quer tab
as
<Query>
<ElementPath>
Sales /Region /Detail/Country
</ElementPath>

it returns all data.
how to put "where " condition in above query.
</Query>

jhermiz

3564 Posts

Posted - 2007-11-21 : 16:30:32

Makes no sense

Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources