I am trying to add Vendor_Name instead of Vendor_Id ,
How to do it?
You will need to create a new report style so that you can modify its contents. You then need to assign the field, Vendor_Name, to the Textbox and any other associated changes you want to make. The field, Vendor_Name, is already available in the dataset.
4 Likes
That’s correct the information is already available on the report. It is available via the Linked Tables in your RDD.
1 Like
Do i need to update this field?
Or different ?
I try to add in RptLabels Dataset Vendor_Name which is not working
The field is in the POHeader dataset. You will select the textbox, TxtVendID, in the report body and change the displayed Expression to be Vendor_Name. It appears that you are on the Label and not the actual field. If you want to change the label, I would probably just manually update it.
Working but i want to add Supplier Name as a label for that i have to add field in RptLabels Dataset?
And instead of sort by PO num i want to Sory it by Due date.
Are you able to preview the revised report? If so, what does it show? Have you uploaded the revised report to Epicor? Are you using the revised Style when running the report? Can you provide a screenshot of the revised report in Report Builder after you have saved it?
yes i preview revised report everything is working i am trying to edit labels instead of supplier id i want to update supplier name how to do it?
You can replace what is in the expression for the textbox, lblVendID, with either =“Vendor Name” or not use the = and just type in Vendor Name.
Try using =ucase(“Vendor Name”).
The textboxes actually appear twice in the report (didn’t look to see why) I updated both but it appears it is the bottom set that displays. Also, what I updated was the Expression for the Textbox where it appears you are looking at the Placeholder. To get to the Expression/Textbox Properties, I right click on the textbox when its handles are displayed and not from inside of the textbox.
1 Like