Issues with Custom SSRS reports

ERP 10
,
1

Hi Folks,

We are running E10 10.2.600 and have a custom PackSlip report that was originally converted for us by Epicor’s India Tech Centre when we migrated. This has had the odd tweak since then but runs quite happily.

In order to comply with recent changes to export documentation, we now need to insert the HS code (Commodity Code) and Country of Origin onto each line of our Packing Slip. I have followed all the tutorials and help articles that I can find, duplicating the RDD, creating a new report style, adding a relationship to pull in these codes from the Part table but whatever I do, when I edit the form and attempt to add the fields, no data appears. I have added an additional join into the query and and added query fields but without success.

I have no idea where I am going wrong. We undertook the SSRS Reporting course when preparing for migration so that we could undertake just this sort of task but everything in my notes from then is really basic and does not seem to cover the scenario I find myself facing.

If anyone could point out any gotchas that I have unwittingly stumbled across, your collective wisdom would be greatly appreciated!

Thanks, Steve.

2

On your data definition, have you made sure your field is NOT excluded?
image

3

Hi Brian,
Thanks for the swift response.
Yes, all the fields I require are not excluded.

Steve.

4

Show us the joins and declarations in your rdl file (viewing in Notepad ++).

5

On your RDD, are your relation types Output?
image

6

in SSRS in the Form, when you edit the query to add the joins, make sure you add the field above in the query. As well as adding the new joins down below (red arrow)
image
AND add the query field here(pic below), before you can use it to display data on the form.
image

7

Hi Folks,
Thank you for all of your input. I had completed all of the steps referred to by both Brian & Marta. The problem was that I had done so on the wrong RDD!

I had made a copy of the PackSlip RDD where the Epicor folk had created a customer specific version. As this was already a custom version, I was able to modify this to bring back the fields I required.

This will teach me not to raise pleas for help when I have not done the basics properly!

Thanks again for your time.

Steve.