Welcome, Guest
Username Password: Remember me

Deploying SSRS reports using Wix Installer.
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Deploying SSRS reports using Wix Installer.

Deploying SSRS reports using Wix Installer. 2 years, 3 months ago #1245

What is the best way to deploy SSRS reports using WiX 3.0 installer?

Re: Deploying SSRS reports using Wix Installer. 2 years, 3 months ago #1246

  • InstallerGeek
Put them in a folder and tell the user to upload them.

Sad, but true.

Re: Deploying SSRS reports using Wix Installer. 2 years, 3 months ago #1247

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.

Re: Deploying SSRS reports using Wix Installer. 2 years, 3 months ago #1248

  • InstallerGeek
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?

Re: Deploying SSRS reports using Wix Installer. 2 years, 3 months ago #1249

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.

Re: Deploying SSRS reports using Wix Installer. 2 years, 3 months ago #1250

  • InstallerGeek
There is a script based install process here that might help you:
neilsleightholm.blogspot.com/2008/08/rep...oader-for-sql-server
-reporting.html.
  • Page:
  • 1
Time to create page: 0.65 seconds

     
    
Home Forum