Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajeshforum
Starting Member
3 Posts |
 Posted - 2008-03-04 : 00:21:11
|
| Hi all, I need to generate a report based on week.The input params are startweek(1 to 53) and endweek(1 to 53).I have already created a report in common but in that i should include this functonality.for ex, if i give 1 and 5 then it should generate week1 week2 ....week5 in existing output.thanks in advance,rajesh grajesh |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-04 : 06:08:31
|
| Are you using reporting services? if yes, you can use matrix functionality to create this cross tab report.Just give column group as weeknumber of datefield value (use DATEPART function to get this). |
 |
|
|
|
|
|
to generate week based report