Good Morning!


I created a Report using XSD but I'm having problems when I fill it with XML using dataset.

XSD Example Defination Table ICMS40

TABLE ICMS40 has the follow definations:
   <orig>
   <CST>
   <vICMS>

I'v in crystal reports, one formule that uses the field vICMS.

The problem is that <vICMS> is a optional tag, so... some XML's that miss it fail when I try open the reports.

I really don't understand, why I thought XSD should be like a table and if XML's haven't <vICMS>, it should apear
NULL in field vICMS. Otherwise it fail, because vICMS dissapear in run-time in report, occoring the error "field does't exist".


The code to fill dataset:

Dim dsDados As New DataSet
dsDados.ReadXml('c:\File.XML')
...
v_reportdocument.SetDataSource(dsDados)


The formule in Crystal Reports:

if not isNull({ICMS40.vICMS}) then '' Not working.
{ICMS40.vICMS}

Tks a lot!
ATt,
Daniel Todero
Brazil

Thanks for replying, you really understood my problem and I agree with u.

But, I don't know how to create a dsDados with the whole structure instead dataset from a XMLs.

I was thinking if there are a way to create a dataset from XSD. Do u know some way to create a dataset from XSD ?

Even I create a new structure with all fields, how to fill it with a XML and pass it to crystal reports.

I don't know if there are a way to do this, for this reason I'm asking help to understant that problem.

Thanks a lot.