View/Opinions appreciated on generating a report?

[bnbp]

As of now , we are doing great guns based on our reporting stuff, but trying to really figure out how the below issue can be solved:
Scenario is we have the information for a person in .xml format in a folder and obviously the person's basic info like Name,Age,sex... in a table.
Now i could able to pull up the table but don't have the idea how reporting services read's the .xml and map to the exact person.

 

[xlbo]

If you have matching ID numbers in both the xml and database there is not reason that SQL Server cannot shred the xml to get it in a tabular format and join to the database...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question