Unhid column from report data definition, but doesn't show up in the report database (tablename_tableguid) temp table

Epicor ERP 10
1

My end goal is to add a gl number to the poform report (specifically the porel subreport).

I’ve edited the report data definition (unhiding the porelnum column and added a link to the tranglc table), set a new report style to use it, yet after running the report and grabbing the TableGuid, I’m unable to find the porelcolumn nor the tranglc table that I linked through querying the database directly (in the ssrs database with the tablename_TableGuid tables).

I’ve also tried sync dataset hoping that’ll do it, but nothing seems to be working.

2

Make sure you select an archive period when you print the report to obtain your guid Otherwise it drops the table pretty much straight away. In the system monitor, the Archive column will be true if it has been ‘kept’

Phil.

3

That’s not it because other tables and columns show up.

4

Have you added the new field to the SQL in the report?

5

Yes. The report fails because the datasource can’t select the data from the tables. I opened up the reporting database in sql server management studio and the table/column doesn’t exist.

6

Sigh. I finally figured out the problem. Report style got changed back to the vanilla report definition.