Adding new table from RDD to report builder

Epicor ERP 10
1

Hi,

Is there any better way to kick off the weekend than ending Friday with Satan’s favorite software suite?! I say not, so hello again SSRS!

I have a new table added to a custom RDD, but I have no idea how to make it available in report builder.

Do I need to figure out how to create a new dataset for the new table, or do I need to add the new table to the existing dataset somehow?

Thanks.

#BringBackCrystal

2

  1. Edit the query expression of the main dataset in the RDL. Add the fields in the SELECT clause, and the tables in the FROM clause.

  2. Add.the fields to the dataset. Make sure to use Query field, and not Calc field.

1 Like
3

To add a little bit to what Calvin already listed…

After adding the table/fields to the RDD, I usually preview the report with an archive period of at least one day and copy the guid from the system monitor for use in report builder “preview”.

Then if my fields are not listed in the report builder dataset, I’ll explore the query expression, manually adding references to the table(s) e.g. T5, T6…
(which you might find “interesting” the first couple times)
after that adding entries to the fields sheet should be pretty straightforward

If you search the site you should find a couple posts with better details.
But for now… here are a couple basic screenshots from the So Ack

image
image738×528 142 KB

image

3 Likes
4

Thanks gents.

5

This one helped me out in similar issue…thanks a lot