3 parameter with custom code
Hello,
So the problem I am having is when I assign the values for a parameter from custom code or an expression all I see is a greyed out box that doesn't allow me to select a value. If the parameter happens to be the first in the set then I can see and select
a value. The other two parameters only have a greyed out text box that doesn't allow any value selection. Is this a known issue or am I doing something wrong.
The parameters that I have are UserId which is populated from the singed in user. strStart, the start date which is populated by the following custom code.
public function setParameter() as string()
dim str(0 to 2) as string
str(0)="1/1/" & Year(DateAdd("yyyy",-2,Today))
str(1)="1/1/" & Year(DateAdd("yyyy",-1,Today))
str(2)="1/1/" & Year(DateAdd("yyyy",0,Today))
return str
End function
When this is the first parameter I get the expected values. But when I move it to be the second or third I get no return values and am unable to select or type in the text box.
Any help on this issue is greatly appreciated.
Thank you
Mark
February 25th, 2012 3:07pm
You need to set the default value for the parameters preceeding this for the code to be executed. Try setting the default value for the other parameters to "" (you need to select allow blanks) and this should solve your issue.
Free Windows Admin Tool Kit Click here and download it now
February 25th, 2012 3:18pm
Thank you for your help but this didn't seem to fix the issue. Your idea about the deflault value got me thinking. Once I picked a value the other parameters became available once the preceeding one has been selected. I am going to try and combine two
of the prameters into one and see if I can get it to work correctly. Mark
February 25th, 2012 3:29pm