crystal reports runtime xml datasource

[grimmersnee]

Hi,

 

I have a problem.

I have used the readxml method to read the contents of an xml file into a dataset using vb.net and I now want to pass this datasource into a crystal report. Upon creating the crystal report it asks from which datasource I want to base the design, do I point the datasource to a schema.xsd file? I would think that I would and then by passing the xml datasource at runtime it would populate the report. But this is not working. Does anyone have some understanding of this and can critic my code, this would be much appreciated, as I am fairly to new to .net.

 

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim crReportDocument As New CrystalReport4()

Dim dsXMLDataset As New DataSet()

Dim myTable As DataTable

Dim myRow As DataRow

Dim myColumn As DataColumn

Dim strFilePath As String

 

strFilePath = "c:\myData.xml"

dsXMLDataset.ReadXmlSchema(strFilePath)

crReportDocument.Database.Tables(0).SetDataSource (dsXMLDataset)

CrystalReportViewer1.ReportSource = crReportDocument

End Sub

 

Private Sub CrystalReportViewer1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CrystalReportViewer1.Load

 

End Sub

End Class

[Bucky]

The XML Schema (.xsd) is just an outline for an XML file, telling

how nodes and attributes should be applied. The XSD file does

not actually hold any data. The XML file that uses this schema

is what contains the data.

 

Instead of using the ReadXmlSchema() method, try the ReadXml()

method.

[grimmersnee]

Thanks for the reply, sorryI accidentlt posted the wrong code, it should of contained xmlread instead, I was jus' playing around with different ideas before I posted. Has anyone used a runtime xml datasource for crystal?????

[zzdv]

I trying to do the same and all works fine. But when i deploy the solution the report in not Shown.

 

Any Idea