I want to modify a report. But Design SSRS Report is disable?
Is there any reason or alternative to this?
From Report Style Maintenance.
1 Like
Thank you Chadd!
1 Like
Ensure the report style is not a standard report style, is of type SSRS and that your user account has SSRS report designer ticked.
Hi Chadd, is it possible to add new field from Customer Table in the POHeader in SSRS report using microsoft report builder?
Yes but you’d need to make a link between supplier and customer. Add the field to the RDD then add in SSRS.
Thank, I don’t know how to link this since I’m only using Report Builder and no connection to Report Server 
Yes it’s there
I can’t seem add new table or fields. I wanted to add just two fields from the table Customer
I recently add new two fields on the Customer table it was a boolean type. When selecting the PO i wanted to check weather the fields is true then display a text
Sam, I would normally be willing to detail this out on this thread, but I feel like there are several that go over it on here. I can spend about 5 minutes looking for you but after that I need to get back to making some reports myself, so please don’t feel like I neglected you
1 Like
@salderete here are a bunch of links I look at, I didn’t look at them, but I searched “how to add a field to SSRS report” in the search bar and these are some that looked ripe:
SSRS - Add Field to Report - Epicor ERP 10 - Epicor User Help Forum
SSRS Add New Field to Report - Epicor ERP 10 - Epicor User Help Forum
Add a field to SSRS RDL report dataset - Epicor ERP 10 - Epicor User Help Forum
SSRS Custom Report Help - Kinetic ERP - Epicor User Help Forum
ARForm modification - Epicor ERP 10 - Epicor User Help Forum
Trying to modify RDD for PackSlip report - SSRS - Epicor ERP 10 - Epicor User Help Forum
4 Likes
POs are directly related to a supplier. You can lookup a customer for the ship to but there isn’t a link to customer. You’d need something to link to the customer from the supplier. Then you could add customer to the RDD.
1 Like
Where do i link the customer to the supplier? is it on Dataset Relationship?
No, you’d need a field on POHeader to link to the customer. There isn’t a relationship right now. You need a relationship between them before you can use it in your report.
What fields are you trying to pull from customer for a PO? POs are issued to a supplier (erp.Vendor).
I was just following the report that was been made by the old user.
I was wondering how did he add the Customer_NDA_c.
I had an impression that it was a Customer field since it exist on that table, and it was under the POHeader Dataset
Doesn’t look like it based on the RDD you posted. And that field isn’t used in that formula you have there.
Yeah that makes me think also it looks like it was not use but when running the report it works.