Viewing 15 posts - 1,066 through 1,080 (of 2,278 total)
bopeavy (7/18/2011)
Ray K (7-18-2011)
Back!!! (from vacation, that is -- what'd I miss?)Foward!
Fast
July 18, 2011 at 7:57 am
Got it wrong, but the explanation definitely makes sense. Thanks.
July 18, 2011 at 7:56 am
bopeavy (7/15/2011)
Revenant (7-15-2011)
bopeavy (7/15/2011)
--------------------------------------------------------------------------------
SQLRNNR (7-15-2011)
--------------------------------------------------------------------------------
motivation
observation
Conclusion
Success
Tenacity
July 15, 2011 at 12:04 pm
Could you post your query? I am not sure I understand the problem as you are stating it. Is specialist and sales person the same or is it...
July 14, 2011 at 2:32 pm
You might be able to add a group to your report, and not show any detail. But, Phil is right, the best approach is to alter your dataset query...
July 14, 2011 at 7:17 am
I don't think the switch function has a functional else. Maybe it is just the way I do it and I have forgotten, but I believe the switch function...
July 14, 2011 at 7:13 am
SQLRNNR (7/13/2011)
bcsims 90437 (7/13/2011)
Buzz LightYear2Infinity
and Beyond!!
July 14, 2011 at 6:51 am
Right you are, I did forget to change it to -2.
July 13, 2011 at 12:23 pm
Oops....differences between TSQL & SSRS expressions.
Here try this
--DateStart
=DATEADD("ww",-3,DATEADD("d",-(WeekDay(Today())) + 1, Today()))
--DateEnd
=DATEADD("ww",-3,DATEADD("d",-(WeekDay(Today())) + 1, Today()))
July 13, 2011 at 10:35 am
Using your SQL, in SSRS:
--DateStartSELECT DATEADD("ww", DATEDIFF("ww", 6, DATEADD("ww", -3, GETDATE())), 6)
--DateEnd
SELECT DATEADD("ww", DATEDIFF("ww", 6, DATEADD("ww", -2, GETDATE())), 6)
July 13, 2011 at 7:01 am
Thanks for the download, I have been struggling with understanding this topic for a while. I am sure this will help.
July 11, 2011 at 9:01 am
I would suggest that you run the report anyway and use the NoRowsMessage property to let everyone know there was nothing to report. There is always the question when...
July 11, 2011 at 7:18 am
Viewing 15 posts - 1,066 through 1,080 (of 2,278 total)