I've tried a search on this topic but to no avail  , so I though I'd post it.

 

I'm new to Crystal Reports. I'm using VB 2005 and Crystal Reports XI.

I've been given the task to create a Winform to allow the user to create Ad Hoc reports from our table(s) in our Oracle DB. As I found out today, I need to utilize Runtime customization. I have a copy of Brian's book (CR & .NET programming) which I purchased over the weekend.

I'm working on ch 15, 16... at the moment and I'm stuck! I have used some code snippets from the book and I get this error: The report has no tables. I know the data is there because I can see it inth VB debugger but it will not work!  My code:

Dim da As OracleClient.OracleDataAdapter

Dim ds As New DataSet

Dim sql As String = "SELECT * FROM EUSER"

Dim tName As String = "EUSER"

Using cnn As OracleClient.OracleConnection = New OracleClient.OracleConnection(AdHocReportConnection)

cnn.Open()

da = New OracleClient.OracleDataAdapter(Sql, cnn)

da.Fill(ds) ', tName)

End Using

CreateXmlFile("USERTest", ds)

Dim myReport As New CrystalReport1

myReport.SetDataSource(ds)  'Error here...

CrystalReportViewer1.ReportSource = myReport

The code works fine up until the red line. What am I doing wrong??? 

 

Any help would be fantastic!

 

Thanks 

 

I have tried what you suggested but with no luck. I did have the 2nd to last line as myReport.SetDataSource(ds.Tables(0)) but changed it to 'ds'.

 

So, now I have changed it back.

However, I'm still not sure if understand the principle here. If I need to make myReport the data source for the report then all I need to do is this.

Here is my revised code, only the last four lines have changed:

 

Dim myReport As New CrystalReport1

CreateXmlFile(myReport.ToString, ds)

myReport.SetDataSource(ds.Tables(0))    'Error here

CrystalReportViewer1.ReportSource = myReport   'Report as data source

I'm stuck here. I still get the error. CrystalReport1 has been added to the Solution Explorer and used here. Is this what I'm doing wrong?

The data is there because I can see it in the debugger. Could you explain what I should do here please? The error occurs before I get the chance to set the report source!

 

Any more help would be appreciated.

 

 

 

Interesting....

I use xml files to populate my reports using this method (though not from Oracle) and have never encountered this.  When the report is designed is the datasource set to ADO.Net? 

 

Also to get the 'correct' schema, not just varchar(255) for every field, I need to create an xml file with the schema (and data makes the layout easier).  I write that out to a file, then use it as my datasource during the design phase of the report. Once the report previews/performs as I desire from the file, I just set the datasource to my dataset in code and the report displays.

 

Did you do something different?