Asked • 05/19/19

Excel VBA Code to pull SSRS data as a dataset?

I can’t seem to find a solution for my problem no matter how much I Google. (Please excuse my verbosity in the following explanation) My process is that I have to go to the SSRS web page, run my report (with parameters), and finally export as an excel file. Once all that is done I can execute my couple thousand lines of VBA code to import the raw data I just downloaded and apply my business logic. Now I’m able to make My pretty charts and graphs. For lots of reasons I won’t enumerate here, I need to further automate this. What I would like to do is change my code so it will just pull the data directly into my Excel spreadsheet without having to have first saved it as a file. The Googling I have done so far suggests I would be pulling it into a dataset, then work with that dataset object to consume my data. Does anyone have VBA code that demonstrates how to connect to the SSRS server, call my specific report (with parameters) and, and return the results as ( I’m guessing as a dataset),and read that into my spreadsheet?

1 Expert Answer

By:

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.