SSRS 2008 R2, VS 2008, User Defined Table Types
I have a stored proc that I use to create some customized lists. I'm t开发者_如何学运维rying to create it as an SSRS report, but it's running into a sticking point where it chokes trying to deal with the User Defined Table Type parameters.
Am I just screwed?
As an aside, it does work when you call it with a sql exec statement.
Thanks,
AFAIK there is currently no "native" way to pass table-valued parameters from SSRS to a stored procedure. However it is still can be done in a sort of a hackish way:Using Table-Valued Parameters With SQL Server Reporting Services or Passing Multivalued Parameters in SQL Server 2008.
精彩评论