.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Not able to use SSRS report with a parameter within Performance Point 2010

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server

I have created a report in SSRS 2008 and have passed a parameter called Carrier to it. The report works fine on http://machinename/reports and am able to pass parameters to the report including the All Carriers parameter.

However I cannot get the report to run in PPS 2010. In PPS I have created a multi value filter called as Carrier and have passed this filter to this report. But when I execute this report I get the following error :

    Reporting Services Error

  • Default value or value provided for the report parameter 'Carrier' is not a valid value. (rsInvalidReportParameter) Get Online Help

SQL Server Reporting Services


I have used the data type as string in SSRS.

Please help.

View Complete Post

More Related Resource Links

SSRS Report Sorting issue in Dashboard created usign Performance point services in sharepoint 2010


I have created a report in SSRS and this report is integrated within a dashboard created using performance point services in sharepoint 2010.

The report is a simple tabular report with 5 coulmns and interactive sorting is enabled on each of them.

Sorting works when the report is viewed separately but gives "Report Server Error" when I try to sort (on any column) inside the dashboard.

I have user IP instead of host name in the report server url.

Please help.



Is there any Sharepoint 2010 Webservice call that I can point my SSRS Report at to retrieve an execu


I want to create an SSRS report that displays all the steps in an executing workflow along with its current stage.

SharePoint 2010 webpart shows the current state of the executing workflow but I want to display all the steps including ones that have been completed and ones that are still to come.

ssrs 2008 R2 - report parameter with no default set throws java script error

We have recently upgraded from SQL Server 2008 to SQL Server 2008 R2....I am experiencing a problem with my report parameters on my SSRS reports. It seems that my report parameters that I do not have a specified 'default' value throws a java script error when I try and run/render the report under R2.  As soon as I put a 'default' value on the report param, everything is fine.  However, that is not the behavior we need for our reports...the user needs to pick their selection. Can anyone shed some light on this, it seems to be an AJAX problem...I need to be able to have report parameters with a list of values, but no 'default' value on the parameter.

SSRS Report Parameter Auto selection

HI All    I have a report paramater 'ParamBranches' which list all branches say aa,bb,cc etc ... and another report parameter is 'ParamBranchStartswith' So when i type in 'a' in Branh Starts with paramter -  the 2nd parameter that is ParamBranches will be filled with "select ",  "aa"   As there is only one Branch starts with 'a' ,  Is there any way to autoselect the Branch 'aa'  in Branches list , rather than user manually selects 'aa'       Regards Sooraj

Problem with Report parameter inside SSRS Report Viewer webpart with deployment from one server to a

Hi all,I've got this problem.me and my team have developed a lot of reports by using a SSRS configured in Sharepoint Integration Mode.For accessing these report we are using the Sql Server 2008 Report Viewer Webpart.One of its parameter is the Report ur that is an absolute url so the problem is when I move our solution from server1 to server2 I have to re-editing all pages where I've added the Report Viewer webpart for updating the report url with the new servername otherwise it's impossible to view the report.Is there any official or unofficial way to solve this problem ?many thanks

Change performance point report color

This should be a simple question. I would like to change the color of the bars in the bar graph charts, and the color of the line in the line graph charts. I would imagine there is a way to do this. 

SSRS Report Performance & Optimization

Can  any explain how would i Optimize a report performance.. I have few reports that are taking longer time to run. Thank youFM

Performance Point 2010

To implement tag clouds to a Analytical report in  Performance Point 2010. Also can we have a Performance reports to be imported as a Web part in TeamSite Collection

Pass parameter to Hidden Field in SSRS Report

Hi, I have Two Columns in a Table Say As Table1 Column1 = Text Column2= id My SSrs Report has two parameter values as Column1 and Column2. Column2 should be hidden SELECT DISTINCT COlumn1 FROM Table1. i have passed this query dataset to Column1 parameter. Now My requirement is that, when ever column1 drop is selected. the hidden field column2 should fecth the corresponding ID. this column2 has Storeprocedure which will Display the Output when View Report button is clicked Thanks, Saraswathy

SharePoint 2010 - Performance Point & Dashboard Designer

We have successfully installed SharePoint 2010 onto our dev machine; we have also followed the documented steps for configuring Performance Point; http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx.  All seems fine however we do not seem to be able to create a connection from Dashboard designer back into SharePoint.  When we check the logs we get the following error Critical   An unexpected error occurred.  Error 5678.  Exception details: Microsoft.SharePoint.Upgrade.SPUpgradeCompatibilityException: There is a compatibility range mismatch between the Web server and database "WSS_Content_PerformancePoint_1", and connections to the data have been blocked to due to this incompatibility. This can happen when a content database has not been upgraded to be within the compatibility range of the Web server, or if the database has been upgraded to a higher level than the web server. The Web server and the database must be upgraded to the same version and build level to return to compatibility range. We have a farm config on a single 64 bit box and SQL Server 2008 loaded.  We have un-installed and re-installed the site collection. Does anyone have any ideas? Eddie Barrett

List of Month and Year in SSRS report parameter?

Hi, I have two parameters in my SSRS Report i.e. Month and Year. I want to show the list of all Months in dropdown and years for a particular range say 1995-Current Year.
Can any one suggest me the query for how to get it to work.
Thanks!! MCP

Deploying SSRS Reports from Visual Studio 2010 to Report Manager 2008


Our Report server is using Report Manager 2008. Previously I would load reports to it that I created via BIDS. Now I have to use VS 2010. I see that I can build and deploy reports there. Can I send it from VS 2010 to the REport manager 2008 on the other machine? I should add that now i have to develop on laptop only before i was on the server.

If not what are my options? I recall that vs 2005 objects were not taken in Report manager 2008.

Training on Performance Point 2010 and SQL Server 2008 BIDS



Me and my team are developing a POC in Performance Point 2010 using SSASCubes,we are planning to recommend trainign for the team  but i had a couple of questions.

1.The Team is totally new to this technology as we dont know what is .NET,MOSS 2007 and SQL Server 2008 R2.

2.Does working in PPS 2010 requires basics of Sharepoint 2010 and .NET,if yes then what are the areas we need to look into it before proceeding with PPS 2010 training


Can anybody kindly guide us with the same




Rdl Report's Parameter DataSet Using SSRS




I have to design a Page Similar to Report Server's Viewer Page where if any Parameter is multivalued and if any Stored Procedure/Query Name is specified in the Report, then a it is internally executed and checkbox dropdown list is displayed to select the values.

Similar to that I have to design an aspx page with the similar behaviour. How to get Stored Procedure Name(if Specified/Query) of any Parameter of a report? So that I can bind my Checkbox list on the aspx page.


Please Help!


SSRS Report Viewer WebPart dynamic dispaly in SharePoint 2010


dynamic layout or zone  for Report Viewer Webpart, the report as to take all the space possible, and I don't want the scroll bars.

Any Suggestion

Save a Personal View of Performance Point Services Report


Hi I am changing the view of my Performance Point Services report and want to save the same like it was possible in proclarity. I have been told that all features of Proclarity are there in Sharepoint Performance Point Services.

I  was able to find the decomposition chart but not the option of saving the modified view. Has this been removed,If yes can i use Object Model and write code for it.



SSRS URL Paramter Value does not match with report parameter Values



We have rdl report and passing a multiple paramter values through URL. When the passed values exists in report parameter values then report displayes properly.

But when we pass the values through URL which doesn't exists in report parameter value then it throws an error saying parameter value is missing.

The reports db and the application db through which we display the reports are different. how do we address this issue.

pls help.

regards, hari.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend