Trying to modify ARForm in 10.2.300.6 version. At first I thought I copied the report wrong and it got corrupted, but now I cannot even preview (using TableGuid) of the untouched ARForm.
FWIW - When I preview in SSRS Builder, I get an error almost every time. I close out the error, then click the refresh icon (see below).
But to be fair, i’m not getting the error you see. Mine is more about the data not being found or current.
I started getting that if I didn’t set the archival period of the report to at least a day.
It seems like I used to be able to get a few hours out of the 0 days archival period, but not anymore.
2 Likes
you cant review with TABLE GUI without setting archive for at least a day
Not exactly true. You just run the risk of it being “cleaned” up while you’re using it.
Here’s a preview made with a GUID that was not archived.
and here’s the Sys Mon the GUID was copied from:
If I delete the report in Sys Mon, and then try to refresh in Report builder, I get:
Which is totally different than @tomdomurat is seeing.
It is NOT the GUID. I ran the report and made sure the Archive Period = Forever.
This issue is specific to the A/R Invoice as it uses some custom Epicor functions (that I believe are embedded in the CLSEpicor.dll).
The report renders for 1 second, then disappears and gives me the error message.
It is not a big deal – just that every time I need to make a change, I have to print preview the report within Epicor instead the Report Builder.
I was under the impression that once E10 assembled the data, a GUID was assigned and “temporary” tables were used to hold the data for SSRS to use to render the output.
Maybe E10 is making bad data in those GUID prefixed temp tables, that SSRS builder doesn’t know how to handle. But the SSRS renderer does.
If it’s really bugging you, look through the data stored in the GUID prefixed temp tables.
Does this happen with every ARForm dataset? Or just specific ones (like ones with lots of lines, really long line comments, comments with funky characters, etc… )?
2 Likes
that might be the case.but on the current 10.x system i use, unless the report is archived at least a day - it cannot be referenced through the GUID. possibly there is a system setting controlling the immediate removal of the temp SSRS tables. IDK. but needless to say, if you DO archive it - it SHOULD be there
1 Like
No Problems Here 10.1 and 10.2.300
@tomdomurat - You should try some of the new SSRS Designer functionality that was added to 10.2.300.
- On User Account Maintenance - Set yourself as an SSRS Designer (New Permission on Options Sheet)
- Run a Report and Select the Custom Style that references your copy of the SSRS RDL for that Report.
- Now that you are a Designer and you are working with a Custom SSRS Report, the Toolbar Icon for “Generate for Design” will be available - once you have valid report Parameters entered, click that.
- Once the Report finishes processing, go to the System Monitor, Reports Tab. Select the Report you just submitted and then from the Actions Menu, select Design SSRS Report.
This will bring up a small dialog that allows you to: Download the Report; Edit the Report (in Report Builder); Test run the Report (save it from Report Builder first) - the test run will be against the data selected when you hit the “Generate for Design” (That step can be run multiple times as you make refinements in Report Builder); Finalize and Upload your RDL.
Have a look at the Help for Design SSRS Reports for more information.
5 Likes
I will say that if your custom report style is the default report style the “Generate for Design” will be read only unless you toggle the report style to the standard report style and then back to your custom report style.
Not an intended behavior for the form I’m sure, but that’s the workaround.