Hello,
I have a stored procedure which has two parameters they both are varchar one is Year and another is Month. First user will select which year and based on that they will select month to view the report filtered. But I need to set default values on these paremters. When I go to edit paremeter for isntance: Month on default it only gives me option for jan,feb,march.. I added these manually as a static parameter.
But What I really want is default value to be previous month to be auto selected when the parameter prompt comes up. For example: Right now is March I want Febraury to be prepopulated on the propmpt.
I was trying out a formula:
?@Month is my parameter
{?@Month} = (MonthName(Month(CurrentDate)-1))
But this dont work!
How can i have default parameter for this and year.. automatically default current year. Please HELP thank you!
I have a stored procedure which has two parameters they both are varchar one is Year and another is Month. First user will select which year and based on that they will select month to view the report filtered. But I need to set default values on these paremters. When I go to edit paremeter for isntance: Month on default it only gives me option for jan,feb,march.. I added these manually as a static parameter.
But What I really want is default value to be previous month to be auto selected when the parameter prompt comes up. For example: Right now is March I want Febraury to be prepopulated on the propmpt.
I was trying out a formula:
?@Month is my parameter
{?@Month} = (MonthName(Month(CurrentDate)-1))
But this dont work!
How can i have default parameter for this and year.. automatically default current year. Please HELP thank you!