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
Free Windows Admin Tool Kit Click here and download it now
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)??
Free Windows Admin Tool Kit Click here and download it now
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
Free Windows Admin Tool Kit Click here and download it now
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
Free Windows Admin Tool Kit Click here and download it now
October 14th, 2010 10:25am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics