January 31, 2017 at 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
January 31, 2017 at 4:46 pm
ebooklub - Tuesday, January 31, 2017 2:08 PMI 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_cmdshellThank 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
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy