October 20, 2020 at 5:31 pm
I have a ssrs report with 6 parameters 4 or which are cascading and one parameter (pTimeZoneID) that drives the "Time Zone" in a dynamic OLE DB connection string. Need to set the Default value in the pTimeZoneID to a static "Time Zone" in order to use the data source to populate the 4 cascading parameters as the value of the 4th parameter sets the desired pTimeZoneID. I need to be able to set the Default in the pTimeZoneID using IIF but get errors trying to evalute a parameter that is fourth in the list of parameters.
=IIF(IsNothing(Parameter!4thParam.Value) = false, "Central Standard Time", Paramter!pTimeZoneID)
Error: The defaultvalue expression for the report parameter 'pTimeZoneID' contains an error" The expression references the parameter '4thParam' which does not exist in the parameters collection.
How can I evaluate a parameter that does not exist yet?
October 21, 2020 at 6:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
October 26, 2020 at 3:21 pm
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply