Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1518
  • 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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