Second time today I get to share this link!
Let’s talk about SSP (server-side printing) - Experts’ Corner - Epicor User Help Forum
So that is how it works. In your SSRS report, Kinetic is creating tables of the exported report data keeping the same table names but appending the GUID for that particular run. If you look at your SQL expression in your RDL, you will see things like “…FROM JobHead_” + Parameters!TableGuid.Value + "…
If your SQL is querying JobHead without the _GUID, it won’t find that table since the exported data is in another database altogether separate from your production/test/pilot data.
I’m only suggesting this because of the error message indicating JobHead and not a longer table name with the GUID at the end. Can you post the Data Set query expression?
