Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Table Valued Function Error in Report Builder 3.0

Posted on 2014-04-04
2
Medium Priority
?
1,501 Views
Last Modified: 2014-04-04
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
Comment
Question by:mburk1968
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
Dulton earned 2000 total points
ID: 39977941
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
 

Author Closing Comment

by:mburk1968
ID: 39978343
Perfection! Thank You
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question