Viewing 6 posts - 46 through 51 (of 51 total)
Hello,
This might help you, rather than doing into SSRS, create new datasource and use below code for your parameter
[Code]
DECLARE @Day INT
SET @Day = datePart(dd,getDate())
IF @DAY < 21
BEGIN
SELECT CONVERT(VARCHAR(25),(dateAdd(MONTH, dateDiff(MONTH, 0, getDate()),...
April 2, 2012 at 2:54 am
#1467520
Thanks for useful informations!
Gaps are normal then it's fine, i thought i was missing something.
March 30, 2012 at 9:00 am
#1467003
You are a Super Star!!!! Great!!!
March 19, 2012 at 9:52 am
#1461204
Hello Everyone,
We had same situation where we had application front end in Access 2003 and Backend SQL Server 2005, runs fast no probs.
Now we upgrade Access 2007 noticed perfomance issue,...
March 9, 2012 at 3:30 am
#1457041
DECLARE @MyDate DATETIME SET @MyDate = getDate()
DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME
SET @StartDate = DATEADD(dd,0, DATEDIFF(dd,0, DATEADD( mm, -(((12 + DATEPART(m, @MyDate)) - 4)%12), @MyDate ) - datePart(d,DATEADD( mm, -(((12...
February 23, 2012 at 9:09 am
#1450939
FORMAT(now,"dd/MM/yyyy")
January 19, 2012 at 9:27 am
#1435988