Crystal Reports Forum : Data Connectivity

subreport error

Fri, 09 Oct 2020 15:20:03 GMT

Thanks
Its working now.
I followed your sugestion and the subreports are working.

subreport error

Mon, 05 Oct 2020 14:48:17 GMT

Thanks for your reply.
No the main report has no datasource.
I didn't assign any datasourse because it has no fields that required data.
I will try and add a datasourse to the main report and see if it works,.

Edited by JRCharlie - 05 Oct 2020 at 3:48pm

subreport error

Mon, 05 Oct 2020 11:44:19 GMT

I am not sure. Could it be that the main report has no datasource? Only the subreport is being set.

I am guessing/assuming that the schema for dt matches what the subreport is expecting. Crystal is sensitive about that.

Is the page header the same for all pages? Otherwise, I would expect some linking between the main report and the subreport, and that could be part of the issue.

HTH

subreport error

Fri, 02 Oct 2020 15:53:30 GMT

Hello
Ihave created a report that contains 4 subreports in the page header.
when I try to run the report i received the error table could not be found. I have tried to use one of the subreports as the main report with the same data it works.
This is how i'm populating the subreport.

   Private Sub LoadReport()
        Dim ds As New DS_report
        Dim dt As DataTable = dt_Mach_parts.Copy
        dt.TableName = "Mac_break"
        ds.Tables.Add(dt)

        Dim reprtdoc As New ProductionRprt
        reprtdoc.Subreports("CabParts.rpt").SetDataSource(dt)

        With CR_Viewr
            .ReportSource = reprtdoc
            .Refresh()
        End With
           End Sub

Edited by JRCharlie - 02 Oct 2020 at 3:54pm

Crystal Report with Multiple datatables (not table

Thu, 20 Sep 2018 05:31:35 GMT

Crystal cannot use a stored procedure that returns multiple tables/cursors in its result.

-Dell

Crystal Report with Multiple datatables (not table

Fri, 25 Aug 2017 04:30:24 GMT

Normally one does this through a sub-report. I have not ever attempted it otherwise.

Crystal Report with Multiple datatables (not table

Thu, 24 Aug 2017 09:38:02 GMT

One stored procedure create a dataset in which there are 10 datatables.

Since the stored procedure can't modify so that I have to use dataset to bind Crystal Report.

I knew how to bind dataset with single datatable to CR.

But, how to bind multiple datatable to CR?

Decimal Values being Dropped

Tue, 25 Jul 2017 03:15:14 GMT

Thanks again for the assist.
I also find it easier to build a SQL Query and testing it on the iSeries System - Then doing a copy/Paste into Crystal.

Decimal Values being Dropped

Wed, 19 Jul 2017 12:11:12 GMT

Okay, definitely looks like a database connection issue. I do not know if current ODBC driver for IBM DB2 works well with Crystal or not. We prefer to a command for most of our reports. Puts most of the processing on the server and we can be more creative in bringing in data.

Decimal Values being Dropped

Wed, 19 Jul 2017 04:18:19 GMT

Thanks for the information. I did try several different variations of settings within VIEWS and the ODBC Connection with no luck before post my Issue on the FORUM.

I think I may have resolved my Issue by creating a new type of connection within Crystal
Under OLEDB (ADO) - Select - IBM DB2 for i IBMDASQL OLE DB Provider. There is a downside though - There is no presentation of Files to Choose from. A SQL Query needs to be created in order to see the selection of fields.