I was investigating precisely this problem and you answered it completely, thanks! Also agree that it's a bit cumbersome. I am going to try setting up a function, a view based on the function, and then use a where clause on the view from reporting services, I think it will be cleaner. Here we go... :-)

Turns out the function + view + where clause worked great - no looping through parameter array values in Reporting Services, and the view is very convenient for additional adhoc querying. What do you think Jesse?

By the way, I misspelled my own name earlier. DOH.

The post is very helpful. I had a requirement to use table-value parameter within SSRS. Searched in google and became mad. Atlast found your solution. I have followed your method and able to see the output in Development studio. When i uploaded this to Report server then its throwing error: "Query executin failed for dataset. Column, parameter, or variable #1: Cannot find datatype integer_TableType". Please suggest solution for this.

@Aditya: I'm glad the post was helpful.
The error you're getting is because you haven't yet setup the user defined type representing a table variable with a single integer column.

If you check out the post just before this one you'll see instructions on how to define the Integer_TableType in your database schema.
Here's a link to that other post:
http://wblo.gs/d0K

Thank you Jesse for your quick response. I already created table type in the DB before working on the report. And good news is that its working now. There were similar Datasources in Report server, i pointed to wrong one. When i changed, it started working.

Jesse... I implemented this method in a project a month back after going through your blog. Its working fine but sometimes its failing. Below is the error:
"An error has occurred during report processing.
Query execution failed for dataset 'DSOutput'.
String or binary data would be truncated. The statement has been terminated. "

I don't understand why its failing. Please suggest on this.

This was really helpful, thanks. Because our parameter list used string identifiers (which needed quotes) instead of integers, I duplicated your function with the slightly amended line:
insertStatements.AppendLine(String.Format("INSERT {0} VALUES ('{1}') ", variableName, paramValue))
Also, I had a problem with Reporting Services not having EXECUTE permission on the table type. This was sorted after looking at:
<http://connect.microsoft.com/SQLServer/feedback/details/355949/execute-permission-missing-on-user-defined-table-type>

Thank you..Jesse.I have sucessfully done it for one TVP parameter, what could i do if there are more than one TVP's.

I have a similiar requirement where I need to pass a Table-valued paramter to the Stored Proc through SSRS. I followed all your steps as mentioned and I get an error "Parameter X is missing a value. Whaam I doing wrong? When I make the Parameter( which is set to Internal) visible, it works fine. Because it prompts me to select the value from the drop-down box

Hi Jesse, I followed your steps and was able to do pass the table valued parameter. The problem I am having now, I need to pass two table valued parameters. I set up a second one just like I did for the first, but it's giving me the error for the second parameter, that I must declare it. I think, it's the syntax problem with the dynamic SQL. When I switched the first parameter with the second one, it gave me the error for the first parameter, which tells me that it doesn't recognize the second parameter in the list:

exec('declare @insuredNamesList TextTableType ' + @InsuredInserts +
',@insuredPoliciesList TextTableType ' + @PoliciesInserts +
' EXEC [dbo].[rpt_Detailed_LossRun]
@startDate=''' + @startDate + ''',
@endDate='''+ @endDate + ''',
@Insured='''+ @Insured + ''',
@ReportName='''+@ReportName + ''',
@InsuredNames=@InsuredNamesList,
@MatchingPolicies=@insuredPoliciesList')