Hello All,
I downloaded an SSRS report to a local machine, but when I try to run it after inputting the GUID, it gives me an error saying “unable to connect to data source.”
Here is a picture of the error after I try to test the connection to the data source. Does anyone know how I can authorize the user?
Please see attached.
Did you download the SSRS report from the same server you ran the report on for the GUID?
We have an app server and a separate server where our ssrs report server is installed. So to answer your question, we logged on to the epicor application which has its app pool configured on the app server and then we went to the BAQ report designer from within the epicor application and downloaded the SSRS report “.rdl” which lies on a server different from the app server. @asmar
Do you have a dedicated SSRS report server for each Epicor DB environment Pilot, Train, Test, and Prod?
One dedicated SSRS server for all the DB environment, but that one server has different SSRS DBs set up for each environment.
you have to connect your report build to the same SSRS report server before you can use the GUID parameter. The GUID tables will be in the target SSRS database.
@asmar I connect to the same ssrs report server that shows in my SSRS Report Server Manager, but yet it still does not work.
@asmar I guess I should ask, where can I find that report server connection string? Can I copy that from somewhere?
When we first open the report it asks us to connect to a report server and there is already one to choose from. We connect, successfully, but then when we try to run the report it gives the error I posted.
Your report data source must match the server you run the report on.
You will need to change the connection string:
Data Source=DB-Server-NAME;Initial Catalog=EpicorTest10SSRS;Min Pool Size=100;Max Pool Size=2000;MultipleActiveResultSets=True
Note, the report data source (SQL-Server database) and report SSRS server are two separate things.
@asmar let me confirm those details. The reports all run fine when printed from Epicor. It is just when I run them in report builder using a GUID that they don’t work and it gives the user that is trying to run it and the error I posted above.
Let me confirm all of the details you posted and get back to you. Thanks so much for your help and feedback.
We found that in 10.1.600, epicor made a change to delete records in the reporting db which is a great improvement. Due to this, we find that when we need to rerun a guid, we need to change the parameter when running the report (located in same general vacininty as the report style)
@T11 Do you know how to run a report in 10.2? I tried standard way where you run a standard report and take its GUID upon completion. But seems that is no longer possible.
Before running the report from within the Epicor client set the archive period to Day and then you can run the report using the GUID within Report Builder/the Reporting Service instance.
