Last post Aug 26, 2011 05:09 AM by ghanshyamdreamtech
Aug 25, 2011 10:35 AM|ghanshyamdreamtech|LINK
I am very new to SSRS.
I have added one Parameter named Date on SQL Server Report
i have set parameter value from aspx.cs code behind file
i have drown that parameter on ReportHeader and i want display CurrentDate value on that parameter
and i tried =Join(Parameters!Date.Value,", ") but it displays #Error at runtime.
i also tried =Join(Parameters!Date.Label,", ") but it displays Nothing.
Please tell me how to display Parameter value on Repor
Aug 25, 2011 12:15 PM|TP|LINK
where Param1 is the parameter name
Aug 25, 2011 12:20 PM|ghanshyamdreamtech|LINK
I tried it.. It gives me compile time error
Aug 25, 2011 03:31 PM|TP|LINK
can you please share what the error is ? are you sure the parameter is on the report because the expression in my previous report should work
Aug 26, 2011 02:27 AM|Nishantg|LINK
I am not sure why you are using Join here, is your parameter is a multivalue parameter? if not then just use the Parameters!Date.Value. Because Join function is expecting an Array value and I think in parameter you are supplying a single value, thats why
its giving the error.
Aug 26, 2011 05:09 AM|ghanshyamdreamtech|LINK
Thanks for your answer .. ,my problem is solved !!