How to install SSRS deployment based on feature selected

[checkwa]

Hi,

I would like to install SSRS reports only if the selected feature is checked on my Advanced installer. Can you direct me on how to do that? Something like install condition.

Is this feature already available?

[Dan]

Hello,

For now, you cannot condition a SSRS deployment report. I have added this improvement on our TODO list and it will be available in the next version of Advanced Installer. Thank you for your suggestion.

However, you can condition the "AI_SsrsDeploy" action from the "InstallExecuteSequence" table in the Table Editor page.
Through its condition field you can condition the deployment of your reports. Unfortunately, you cannot condition the deployment of each deployment. Instead, you condition the deployment of all your deployments (if you have multiple deployments report).

If there is anything else I can help you with, please let me know.

Best regards,
Dan

[checkwa]

Thanks Dan will try your suggestion and will let you know.

[checkwa]

Hi Dan,

I tried your suggestion above but it seems the reports are not installed on the REPORTSERVER but based on the log (run and log) below no error encountered by the installer. how to troubleshoot further?

MSI (s) (64:9C) [15:57:16:434]: Skipping action: InstallODBC (condition is false)
MSI (s) (64:9C) [15:57:16:456]: Doing action: AI_SsrsDeploy
Action 15:57:16: AI_SsrsDeploy. Generating actions to deploy SSRS resources
Action start 15:57:16: AI_SsrsDeploy.
MSI (s) (64:5C) [15:57:16:528]: Invoking remote custom action. DLL: C:\windows\Installer\MSI2EEC.tmp, Entrypoint: OnSsrsDeploy
MSI (s) (64!A8) [15:57:17:146]: PROPERTY CHANGE: Adding AI_SsrsConfig property. Its value is 'ProductCode{17CB0C9B-42A8-489F-A0D8-323A65EB0EEC}AI_SSRS_DEPLOY_SCRIPTssrsDeployScript.rss0SCMv5http://mbm/ReportServer_SQL2012SCMV5_TestSCMV5_TestSCMV5_Test00Account Mapping Template with GL Code.rdl010Accounts Payable Report.rdl020Accrual Report.rdl030Accrual Report_MCK.rdl040Accrual Variance Report.rdl050Allergy Information.rdl060AP Transfer Report.rdl070AP Transfer Report_MCK.rdl080Approval Matrix Report.rdl090Approved Orders in Budget.rdl0100Approved Orders in Operating Budget.rdl0110Barcode.rdl0120Budget Report.rdl0130Closing Stock Detail Report.rdl0140Closing Stock Detail Report_echo.rdl0150Closing Stock Detail.rdl0160Closing Stock DetailM.rdl0170Closing Stock Summary.rdl0180Closing Stock SummaryM.rdl0190Closing Stock Variance .rdl0200Closing Stock Variance M.rdl0210Closing Stock Variance_bak0531 .rdl0220Closing Stock Variance_MCK.rdl0230Colour Sizing Stock.
MSI (s) (64!A8) [15:57:17:224]: Doing action: AI_SsrsConfig
Action 15:57:17: AI_SsrsConfig. Deploying SSRS resources
Action start 15:57:17: AI_SsrsConfig.
AI_SsrsConfig: SSRS Deployment: Deploying SSRS resources
Action ended 15:57:17: AI_SsrsConfig. Return value 1.
MSI (s) (64!A8) [15:57:17:501]: PROPERTY CHANGE: Deleting AI_SsrsConfig property. Its current value is 'ProductCode{17CB0C9B-42A8-489F-A0D8-323A65EB0EEC}AI_SSRS_DEPLOY_SCRIPTssrsDeployScript.rss0SCMv5http://mbm/ReportServer_SQL2012SCMV5_TestSCMV5_TestSCMV5_Test00Account Mapping Template with GL Code.rdl010Accounts Payable Report.rdl020Accrual Report.rdl030Accrual Report_MCK.rdl040Accrual Variance Report.rdl050Allergy Information.rdl060AP Transfer Report.rdl070AP Transfer Report_MCK.rdl080Approval Matrix Report.rdl090Approved Orders in Budget.rdl0100Approved Orders in Operating Budget.rdl0110Barcode.rdl0120Budget Report.rdl0130Closing Stock Detail Report.rdl0140Closing Stock Detail Report_echo.rdl0150Closing Stock Detail.rdl0160Closing Stock DetailM.rdl0170Closing Stock Summary.rdl0180Closing Stock SummaryM.rdl0190Closing Stock Variance .rdl0200Closing Stock Variance M.rdl0210Closing Stock Variance_bak0531 .rdl0220Closing Stock Variance_MCK.rdl0230Colour Siz
Action ended 15:57:17: AI_SsrsDeploy. Return value 1.
MSI (s) (64:9C) [15:57:17:894]: Doing action: AI_SqlInstall

[Dan]

Hello,

I'm not sure I fully understand your scenario. Can you please give us more details about your scenario, maybe exemplify?

Did you condition the AI_SsrsDeploy action from the InstallExecuteSequence table and your deployments are still deployed?
In order to have a better view about this, can you please send us the .AIP (project file) and a full verbose log of the installation process to support at advancedinstaller dot com so we can investigate it? If it contains confidential information you can send us a small test project which reproduce this behavior.

Best regards,
Dan

[checkwa]

Hi Dan,

What i aimed to do is to control the deployment of SSRS report on my installation, that's why i created a checkbox with property name CB_REPORT for that option. And then i followed your suggestion to modify AI_SsrsDeploy action from the InstallExecuteSequence table to add the condition. But whenever i run the installer and select the checkbox to deploy my SSRS report , the installer just proceed/finish as if everything was OK. but if i check the report server the reports is not there (was not deployed). So may main issue now is that SSRS reports were not deployed to the server and the installer didn't return any error message regarding this.

Another question, with regards to the folder name on the SSRS deployment, if the folder is not existing to the report server is this will be automatically created or it should be created on the report server before the deployment?

I attached the .aip and the verbose log for your reference.
thanks

[Dan]

Hi,

I'm not sure why you encountered this behavior.

Can you please tell us if the deployment was working as expected before conditioning the AI_SsrsDeploy action? Also, does it make any change if you use the Impersonate installing user option?
Also, please check your permissions on the server, maybe there are some security settings that prevent the deployment.

Please let us know if that helped.

Best regards,
Dan

[Daniel]

Hello,

The "Condition support for SSRS deployment" improvement has been added in version 11.4 of Advanced Installer released on July 30th, 2014.

All the best,
Daniel

[checkwa]

Hi thanks for updating.

[Daniel]

You're welcome.

All the best,
Daniel