Crystal Reports 2008 using XML data set

building reports crystal reports
1

Hello Members,
I have to develop a report and show the data that is stored in xml in a column in the physical table.It comes down to creating a dataset out of a query. In Crystal reports, i have developed a report using xml file as dataset and it works great. How can i develop a report if that information is stored in a column in physical table. Any inputs are greatly appreciated.

Thanks in advance!!!

alladiz (BOB member since 2007-06-25)

2

2 ways:

  1. You could bring that table into your Universe, and then pull that object (based on that column) into your report.
  2. Use the database as your source and bring that table.column into your report.
    Hope this helps!

Thanks,
Sowmya.

sowmyabatchu (BOB member since 2009-10-14)

3

Sowmya-
Thanks for taking your time to look into this. Pulling the data is not a problem. I have to display the data and format based on th xml code. The data is stored in xml format in the column. I have tired html text interpretation but that did not work.

For example this is a sample xml code:

<?xml version="1.0" standalone="yes" ?>
  • 1 Product1 10
  • 2 Product2 15
  • 3 Product3 350
  • 4 Product4 75
  • 5 Product5 100
  • 6 Product6 600

This how the data is stored in the column. Out of this you have to read the data.

data should be displayed in the report as :

product_id product_name product_price
1 Product1 10
2 Product2 15
3 Product3 350
4 Product4 75
5 Product5 100
6 Product6 600

Thanks.

alladiz (BOB member since 2007-06-25)