SSRS - SubReport Dataset

Epicor ERP 10
1

I am modifying the packslip and added “OrderMsc” table to the RDD to pull in the misc charge from sales order into the packslip since some of our customers require it. I want to include this in the subreport “MiscCharges”. So I went to the SSRS for the MiscCharges.rdl and add in a dataset called “OrderMisc”. It’s not pulling anything. Am I doing something wrong?

In the RDD, I went and add in “OrderMsc” and create the relationship.
image

From the subreport “MiscCharges”, I went and create the dataset.
image
image

There’s already a dataset “MiscCharges” in the SSRS subreport and that one worked. So am I missing something?

1 Like
2

I’ll often bypass updating the RDD, and the required tweaks to base report’s data set, and instead, make a standalone report to use as a sub-report.

The subreport is made from scratch, using a manually created dataset. Just create a few parameters (like Company, PackNum, etc…) to filter the sub’s dataset.

Then insert the sub into the base report, and link the sub’s parameters to the base’s data fields.

3 Likes
3

Thanks Calvin. If I create a subreport from scratch and using report style to upload, would it pick up the new SSRS subreport or would I have to go into SSRS server and upload directly there?

4

The only thing you would don Report Style is to have the style point to the RDL that the Sub will be inserted into.

For example, We have a PackSlip style 1001. it uses the standard RDD PackSlip, and a custom RDL reports/CustomReports/PackingSlip/PackSlip-PM

image

In the custom RDL PackSlip-PM, I inserted a subreport (which I had to make first) like so:

image
image.png850×241 14.7 KB

1 Like
5

Thank you. Your first screenshot was what I was missing from report style. After I added that, it did upload my custom RDL sub report.

Then I went to my packslip.rdl file and add in the sub report similar to your second screenshot. I tried uploading again, and got the following error. Any ideas?

image
image.png872×594 23.4 KB

6

The RDL need to be in the SQL server, not on a local machine.

I highlighted in, because it needs to reside in the DB. The report location field for Report Types of SQL Server Reporting, is not a path to a file location, but rather a “path” to the RDL definition stored in the DB.

Open IE and enter the address shown below (substituting your SQL server for the obfuscated part)

Here it is in text

http://<your SQL_SERVER_NAME>/Reports/Pages/Folder.aspx?ItemPath=%2freports%2fCustomReports&ViewMode=List

image
image.png828×294 15.7 KB

7

Thanks I figured out the issue. After I uploaded to SSRS Report Server, I went and browse to add in the sub report and that’s where it’s giving me the error trying to add in the sub report to my main report. Instead, I just typed in the name of the report and it’s working. Thanks for all the help.

image