InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 16:10:38 GMT20http://www.sqlservercentral.com/Forums/Topic1384026-391-1.aspxAlright!! ThanksTue, 13 Nov 2012 07:31:33 GMTvar05http://www.sqlservercentral.com/Forums/Topic1384026-391-1.aspxIf there is, I haven't found it yet.Tue, 13 Nov 2012 07:30:41 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1384026-391-1.aspxYa true :(Is there any work around for it?? One option is : Jump to URL... But I wannted to check if there is any other way for Drill through reports using Jump to report option itself...Thanks for ur responses. Much Appreciated if any work around is there for it..Tue, 13 Nov 2012 07:28:06 GMTvar05http://www.sqlservercentral.com/Forums/Topic1384026-391-1.aspxAh ok, now I get it. As far as I know, this is a common issue with drillthrough reports. If you drillthrough, the prompt area is hidden (unfortunately).Tue, 13 Nov 2012 07:25:24 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1384026-391-1.aspxYa as u say if we set the parameter to Boolean then we are able to set a default value.But as we deploy the reports, and when we navigate from report1 ->report 2, the entire paramater tab is getting hidden automatically.Every time I got click on the button show/hide parameters. In order to avoid this issue, I am trying to create a dummy param say iif 1=1,true/false... In such a case when I deploy, the parameter selection tab doesnt get hidden. I thot this would be a work around to display the parameter tab always..Tue, 13 Nov 2012 07:15:55 GMTvar05http://www.sqlservercentral.com/Forums/Topic1384026-391-1.aspxI tried it myself, and I could set a default value for a boolean parameter without a problem.How did you try to set the default value?Tue, 13 Nov 2012 07:01:00 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1384026-391-1.aspxNo where the parameters are hidden in any of the reports. While navigating from Repor 1-> Report 2, I wanted to set a default value for Reportparameter2. I am not able to set a default value at all...I wanted to set a default value.. I suspect default values cannot be set if a parameter accepts true /false condition.. I am not sure thouAny help?Tue, 13 Nov 2012 06:47:24 GMTvar05http://www.sqlservercentral.com/Forums/Topic1384026-391-1.aspxDid you mark param2 as hidden?Tue, 13 Nov 2012 04:47:14 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1384026-391-1.aspxHi all,Problem with setting default values to a paramater with true or false condition.I have 2 reports and I am navingating from report 1 to report 2 using a textbox.Report 1 : I have two paramaters passing from report one.Param 1: gets data from the defined paramater datasetParam 2: Check for a condition like =iif(1=1,true,false) (some dummy condition)In report 2, even though I specify values for available/default values(for reportparameter2), it is not taking it into account.Every time I drill down to report 2 from report 1, the drop down of reportparameter2 is shown. Can we set it to a default value?ThanksTue, 13 Nov 2012 04:16:03 GMTvar05