.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

Report viewer control is is displaying parameter item 'select a value' even when the default param

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


I am using SSRS 2008 R2,

I have set the default parameter of dropdown and in the output "select a value" item text is removed ,also in the Report Manager 'select a value' removed .

But when I am displaying the same reports in the ReportViewer control as ReportViewer1.ServerReport  in the the vs 2010 asp.net project the item select a value is reappearing in the output.

Could you please help me remove the default item text 'select a value' from the ReportViewer control aswel.


View Complete Post

More Related Resource Links

Graphs stop displaying in Report Viewer Control after upgrade to SSRS 2008 R2

We are seeing an issue where certain graphs and guages are not being displayed within a report rendered in the report viewer control after we upgraded from SSRS 2008 to SSRS 2008R2.  You can see the graphs and guages render and then disappear from the screen when two other graphs are rendered.  When I export the report to Excel or PDF then all of the graphs and guages are rendered properly. There are a total of 3 graphs and 2 guages on the report - when it completes the rendering process, you can only see two of the graphs displayed in the report viewer control - as I said before, you can see all 3 graphs and 2 guages when exporting to Excel or PDF.  Using Internet Explorer v8.  This problem manifest itself right after the upgrade. Has anyone seen a similar issue? 

How I disable vertical scroll bar of report viewer control on Web Form.


I'm displaying .rdlc report file using Report viewer control on Webform. If  I Fix height of viewer control and data is not same as to size of viewer control then it display one scrollbar on viewer control and second vertical scroll bar is coming on webpage.

 I want to off viewer vertical scrollbar or in simple word's I don't want to display two scroll bar with my report. Please guide me or send me reference if any.


Microsoft Report Viewer control to display data on one page


Hello everyone,

I am wondering if the Microsoft Report Viewer control allows for display changes.  Say for instance a user wants would like to see all the data requested then another time would like to toggle thru the pages of infomation.  So does anyone know if the control allows for display changes from complete view to paginated viewing.  I am using MS VS 2008 with ASP.NET 3.0.  Thanks for your response.


Report Viewer Control Error

Hi All, I am adding a report datasource dynamically to report view web server control and getting the following eroor when i open the page. The DataSourceID of the ReportDataSource 'DataSet1_employees' of the ReportViewer 'ReportViewer1' must be the ID of a control of type IDataSource. A control with ID 'DataSet1_employees' could not be found.     Please help me where i am going wrong. The code is given below: protected void Page_Load(object sender, EventArgs e)    {        ReportViewer1.ProcessingMode = ProcessingMode.Local;        ReportViewer1.LocalReport.ReportPath = "Report2.rdlc";         ReportDataSource rdS = new ReportDataSource("Employees", GetData());        rdS.DataSourceId = "DataSet1_employees";        //this..Add(rdS);                ReportViewer1.LocalReport.DataSources.Add(rdS);        ReportViewer1.LocalReport.DataSources["Employees"].DataSourceId = "DataSet1_employees";        ReportViewer1.LocalReport.DataSources["Employees"]

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.

Displaying a Parameter Value in the report footer that corresponds with the parameterized data on ea

I've got a report that has only one parameter, it determines the department (or departments) to base the report on, the parameter is set to allow for multiple values. The report returns only on page per department, so the report could be anywhere from one to a hundred pages, one page per department. I've included a text box in the report footer that displays the report name and the parameter value, the expression looks like this: =Globals!ReportName & " For Department " & Parameters!Dept.Value(0)    I know that in this example the zero inside of the parenthesis of the parameter value is what is returning the actual value when the report is rendered, and I understand that the zero is value in the array of parameter values. What I'm looking to do is adapt this expression so that the parameter value rendered on each page corresponds with the data (departement) displayed on the specific page. So using the example of the data, if the user selected three departments in the parameter drop down, then each page that displayed the different department’s information would also display that departments name in the page footer text box. I'm thinking that each time a page is rendered that there is a group or global variable that can be called to provide this dynamically but I can't seem to find the information. Appreciate any help, Dan

Report Viewer Control and Passing Paramaters

Hi Guys, I have a situation where I am created a WEB APP that has a submit button on a FORM on the first ASPX page.  I have some VB code behind that to generate Header and Lines records in two tables with a HEADER ID as my PK.  I have another ASPX page which has the Report Viewer control on it and prompts me for the HEADER ID and displays the report correctly when I manually enter the HEADER ID.What I am now trying to achieve is when the user clicks the submit button on the FORM I want it to redirect to the other ASPX page and pass through the Header ID as a Parameter and automatically display the REPORT. Can somebody please point me in the right direction to achieve this.ThanksJoel 

Printing Landscape Report using the Print Control of the ASP.NET Report Viewer

I am using the ASP.NET Report Viewer 2010 web control in remote processing mode connected to a SQL Server Reporting Services 2008 R2 report server in Native Mode. I am viewing the report in IE8 and the print control within the report viewer is available. According to "Printing Reports from a Browser Using the Print Control" at http://msdn.microsoft.com/en-us/library/ms159237.aspx  "The Print dialog box and the default printer settings for width, height, and page orientation are determined by the report definition." In SQL Server Business Intelligence Development Studio I am using the “Report Properties” window accessed from the “Report” menu to set the Orientation to “Landscape”, the paper size to “Letter”, the Width to “11in”, and the Height to “8.5in” in the report definition. When viewing the report using the ASP.NET Report Viewer 2010 in IE8 and exportint to PDF, the report renders correctly in landscape orientation and the size both on screen and printed is as defined in the report definition. However, if I print it directly from the ASP.NET Report Viewer using the Print Control the print preview shows the report correctly in landscape orientation and page size, but the resulting printout is in portrait orientation and skewed or cropped.  If I go into the properti

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

Dynamic Columns Using Report Viewer Control

Hi,, I'm using Report viewer Control to generate reports.Currently i have static columns..I need to have columns created  based on the DB Query  results i.e., DB query will return more columns under certain conditions and less columns in another...In Short,Headers and column data will be known only at runtime.how can i bind the data dynamically...what can i do to accomplish this..

Displaying the Rating (Star) Scale Control for a list item.

Is there anyway to display the star rating control? I'm trying to build an application page that displays list items and their associated rating control. I can count the amount of ratings using the SocialRatingManager...?

question regarding displaying parameter value on the report header section



i have a tabular report which has 3 parameters.@begin date ,@enddate and @employeeid.the default value for the @employeeid parameter is "All" .the report works fine even if i don't enter any value for  the parameter @employeeid .

my question is:

i need to display the parameter value for the @employeeid in report header which is easy @parameter!employeeid.value

but I need to display "All" for @employeeid parameter in the report header even i don't enter any value for @employeeid 

i tried to do it by using the code below it is not giving me an error but it is not displaying "All" when i don't enter any value for the @employeeid parameter.


any help in this is greatly appreciated.



Is it possible to customize the layout of the report viewer parameter section?


Hi there,

I am wondering if it is possible to customize the layout of parameter section in the report viewer web part such that parameters can be selected in a secton on top of the report rather than on the right hand side?

Many Thanks and Regards


Report Viewer control: Print crashes if subreport is too long



I have a report and a .NET 3.5 Winforms application which displays the report in local mode, passing the required datasets to the report as it is supposed to do. It takes about 2 seconds before the report is displayed.

However, when I click on Print Layout, the "Loading..." box appears and does not disappear any more. If I want to print the report, a window appears telling me that the first page is being sent to the printer and... that's it, all I can do is kill my application via task manager.

After playing around with various elements in my report, I was able to reproduce this behaviour if one of my subreport returns too many rows (the subreport contains only a list element, listing all records).

I believe it has something to do with the subreport spanning more than one page. I played with the KeepTogether property on various elements, but to no avail. Has anybody experienced something like this before? Is there a workaround?



Action to sub report in Report Viewer control


We are having SSRS 2008 and we are using report viewer control  V9.0.0.0  to preview the reports. Actions attached to images are not working. I am not getting “hover” /”hand”  icon when I move my mouse onto the images. These links are working fine when I open the report in browser. Any help on this.


Do I need to download the latest report viewer control. Where can I get that ?

Report viewer web part: Dependency of parameter choices on user rights?


Hi there,

I am wondering if it is possible to restrict the choices for a parameter depending on the user rights. For instance, if an "administrator" can select three different options for one particular parameter, a "normal user" should only be able to choose from two.

I am using Sharepoint 2007 and Reporting Services 2005.

Best wishes



Default Parameter Values not Updated when Report Updated


This is either a bug or really wierd behavior by design that needs to be rethought in the near future.

I'm an enterprise developer on a commercial product that integrates and leverages reporting services.  We install a sizable number of reports automaticly as part of our production isntallation or upgrade.  I have a recent QA bug on that process that I find mystifying.

We install reports through calls to the CreateReport web service and its worked pretty well.  Recently, I had a report with a parameter whose definition changed.  Specifically, the default value of the parameter changed from 'All' to 'Select' and corresponding changes were made to the valid values list of the parameter.  When the report is installed, it works just fine.  But when the report is created as part of an upgrade to an existing system, the report for the most part gets all the expected changes but the new default value is not picked up.   Instead, it seems to stay hung on 'All', with the result that the parameter remains in a state of having unresolved dependencies ('All' no longer appears as a valid value) and as a result, breaks our interface (which was designed for single rather than multistep entry of parameters).

I know that some properties are not reset when calling CreateReport. &n

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