Adding Powershell as embedded code in SSRS 2014 report

• ebooklub

  Hall of Fame

  Points: 3905

  More actions

  January 31, 2017 at 2:08 pm

  #334912

  I found only  examples of adding VB  to reports https://msdn.microsoft.com/en-us/library/ms156028(v=sql.120).aspx

  Can we add PowerShell as  embedded code in SSRS 2014 report ?

  Looking for possibility create dataset based on output  PowerShell script
  Need solution other then using xp_cmdshell

  Thank you

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  January 31, 2017 at 4:46 pm

  #1925979

  ebooklub - Tuesday, January 31, 2017 2:08 PM

  I found only  examples of adding VB  to reports https://msdn.microsoft.com/en-us/library/ms156028(v=sql.120).aspx

  Can we add PowerShell as  embedded code in SSRS 2014 report ?

  Looking for possibility create dataset based on output  PowerShell script
  Need solution other then using xp_cmdshell

  Thank you

  The custom code option only supports VB and is for code being used in expressions.
  You could output the results to a CSV file as there are ways to use csv files as data sources in SSRS. But the last I looked, it involved creating a DSN which I don't think is a decent option so I never looked any further.
  It seems that you should be able to dump the results to a SQL Server table and use that as the data source though.

  Sue