I’m trying to modify the Labor Edit Report within e10. I found a video on how to add parameters in Report Builder. However, when I follow the instructions in the video no parameters get populated. Is this because it is a canned report or is there something I am missing?

Epicor does not natively allow additional parameters in the way you are using it. What is the end goal?

@Jason_Woods , The end goal is to be able to parameters and filter by them not just in this report but in future ones I run into. I’m hoping to find a dynamic way of filtering. Using the labor report as an example, say an employee is moved under a new supervisor. I would want the old supervisors sch…

You may be able to customize the Labor Edit Report screen to be able to add that value as a filter. Then you can use that value in the SSRS report.

@Jason_Woods , Do you have documentation on how to do this or a video I could follow?

[image] SSRS - SubReport Dataset ERP 10 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 wen…

@ckrusen Could you walk me through how to set up a report from scratch for a cloud based system? After seeing what was done in the above post I believe that would be extremely helpful!

First off, our system is not cloud based. So my instructions might not be exactly the same for you. What type of report? A modified version of an Epicor Supplied report, just the layout. No new fields needed, just moving some things around, or showing fields that are currently supplied, but no…

@ckrusen I want to create a new SSRS report from scratch with only SupervisorID from the EmpBasic table on it and use that to create a parameter to filter another report.

Will the “other report” be a sub-report (.i.e embedded in you EmpBasic SSRS)? And is this other report an Epicor supplied report? Or another report you’ll make from scratch?

@ckrusen the other report will have the one we are building embedded in it, and it is an Epicor supplied report

SSRS Report Modification

Epicor ERP 10

TobyLai (Toby Lai) March 10, 2020, 11:29pm 6

I think there are some instructions there. If you want the report change based on database, check out @ckrusen 's comment in that topic.

Topic		Replies	Views
Custom SSRS report with Custom SSRS SubReport Epicor ERP 10 ssrs	18	7233	November 28, 2022
SSRS - SubReport Dataset Epicor ERP 10 ssrs	6	4032	December 6, 2018
Standard SSRS Sub Report - Modify Epicor ERP 10 ssrs , reports	3	1478	May 22, 2020
Add Supervisor Filter to SSRS Labor Edit Report Epicor ERP 10 customization	18	3735	March 10, 2020
Beginner trying to modify ssrs on cloud epicor 10 Epicor ERP 10 ssrs	18	5398	July 7, 2020

SSRS Report Modification

Related topics