Tuesday, 8 May 2012
For Dates in a calendar style report you could use the following to generate the dates.
with mycte as
( select cast('2012-01-01' as datetime) DateValue
select DateValue + 1
where DateValue + 1 < getdate())
-- select DateValue
-- from mycte
--OPTION (MAXRECURSION 0)
Year(DateValue) as Year,
DATEPART(Quarter ,DateValue) as Quarter,
DATENAME( month,DateValue) as MonthName,
DATEPART(m ,DateValue) as MonthNo,
day (DateValue) as Day
OPTION (MAXRECURSION 0)
at May 08, 2012
When running a report for the first time in report manager it takes a while to run, after this initial run reports run fine. There are a ...
I have recently been looking at conditional page breaks in SSRS 2008 r2 and did not know that it is possible to do via an expression. For...
Due to the fact the reporting services allows you to query the tables you can easily write SQL which will allow you to return data from the ...
To Alternate colours for a group: =iif(RunningValue(Fields!MYFIELD.Value,countdistinct,nothing) mod 2,"silver","white")...