Skip to Content
author's profile photo Former Member
Former Member

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

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!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jan 21, 2008 at 02:39 PM

    In Crystal Reports you can connect to multiple datasources. In the report you can have multiple tables that come from different datasources. So it looks like you are ok to push the data from the form to the report but you also need to 'pull' data from tables in the database.

    Use the Report Connection wizard to connect to these new tables and drag the fields on to the report.

    Rob Horne
    Rob's blog - http://diamond.businessobjects.com/robhorne>

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.