Powershell : ReportExecution2005.ParameterValue typedata

sakuraime 2,316 Reputation points
2021-02-10T06:41:59.313+00:00

When I try to declare a parameter for Report service rendering using powershell like below

$param=new-object ReportExecution2005.ParameterValue

it throw the error
66209-image.png

any hints to add this typedata ?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,790 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,352 questions
0 comments
Accepted answer
  1. Rich Matheisen 44,621 Reputation points
    2021-02-10T20:24:31.053+00:00

    Use "Add-Type". 

    Add-Type -Path "<directrory>.ReportExecution2005.dll

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 32,426 Reputation points
    2021-02-11T05:55:15.177+00:00

    Hi @sakuraime ，

    What @Rich Matheisen said seems that could resolve your issue, you may have a try.

    Also you could refer below for help.

    https://stackoverflow.com/questions/12923074/how-to-load-assemblies-in-powershell

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments