Displaying variable value in the report
Hi people of great minds!
I would like to ask for your help, please...
In my project "open" script, I've declared 2 variables (StartDate, EndDate):
var sqlText = new String();
DECLARE @StartDate as DATETIME
DECLARE @EndDate as DATETIME
SET @StartDate = DATEADD(month, DATEDIFF(month, 0, getdate()), 0)
SET @EndDate = convert(datetime,convert(varchar(10),(getdate()-1),120) + ' 23:59:59')
< select >
< from >
workorder.actfinish >= @StartDate
and workorder.actfinish <= @EndDate
Now, how do I fetch the values of StartDate and EndDate for them to get displayed in my report?
I've read through few forums and articles and most of those suggest declaring a global variable, but "Variables" is not available in my hierarchy: