SSRS Report TableGuid disappears soon after generation

Epicor ERP 10
1

(So, its been awhile I needed to modify a core SSRS report heavily)

I want to open the RDL, paste the TableGuid from System Monitor and have the report preview with data.
I swear I have done this before, but obviously I am forgetting a step.

When I capture the TableGuid in the Filename field, it stay there for a 1 minute then disappears(??):

Reports_TableGuid
Reports_TableGuid.jpg767×523 26.5 KB

So, when I paste into the RDL to preview the report it says “invalid object name”.

RDL_TableGuid
RDL_TableGuid.jpg1053×589 83.1 KB

2

You need to set your archive period on your report printing to a week or a month or something. Epicor went a bit over-board when fixing a bug which used to let it hang around for a while… not they eat it almost immediately.

2 Likes
3

Thank you so much, that was it!

Do you know if you if there is a configuration setting to make “Archive Period: 0 Days” to something more useful so it does not need to be changed on every single run?

1 Like
4

One way would be to hard-code it on each Customization, i use the following in my tests for “Archive Period: Day”:

public void InitializeCustomCode()
{
	EpiDataView edvReportParam = ((EpiDataView)(this.oTrans.EpiDataViews["ReportParam"]));
	edvReportParam.dataView[edvReportParam.Row]["ArchiveCode"] = 1;
5

Here are two data directives which default the archive period to 7 days for everything system wide (if no archive period is selected) SysRptList and one in SysTaskParam

Disclaimer: Provided as an example use at your own risk, test it thoroughly (not in production), if it breaks your stuff don’t call me, you accept all responsibility if it does I cannot and will not help you fix it etc… etc… etc…

DefaultArchive.bpm (39.5 KB)

6

Cool, thanks so much (again). I am at the moment testing this report and such a PITA to keep having to change the Archive Period on each run.

IMO, Epicor should really make this a configurable option in Company Maintenance (Reporting). Or at least make the Default Value = 1 Day system-wide.

PrintOptions

7

Add it to the Features Request Category as a post. Epicor watches!

1 Like