Crystal Reports and connecting to multiple tables in a dataset - I'm Going Crazy!!

[Former Member]

This is my first application, first report and first everything. Wouldn't you know the report I am trying to produce is probably more difficult!! What is happening is that I have a form(screen) up in my application with the information displayed on it from a recrod in a table that I want to put on a report to be view and/or printed and eventually down the road I want to incorporate a signature. One step at a time though, here is what I have accomplished. I have created the report, I have gotten it to display in the viewer but it will not push the data from the table that I want displayed. It only displays the text that I have typed on the form. This is a Visual Basic application created in Visual Studio 2005 using a SQL database. If you need more information then just ask and I will try to fumble through and tell you what I know. (Oh and to top it off............I am also trying to get information to display from other tables also (codes connected to descriptions etc.))

Any help would be really appreciated as I have went through tutorials, read white papers, tech notes and anything else I can find but I just can't get it to work!!

Thanks!

[Former Member · Accepted solution]

You do need to give more information. To better help, we would need to know the database, when you say SQL do you mean SQL Server, how you created the dataset, whether there are multiple tables in a single dataset or multiple datasets, etc.

The report appears to be running so the underlying issue as you know will likely be the dataset. You may want to confirm the dataset does in fact have data in it. Returning a simple count will let you know there are rows. If you used the components rather than code to create the objects you can also see the data returned in the fill process.

Once you know you have data in the dataset, you can check your reports connection to the dataset.

Just hang in there... the problem is probably a simple fix. I am sure others will follow on with more suggestions.

Regards,

John W.