Deploying SSRS reports using Wix Installer.

created the topic: Deploying SSRS reports using Wix Installer.
What is the best way to deploy SSRS reports using WiX 3.0 installer?

InstallerGeek replied the topic: Re: Deploying SSRS reports using Wix Installer.
Put them in a folder and tell the user to upload them.

Sad, but true.

replied the topic: Re: Deploying SSRS reports using Wix Installer.
A couple years ago I wrote a C#/DTF CA and some custom tables in WiX to call into the SSRS webservice to create the directories, datasources and reports associating the reports to the datasource.

It was pretty primitive ( SSRS doesn’t support transacted installs and since the webservice could be on a different machine you might not want to use no impersonation ) but it worked well. The next step was to refactor to a WiX extension but I changed jobs and never got around to it.

So it can be done without requiring manual steps or going out of process to an EXE and scripts.

InstallerGeek replied the topic: Re: Deploying SSRS reports using Wix Installer.
Could you please share some more information about this implementation. This seem the best so far.

The rdl files would be embedded within MSI package, how would those be extracted by the c# CA?

replied the topic: Re: Deploying SSRS reports using Wix Installer.
At the time, because SSRS doesn’t support transact and the webservice being on a different machine makes deferred no impersonation pointless, I was running the CA in immeadiate execution. Because of this I had access to the Binary table to extract the files.

However you could also use the File table to install the files somewhere and then use a immeadiate/commit custom action pair to marshal over the location of the installed files and use them that way.

If you want, I can send you what I have. It’s not perfectly elegant, just a working prototype that seems to have survived quite nicely after my departure.

InstallerGeek replied the topic: Re: Deploying SSRS reports using Wix Installer.
There is a script based install process here that might help you:
neilsleightholm.blogspot.com/2008/08/rep…oader-for-sql-server
-reporting.html.

Rajesh Kumar

I’m Rajesh Kumar, a DevOps, SRE, DevSecOps, Cloud, and Platform Engineering expert passionate about sharing practical knowledge, real-world experiences, and industry best practices. I have worked at Cotocus and regularly write about technology, travel, investing, health, product reviews, and digital marketing through my various platforms.

I publish technical articles at DevOps School, travel stories at Holiday Landmark, stock market insights at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at TrueReviewNow, and SEO and digital marketing strategies at Wizbrand.