I hope this is the correct forum but if not, please direct me somewhere else.
When trying to retrieve my report, it asks for login credentials like server name, database name, password, and username. Thing is the web application is on one server while the information is being pulled from a different server, which I'm quite sure is the problem. But I don't know how to get around it. I've seen the code to set up that information automatically. But the reports will not always be accessed from my computer. It's a web app so it'll be accessed from several. Any suggestions?
When trying to retrieve my report, it asks for login credentials like server name, database name, password, and username. Thing is the web application is on one server while the information is being pulled from a different server, which I'm quite sure is the problem. But I don't know how to get around it. I've seen the code to set up that information automatically. But the reports will not always be accessed from my computer. It's a web app so it'll be accessed from several. Any suggestions?