Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1558
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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