AR Form RDD

Epicor ERP 10
1

I saw an other post someone had issues with the upgrading of the ARFrom RDD. My issue is with the AR Form RDD too but i am starting from scratch just having issues. The biggest issue I am having is the columns that are on the RDD don’t appear on my SSRS report. The odd part is these are not columns I have added these were already there from Epicor standard RDD. As you can see from the screen shot this field is not excluded on the default RDD but I don’t see it in my SSRS dataset.

image
image.png1009×687 37.2 KB

I have also tried to add the field in the dataset but it turns no data.

image
image.png689×732 22.3 KB

1 Like
2

When you added the column to the report, make sure you select add query field.

Capture

Is the field added to your query as well?

Capture
Capture.JPG695×687 90.3 KB

2 Likes
3

No I do not see Order Num from the Invoice Head table. The only order num is from FSAService; and I have no idea what that table is.

4

I did do that but still doesn’t work.

5

Is the field in the guid tables that are created by ssrs.

6

you mean the dataset?? this area highlighed in yellow

image
image.png371×622 29.1 KB

7

I mean in the database where you are pulling in the fields for the report. Are you seeing the columns there?

8

Yes, looked in SQL and the field is in the table and has data.

image
image.png745×326 12.2 KB

9

That’s a query of the InvcHead. @knash is referring to the temp table in the Report DB

10

I don’t know what or where that is. Unless I am calling it the wrong name.

11

Epicor creates a temp table in your SSRS database. That is where the guid for your report comes into play.

You should see the database in your management studio.

1 Like
12

Oh, I think found what you were talking about. If it is the field is there.

13

our comments passed each other. yes I think i found that and if I did. I see the field

14

Which table is it in?

Can you post your query for the datasource as well.

That will reduce the back and forth.

15

When you print an invoice the RDD creates temporary tables with the reports GUID as a suffix of the table name.

For example. I just previewed an invoice and the Sys Monitor shows:

image
image.png958×100 9.8 KB

the 6f4a0f7838aa4bfa8dd3a8ec6d5a3fba is the GUID that is added to the RDD’s table names.

Not sure exactly where those temp tables are stored.

16

I gotcha

17

Ok I found it. Yes that column is in there.

18

@knash and @ckrusen

Thanks for some leading. I got it and it is working.