Page 1 of 1

Passing YEAR or MONTH from variables to Parameters

Posted: Mon Sep 03, 2012 4:34 pm
by LSantos
Hello

I have build a SQL server stored procedure that return values depending on 4 parameters:
Present Year
Previous Year
Month of Present Year
Month of Previous Year

The report works, but i want to see for the parameters only textbox to input Years or Months , actually i have a calendar.
I can do that , because i don´t find any example.
How can build my variables and also my parameters.

Many thanks
Luis Santos

Re: Passing YEAR or MONTH from variables to Parameters

Posted: Tue Sep 04, 2012 11:22 am
by HighAley
Hello.
LSantos wrote:I have build a SQL server stored procedure that return values depending on 4 parameters:
Present Year
Previous Year
Month of Present Year
Month of Previous Year

The report works, but i want to see for the parameters only textbox to input Years or Months , actually i have a calendar.
I can do that , because i don´t find any example.
How can build my variables and also my parameters.
Please, look at the Parameters - Date Range example report from our Demo.

Thank you.