Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Including XML in a report Post Reply Post New Topic
Author Message
ChrisJohnson
Newbie
Newbie


Joined: 23 May 2012
Online Status: Offline
Posts: 1
Quote ChrisJohnson Replybullet Topic: Including XML in a report
    Posted: 23 May 2012 at 1:11am
Hi guys - I'm just wondering if this is possible...
 
I'm putting a report together which will query a SQL database - some of the data that I will need to get at is included in a XML script within a single field. Is it possible to take this data out of the field within a report (I would be querying the field on specific attributes names....).
 
Any advice would be appreciated....
 
Cheers.
 
Chris.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 23 May 2012 at 6:40am
since the xml is simple a string, if you know the tag you are looking for, you should be able to find it and it's ending tag and then just use somehting like MID() to get the part that you want.  Anything more complex is probably beyond CR (though I haven't tried)
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.017 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2025 Brian Bischof. All Rights Reserved.