Would like to add the PartNum to the labor edit report. The dataset in the report does not include this field (dsLaborDtl). Is it easy to add the JobHead table and link to the LaborDtl by JobNum to pull in the PartNum? Not sure where to start as I’m new to SSRS. Anyone know the steps to add this easily?
There is documentation on epicweb on how to modify an ssrs report. Check there first
Copy the standard LaborEdit RDD to a new one so you can edit it.
Add the JobHead Table
Add a Report Relationship linking JobHead to LaborDtl
Check the “Exclusions” on the JobHead table to make sure the fields you want are there.
Setup a Report Style using that RDD and run it(generate data) to populate the SSRS data tables.
Modify your SSRS report by updating the query to include the new table/fields and add them to the report.
1 Like
Sorry but how do I add a report relationship to link the two tables?
I went through epicweb - How to modify a system report and added the table and field to the report - however, when I try to upload or save the new report - it gives an error about grouping with EMPBASIC_jcdept - It looks like there is a subreport but the only change I made was adding the table, relationship and field to the report - so I’m not sure why it would lose or break any data from subreport or mess with the grouping at all - I haven’t removed any tables/links, etc. Any ideas why I’m getting the errors or any special requirements due to subreport?