the tables are in a separate DB than the ERP schema.
Typically the naming scheme is EpicorTest for the main tables, EpicorTestReports for the db containing the temp SSRS tables.
From what I can see there is no OrderRel_GUID on the our ERP102RPT database. There are however a lot of RptLabels and PO tables. Am I in the right
spot?
You are in the right spot. We want you to find the GUID for your tested report. When you run a report, a GUID gets generated to keep all of the associated data together in the tempdb. This gets cleared from the db usually pretty quickly, but you can force it to remain for longer by archiving it when you run the report.
You can find this GUID by looking in your System Monitor.
You can create a SQL query using the GUID for your test run like the below to look inside the tables you are trying to link inside your SSRS report. Run the below in SSMS
SELECT * FROM dbo.POHeader_["Insert your GUID here without brackets"]
If no records are returned, the problem exists in your RDD.
1 Like
So as a test I ran the regular report. I set the Archive period to one day and here is the File Name.
How exactly should I be looking for this file in the Rpt database? This is the unmodified report. One more question does the Rpt database only store live reports? I am working of our test environment.
By the way I really appreciate all the help!
1 Like
Their should be separate DBs for each environment. You should be able to run a query like I suggested above. If it says it doesn’t exist you either didn’t archive it or you are in the wrong DB.
In the file name column, copy the long guid value after "REPORT DATABASE: ". In SQL Server Management Studio, right click the Tables node listed and select filter. Then paste the value you copied into the first blank cell in the value column. Once you press OK you should see the tables related to that GUID
Thanks,
When I filtered it, the results came up. Without the filter they would not appear. @cfinley the POHeader table is not there but I have found out why. When I deleted the Order = Order on the join within the OrderHed dataset Expression, I forgot to delete it from the RDD OrderRel2POHeader relationship. When I deleted it from there the field showed up. Guys thanks for all the help!
1 Like
Woo! got there
1 Like