.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 manager parameters , back button do not show

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
Hi, not sure this is an expected behavior.  My drill through reports have parameters that are passed from the first report.  once drill through, somehow the parameters are not showing in report manager.  also the Back arrow is also missing from the second report.  is this expected?thanks

View Complete Post

More Related Resource Links

Back Button for Parent Report

Hello all, I have created a summary report and have the hyperlink set up to jump to another detail report. In BIDS, when I get to the detail report, there is an option to go back to the parent report. But when I publish these reports to Report Manager, that back button is not there. Does anyone know a workaround to this? I really want the user to be able to go back to the summary report when they are done looking at the details. We are working on SSRS 2005. Any help would be greatly appreciated.

Parent report parameters not maintained when going back from sub report


I have just managed to integrate SharePoint 2010 (just installed last week so we pretty much use latest sp and fixes) with SSRS 2008 SP2 (no unfortunately not R2 we had a reason for that)

Most parts work but unfortunately we have a huge problem going back to a parent report from a sub report.

The parameters pane doesn't change back to the 'original' parameters pane from the parent report and this of cause result in an script error when trying to process another sub report from the same parent. The parameters obviously doesn't fit.

I have read the following very similar thread: http://social.msdn.microsoft.com/Forums/en-ZA/sqlreportingservices/thread/fa6d9b5a-eef5-43d9-8906-36c7eac33796

But it doesn't really give me anything to work with.

Having many parameters and quite a long excution time on the parent report. It is not really an option to run it each time we want to find details through the sub report. (I write as if we only have one parent/sub but we have many ...)

I have a test setup where the DB and SSRS is 2008R2 and it is the same problem.

Everything worked fine with SharePoint2007 and SSRS2008 SP2

Is this a known bug? Is there a fix or a workaround ?

Please help


Passing parameters between 2 SSRS reports deployed in report manager



I have created 2 reports in SSRS. In my 1st report there is a tablix, which contains many rows. The text in these rows act like hyperlink and upon click navigate to my 2nd report. This functionality is working fine in Visual Studio and also in report manager. But as soon as I deploy my reports in SharePoint site (using a page viewer web part), this functionality breaks. I can see when I take my mouse near the text in the Tablix it shows a URL like http://IP Address/Reportserver/

It's evident that the URL here is not forming correctly. Can anyone help me out in this issue. In my report for navigation purpose I had used Action -> Goto Report (report 2) and passing the parameters there.

Thanks in advance,


Edit/Display of Report/Properties/Parameters only 2 decimal places show need 4 decimal places


Does anyone know if there is a way to display 4 decimal places on an Overide Default of data type Float on the Report/Properties/Parameters page.  It accepts 4 decimals and that is what is used in report but when returning to this screen it only displays 2 decimals.

SSRS 2005

Can someone show me how to remove blank columns from a matrix report with parameters?


I have a drilldown matrix report with 5 parameters that I group on. The users have the option of selecting any of these parameters when they preview the report. They can also select No grouping as one of the parameter option.   When I run the report and select for example, 4 parameters and the No grouping option, I get blank columns.  When I select no grouping, no data is displayed.  As a result, I get blank columns.  Is there a way to hide the blank columns?  I would appreciate any suggestions.  See table example below:



Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page


how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services


Thanks in advance

Passing report parameters by report viewer


I have 4 parameters in which 3 are passed in report and 1 is passed through report viewer. I have made a parameter in SSRS called CandidateId to which I want to pass the value. The code for report viewer is:

 intReportID = Convert.ToInt32(Request.QueryString["ReportID"
 CandId = Convert.ToString(Session["CandidateId"
lblReportName.Text = dtReport.Rows[0]["ReportName"
SSRSReportViewer.ShowCredentialPrompts =false

 SSRSReportViewer.ServerReport.ReportServerCredentials = new
SSRSReportViewer.ProcessingMode = Microsoft.Reporting.WebForms.


 SSRSReportViewer.ServerReport.ReportServerUrl = new

SSRSReportViewer.ServerReport.ReportPath = dtReport.Rows[0]


 Microsoft.Reporting.WebForms.ReportParameter[] theparams = new

theparams[0] = new
, CandId);
theparams[0].Visible = false

Posting back a disabled button


Folks, I have a control which inherits from LinkButton and I'm trying to make sure that the user cannot cause mayhem by performing multiple postbacks.  That seemed an easy enough challenge, so I have this code [snippet] on the client:

ButtonClicked: function () {
    if (this._DisableOnClick == true) {
        this.get_element().disabled = 1;
        this.get_element().style.cursor = 'wait';
    else {
        alert('Posting back');

The alert is of course only there for debugging.  If the DisableOnClick value is false, then I see the "Posting Back" alert and, when I click ok, the postback occurs - all good.

If the DisableOnClick value is true, then the "button" gets disabled and the cursor turns into an hourglass - again good.  But the postback doesn't happen - not good.  I assume that the ASP client code is trying to help by preventing the postback when it sees that the link is disabled.

So, how can I either:

  • Persuade the LinkButton to postback even though it has just been disabled; or
  • [probably better] Get my client code to execute immediately after the postback code rather than before.



Preview Crystal Report from ASP.net without passing parameters


Hi Everyone,

Sorry couldn't think of any better Subject..

I am developing a User Reports Module using C#.Net using Visual Studio 2005. Basic purpose of this module is to allow user to be able to run their own Crystal Reports. i.e. if Users have their own Crystal Reports specific to their needs then we allow them to save them and view them from our user reports module.

So when user saves any report we save it on server and save the Physical path of that report in database. Now when user tries to view the report I get the location from database and load it. Which works ok. The issue now is those reports which have got parameters. 

I am not saving any information about parameters in their reports. So I do not have any information about Report Parameters.

This same application exists in VB6. What that VB application does is opens the Crystal Report and then Crystal report asks for needed parameters exactly as it will do if we try to open a crystal report using crystal report and preview it from there it asks for parameter values. 

How can I do that in C#.Net.

VB has got code like this

Global Appl As New CRAXDRT.Application

ReportViewer Calendar button Click does not show calendar


I have a reportviewer on a page which is grabbing a report from a report server. the page is basically just a dropdownlist and a reportviewer control. The problem I have is that in the report the user have to provide the dates for teh report. The reportviewer automatically adds the textbox for the date entry and a calendar icon in front of it so the user can select the date. if I look at this page  in FireFox, when you click on the calendar button created by the reportviewer, the calendar control show up momentrily and dispappears. If you look at the same page in IE 7.0 nothing happens other than the page appears to be submitted. Does any body have any ideas on how to go about troubleshooting this bug?



Report parameters *, =<>constant

Hi I have filtered a report dataset depending on whether a field contains the string "Hong Kong". However I would like to present the user with the option to select the label 'All' not to bring back all records, or the label 'Excluding Hong Kong' to bring back all records where the value in the field is not equal to "Hong Kong", anyone know how to do this?

displaying parameters through expressions at the top of the report

Hi,   We developed around 70 ssrs reports for our new application.Its like,all the report names are menrioned in the left hand side and if we click it,.Net calls the SSRS reports and shows in the Right hand side.    At the top of Each and every report,we dispaly all the parameters using expressions. Now, the issue is, in the parameter if they select a single value, then it should display and if they select more than one, it should display like 'More Parameters are selected'. can you helpme how to do that?

Howe to do :Excel export button in report viewer visible false...?

hi all,  How I can do avoid to display  Excel export in ReportViewer..? if I Use //-------------------------- reportViewer1.ShowExportButton = false; //---------------------------------------------------- Both the buttons will be disabled...for only Excel button How can I...?    

Form Action Button to pass parameters through URL and how to fill a NewForm with them

Hi I'm trying to solve a bigger problem we have in babysteps, and I guess after days of searching and trying I simply need to ask for help. The big picture is, that we're trying to put a Form Action Button (via Sharepoint Designer 2007) above a custom DataForm DispForm.aspx which is supposed to navigate to a NewForm.aspx where the Title Field is supposed to be prefilled with a parameter from the DispForm and the user should be able to add information to the item before it is saved. I found several explanations from people on the internet, but nothing really worked. The first babystep would be to get the parameter through the button into the url of the new item.   < input type = "button" value = "Zugriff Beantragen" name = "btnFormAction0" onclick = "javascript: {ddwrt:GenFireServerEvent('__redirect={../Zugriff Beantragen 2/NewForm2.aspx?test={ItemID}')}" />   That's the code for my button. Somebody wrote that should definitely work because SharePoint is able to replace {ItemID} with the actual ID of the item. Well.... it kind of doesn't. What I get as the end of the new URL is exactly "...?test={ItemID}"   I tried with different names for the ID, I added an @ before those ... no change. I read somewhere about javascript.functionName() which should work with all parameters of the item, but

Adding a button to the Report Portal

Hi everyone, I am using SSRS 2008 and would like to know if there is a way to customize the Report Portal?  I need to add a button that the user can click on when they find a bug or the report doesn't work.  The button would open an email window for the user to type in the problem they are experiencing and it would be sent to our Ontime system.      Thanks for your help!  Youngmon...  

Web Form breaks after using the browser's back button

I have a web form that allows a user to put some data in a textbox and click a button to do a search on that data.  It opens up a Sql Server Reporting Services report using the data they entered on the previous page.  If they use the browser's back button to go back and enter some different criteria to search on, the buttons don't work anymore. Any ideas or suggestions on what would cause this?   Thanks! 

How to export SSRS report to PDF from SSIS with parameters

Hello everyone.  I am trying to setup a process in which a user, who is using a vb.net 2008 application, will need to  trigger the creation of two items.  The first is  SSRS report which will need to be exported to PDF format to a shared folder on the network.  This report accepts one parameter.  The second thing that will need to be created at the same time is an excel file with data exported from SQL Server 2008 which is generated through an SSIS package.  A couple things to note.  The excel file and the pdf file need to have the same file name, other than the extension.  For example P00000001_20100831.pdf and P00000001_20100831.xlsx and will both be stored in the same network share.  The filenames need to be created dynamically at run time and will be based on a parameter being passed to the report. So far I have the portion that creates the excel file working fine.  The way I create that is as follows.  I have a stored procedure that creates a job which calls the SSIS package and passes the appropriate parameters to the SSIS package.  After the job is created I immediately run it and then delete the job.  Ok, everything works fine with that. Now I cant seem to figure out how to get the pdf created.  If possible I would like to keep this portion together with the already created job or package.&nb
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