Best practice for adding a custom sub report to an SSRS report when on the cloud?

Kinetic ERP
1

My goal is to add a shipment count to the sales order pick list by adding a sub report that displays a count on distinct ShipDtl Order Numbers. We are on the cloud. Here is what I’ve done:

  1. Modified the RDD to include the ShipDtl table
  2. Spun off a copy of the SOPick report, then deleted everything except the Data Source so I have something to build my subreport from (is there a better way to point to the cloud data source on a from-scratch sub report?)
  3. Created a data set for the subreport that looks like this:
    =“SELECT T2.OrderNum
    FROM OrderHed_” + Parameters!TableGuid.Value + " T1
    LEFT OUTER JOIN ShipDtl_" + Parameters!TableGuid.Value + " T2
    ON T1.Company = T2.Company AND T1.OrderNum = T2.OrderNum"
  4. Added a parameter to the subreport data set for OrderNum.
  5. Added a parameter to the subreport for OrderNum.
  6. Added this as a subreport to the main report, using just the report name (not the full file path) and OrderNum as the subreport parameter.
  7. Uploaded my modified report and it says the reports/subreports loaded successfully.

The report runs, but says “Error: Subreport could not be shown.”

I then tried running my subreport as the main report for SOPick and get an error that the report cannot be found.

Can anyone tell me where I’m going wrong? I have yet to be successful adding a subreport while on the cloud. Thanks!

1 Like
2

Create TableGuid parameter also in sub report and pass same from main report.

1 Like