January 7, 2008 at 6:26 am
Hi there
The user can choose a week as parameter (e.g. week 52).
I show some results of this week, using several datasets, but I'm using those datasets also to show some month results in another table on the same report.
How can I do this ? Do I use a function to calculate a month variable ?
Kind regards
El Jefe
JV
January 7, 2008 at 7:09 am
Regarding Week ...
Keep in mind MS starts week 1 on january 01.
Maybe that's not the weeknumber your company uses.
In my case week 01 is the week containing january 04 !
We have UDF's to determine our weeknumber and the weekranges for that weeknumber.
e.g. :
SELECT [master].[dbo].[fn_ALZDBA_convert_date2WeekALZ] ('2006-01-01') as alzdbaWeek
, datepart(wk,'2006-01-01') as MSWeek
Result:
alzdbaWeek MSWeek
----------- -----------
200552 1
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply