I posted a while back about the need to have some advanced reports for my client and we went down the route of creating an oData Connection to Excel. (see attached)
In DEV it works no problems
In our other two environments we will get errors about - We couldn't connect to the data source. Please check your logon information or the tables aren't visible to select.
Each environment has their own files / own data sources and are set to authenticate with the user logged in. No security - it's just a SmartObject populating a SQL Stored Procedure with data.
We've had to rebuild this report when the user needs it but obviously this isn't a good route.
Any thoughts? Suggestions?