InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 23:26:30 GMT20http://www.sqlservercentral.com/Forums/Topic1385036-147-1.aspxOh well, I liked the thinking anyway :)Fri, 16 Nov 2012 03:27:16 GMTFunkyDexterhttp://www.sqlservercentral.com/Forums/Topic1385036-147-1.aspxDoh, yeah I was getting confused with the hidden properties as I knew it had one but forgot it doesnt have a true properties section, I tried to hack the xml of a test report to build in a IIF expression on a parameter but it issues a type error detailing that its not a boolean value.Fri, 16 Nov 2012 02:00:17 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1385036-147-1.aspxParameters don't have a hidden property as such do they? You've got the visibility option which is a radio button selection but there's nowhere to enter an expression.Am I missing something because that sounds like it would be ideal otherwise?Fri, 16 Nov 2012 01:47:53 GMTFunkyDexterhttp://www.sqlservercentral.com/Forums/Topic1385036-147-1.aspxYou would use the hidden property of the parameters based on the value selected by the open/closed parameter.Use an expression like=IIF(Parameters!OpenClosed.Value = "Open", TRUE, FALSE)You will need to ensure that your parameter order in the report is such that OpenClosed is above the date parametersThu, 15 Nov 2012 03:26:46 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1385036-147-1.aspxHi AllUsing SSRS 2008.I have a report where a user can view either open or closed jobs. If they're viewing closed jobs they will view jobs closed within a date range they select. If they're viewing open jobs they will simply view all open jobs, no date range required.So I want to enable/disable the date parameters based on what they pick in the "Open/Closed" parameter. I can [i]live[/i] with them having the date range available to select if they pick open but, since it's going to be ignored it just feels a bit yucky. This feels like it should be easy to resolve and I'm probably missing the obvious but I just can't seem to think of a way to do this. Any suggestions?Thu, 15 Nov 2012 03:19:54 GMTFunkyDexter