Crystal sub-reports problem using TTX file and data tables 
Author Message
 Crystal sub-reports problem using TTX file and data tables

Hi

I am having problems bringing my Crystal Reports over
to .NET.  Simple reports work fine, it is when I try to
use my reports with subreports I encounter some parameter
problem with the sub-report link.  The exact same report
works OK in VB6, so I guess my new .NET syntax is wrong
somewhere.

Any ideas??

The error message I get is:

"Error in file K\:Reports\ProductSummary.rpt:
Error in formula <Simplified Sub-Report Record Selection>
({ContractSummary_ttx.NPC} = {?Pm-ProductSummaryAll_ttx.NPC})
This field name is not known"

The code I am using is:

Dim crReport As ReportDocument
Dim crSubReport As ReportDocument

        crReport = New ReportDocument()
        crReport.Load("K:\Reports\ProductSummary.rpt")

        'set reports datasource
                crReport.SetDataSource(dsReport.Tables("PRODUCT"))

        'set subreport
        crSubReport = crReport.OpenSubreport("ContractLines.rpt")

      'set subreport datasource
                crSubReport.SetDataSource(dsReport.Tables("CONTRACT"))

        'send the report to the viewer
        crViewer.ReportSource = crReport



Mon, 20 Jun 2005 23:40:20 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Saving data with report (using ttx files)

2. Problem using file dsn as data source for Crystal Report

3. Crystal not saving sub report data with report

4. Summarising data from sub-reports in Crystal Reports Pro 5.0

5. vb5 Crystal Reports 6 and Subreports Can we conditionally call subreports from primary reports

6. Using Active Data files in Crystal Reports

7. Crystal Report using Visual Foxpro 5.0 Data Files

8. Problem in generating Crystal Report with temporary tables(#table) in SP

9. Crystal Report - Subreport looping thru mainreport data

10. Crystal Report - CHange TTX location in code

11. Using an existing crystal report, but programmatically redirecting where/how the report gets its data

12. Help: Set datasource with subreports using crystal reports

 

 
Powered by phpBB® Forum Software