Memo field extraction

[camjam26]

Hey all,

I'm currently using Crystal XI. I have an interesting thing going on in my company. In our customer reports, there are sometimes addendums that must be filled out as well. We created these addendums in XML and made visual forms to make entering the data easier. However, when we import the XML information to our in-house database, we stick all the data into a blob field (I won't go into all those details as to why). Crystal sees this as a memo field and what I was looking to possibly do is extract information from this field and recreate the visual form that was created for that data entry. Here is a small example from the XML:

<item_1>
<observation>An assessment had been conducted.</observation>
<verified>true</verified>
<notInPlace>false</notInPlace>
<notAvailable>false</notAvailable>
<itemScore20Full>20</itemScore20Full>
<itemScore20None>0</itemScore20None>
</item_1>
<item_2>
<observation>Training had been conducted.</observation>
<verified>true</verified>
<notInPlace>false</notInPlace>
<notAvailable>false</notAvailable>
<itemScore20Full>20</itemScore20Full>
<itemScore20None>0</itemScore20None>
</item_2>
<item_3>
<observation>Quality personnel were responsible for training.</observation>
<verified>true</verified>
<notInPlace>false</notInPlace>
<notAvailable>false</notAvailable>
<itemScore20Full>20</itemScore20Full>
<itemScore20None>0</itemScore20None>
</item_3>
<item_4>
<observation>The facility used city water.</observation>
<verified>true</verified>
<notInPlace>false</notInPlace>
<notAvailable>false</notAvailable>
<itemScore5Full>5</itemScore5Full>
<itemScore5None>0</itemScore5None>
</item_4

Other information to know here, only one of the itemScore values is going to show on the final report. If verified = true, then the full value is given. And the opposite of course should verified = false.

We have other methods of getting this data to print in Crystal, but if we were able to extra directly from this blob/memo field, it would make things easier.

Please let me know if further information is needed. I look forward to hearing back.

Thanks for everything,
Chris

 

[camjam26]

Oh...I am pulling from an ODBC (RDO) connection and it would be coming from {Addendums.AddendumData}

 

[camjam26]

I guess one more thing to try and help...the desired look afterwards is a table. So for item_'x', observation is put in the first column, either itemScore'x'Full or itemScore'x'None will be placed in the next column (depending on what is 'true' or 'false for the next three columns/fields), and verified, notInPlace, and notAvailable are the next three columns where a value of 'true' will just place an 'X' in its area.