Hi all, I’m new to this forum. I have a question. How to display a ep.binding field on SSRS report builder?
Thank you in advance!
There are many steps along the way… first, things first, what report do you want to add this to?
1 Like
Job Pick List Report.
There are a tons of existing posts here on creating/editing SSRS reports. I would do some digging using search terms like “SSRS”, “Report Builder”, “Report Style”, “RDD”, etc.
The crux of the process is…
You’ll need to review the Report Data Definition linked to the Report Style you’re wanting to add it to (in this case JobPickl).
Is the Mtl table already included in the RDD? If so, you may just need to verify the field is not excluded.
If not, you’ll need to copy the RDD so you can edit it. Then, determine is the Mtl a linked table to any of the existing relationships? If so, you may be able to add ToWarehouse field to the RDD that way. If not, you’ll need to create a new relationship in the RDD to bring in the target column.
Once you get the custom RDD to include the target column, (if you haven’t already) you’ll need to copy the JobPickl report style and assign the NEW RDD to it.
Then you can download and edit the report .rdl file in report builder.
You’ll have to add the new column in (3) places… the Query, as a query field, and on the report form in the desired location. Upload, test, wash rinse repeat.
Again… broad strokes… there are a lot of steps in the process, so you’ll be best served by researching existing posts.
3 Likes
Welcome to the forum!
1 Like