I am testing 10.2.200.14. I am testing some reports. I want to troubleshoot the report in report builder. I get the GUID parameter for the report to try it. However, when I check the reports database that is being used to temporarily store the report tables the ones with this parameter no longer exist. Do I have a security problem for writing the tables? Is there a change where the system deletes the tables immediately? Just trying to figure out my issue.
I have an additional SSRS issue being unable to put the report in design mode. Believe it to all be security related. Trying to use Windows Authentication.
I found my issue. New feature in the report preview. It is defaulted to 0 days. Therefore the tables are created and deleted immediately. Sorry to bug everyone with this post. Found my answer in the Epicor knowledge base.
Where did you find the reports database? Is this a separate database from everything else? What table is the report data stored in? I have gone through looking at various tables and databases but haven’t been able to find it.
Are you looking for the DB that holds the tables the end with the GUID, that are used for the report? Or the DB that holds the RDL “files”?
The former (xxxx_GUID tables) are in the DB specified in the EAC configuration, on the Reporting Services tab, the ReportDatabase Name field. mine is RDB
Expanding that DB in SSMS, you’ll see tables with famailiar names with GUID suffixes. These are the temp datasets that the RDD (or BAQ) generate for SSRS reporting.
