Report
I’m trying to add a Tracking Number column from ShipHead.TrackingNumber to the ARForm by introducing a subreport into the ARForm Report, SSRS. I’ve setup the ShipHead to link with InvcDtl on RDD (Report Data Definition). In SQL terms it would be:
LEFT JOIN (This would be OUTPUT in RDD)
ShipHead ON InvcDtl.Company = ShipHead.Company AND InvcDtl.PackNum = ShipHead.PackNum AND InvcDtl,CustNum = ShipHead.CustNum
No matter what I’ve tried I get the error message from the Log:
The Log processing!ReportServer_0-5!63a0!02/25/2017-18:14:35:: e ERROR: An error has occurred while processing a sub-report. Details: Data retrieval failed for the subreport, ‘TrackingNumber’, located at: /TESTDB/reports/CustomReports/Cust_ARForm/ARForm_Shipping. Please check the log files for more information. Stack trace:
at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.FinalizeErrorMessageAndThrow()
at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.RetrieveSubreport()
This tells me the problem resides in the RDD, but I don’t see the issue.
Below are some pics that show my settings and SSRS: Table InvcDtl
It’s a subreport, not an added table, if that’s what you mean. The main ARForm’s expression in the Dataset doesn’t contain the field from the Subreport. It’s linked from the Subreport to the ARForm report by the Parameters.
If you mean does the Expression have the linked fields from InvcDtl, yes it does. T2.CustNum AS InvcDtl_CustNum, T2.Company AS InvcDtl_Company, T2.Packnum. They’re shown in the last image I posted.
Perhaps I’m misunderstanding? I understood that your desire was to obtain ShipHead.TrackingNumber via a sub report. If so; after you modified the rdd; did you add a link between ShipHead and InvcDtl to the sub report sql in the expression of the respective dataset? And if so; did you add yShipHead.TrackingNumber to the fields list?
