I am trying to create a report in CR2008. The database is SQL Server 2005. The report is pulling data from one table that has say 10 columns and some columns are defined as xml datatype. All the xml columns are appearing as a memo fields on the report.
I want to be able to do a record selection on one xml column values. This is a sample xml column value.
<?xml version="1.0" encoding="utf-8"?>
<status>
<New>"Y"</New>
<Existing>"N"</Existing>
<Pass>"N"</Pass>
</status>
I want a record selection for "Y". Can this be done and how?
I want to be able to do a record selection on one xml column values. This is a sample xml column value.
<?xml version="1.0" encoding="utf-8"?>
<status>
<New>"Y"</New>
<Existing>"N"</Existing>
<Pass>"N"</Pass>
</status>
I want a record selection for "Y". Can this be done and how?