• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1546
  • Last Modified:

Table Valued Function Error in Report Builder 3.0

I am attempting to use a Table Valued Function PXQ7000_SSRS as my dataset in Report Builder 3.0. When I do this I receive the following error:

The request for procedure ‘PXQ7000_SSRS’ failed because ‘PXQ7000_SSRS’ is a table valued function object

How can I execute a Table Valued Function as I do not want to create these as Stored Procedures?
0
mburk1968
Asked:
mburk1968
1 Solution
 
DultonCommented:
Right click your dataset in your Report data object explorer and go to dataset properties.
verify the query type is set to "Text" and not "Stored Procedure".
with it set to Text, type into the Query box:
Select Tvf.* from PXQ7000_SSRS(@MyParam1, @MyParam2......) AS Tvf

Open in new window


Then click "Refresh Fields".
0
 
mburk1968Author Commented:
Perfection! Thank You
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now