Glom
asked on
Problem using ADO .NET DataSet with Crystal Reports
Hi there,
I try to generate a simple report with Crystal Reports for .NET.
I've already done some reports from xml files or from databases, but my problem is now to use an ADO.NET DataSet as a data source.
I have my .xsd file to describe the structure and I fill the dataset this way :
- Dim DSLicences As New Odyssee.AcroDroits.DataSet Licences
- DSLicences.LicenceWeb.AddL icenceWebR ow(11, 13, #12/13/2004#, 11, 13)
Then I set the datasource in the report :
- Dim MyReport As New LicencesReport
- MyReport.SetDataSource(DSL icences)
And finally give it to the viewer that is on my Form :
- CRViewer.ReportSource = MyReport
- CRViewer.Refresh()
I always get an error message when I put my data fields on my report (.rpt) file : "Error while loading database informations"...
Please Help !!
I try to generate a simple report with Crystal Reports for .NET.
I've already done some reports from xml files or from databases, but my problem is now to use an ADO.NET DataSet as a data source.
I have my .xsd file to describe the structure and I fill the dataset this way :
- Dim DSLicences As New Odyssee.AcroDroits.DataSet
- DSLicences.LicenceWeb.AddL
Then I set the datasource in the report :
- Dim MyReport As New LicencesReport
- MyReport.SetDataSource(DSL
And finally give it to the viewer that is on my Form :
- CRViewer.ReportSource = MyReport
- CRViewer.Refresh()
I always get an error message when I put my data fields on my report (.rpt) file : "Error while loading database informations"...
Please Help !!
ASKER
Yes, the DataSet is filled and I can see its content as needed or even write it to an xml.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Well thank you,
I was almost sure it was a programming problem, but I re-installed properly some of the dll's (including Crdb_ado.dll, which I think was of a different version or something else) and it worked !!!
You won 250 points Bob, thanks again !
I was almost sure it was a programming problem, but I re-installed properly some of the dll's (including Crdb_ado.dll, which I think was of a different version or something else) and it worked !!!
You won 250 points Bob, thanks again !
Bob