value of a parameter in SSRS
hi all, Is it possible to check the value of value of a parameter? for eg if there is a date parameter(multiple values).... prompted as "DATE" in the report... how can i refer to the data for a particular date? is there any syntax to find value(value(DATE)) ???
October 11th, 2010 8:20am
Yes, there is... Parameters!date.Value - this will show the value that is used. If you have labels on your parameters, enter this: Parameters!startdate.Label
October 11th, 2010 7:57pm
Hello, Did you find any solution for the post. If not so then could you give a brief idea on what you want with a sample data. Hope its clear....Pavan Kokkula Infosys Technologies Limited.
October 12th, 2010 8:04am
date can be accessed as parameter!date.value.. but is it possible to get value(parameter!date.value)??
October 12th, 2010 3:10pm
Can you give the sample value of the Date parameter and the value you exepected by Value(). Parameters!ParameterName.Value will give you the value of the parameter then why are you looking for Value()? Hope its clear....Pavan Kokkula Infosys Technologies Limited.
October 12th, 2010 4:36pm
Hi, In Reporting Services, the expression like =Parameters!ParameterName.Value will return the particular value of a single-value parameter, or an array of the specified values of a multi-value parameter. To get a particular value in multi-value parameter, we need to specify the index of the array. For example, we can use the expression =Parameter!ParameterName.Value(0) to get the first specified value in the multi-value parameter. For more information about Writing Expressions that Refer to Multivalue Parameters, please see: http://msdn.microsoft.com/en-us/library/aa337292(v=SQL.100).aspx If you have any question, please feel free to ask. Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help
October 13th, 2010 11:39am
Hi Tony, Thanks for your reply. Say a parameter X has 5 values A,B,C,D and E. Parameter!X.value(0) would ideally yield A. when i select A,i'll be getting the corresponding data in the report. i want to check if the data is zero.... something like value(parameter!X.value(0).. is it possible?
October 13th, 2010 1:20pm
Hi, To check if a specified parameter value is zero, we can use the decision function IIf() in the expression. For example, if parameter X is a single-value parameter, we can check its value by the expression =IIf(Parameters!X.value=0,True,False) If parameter X is a multi-value parameter, to check the first specified value, we can use the expression =IIf(Parameters!X.value(0),True,False) For more information about Decision Functions in Reporting Services, please see: http://msdn.microsoft.com/en-us/library/ms157328(v=SQL.100).aspx Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help
October 14th, 2010 10:25am