[RESOLVED] Can I create a variable number of tables based on a parameter

[FunkyDexter]

I have a report designed in VS 2005 which shows summarised data for a week. I've just been asked if I can add a parameter to it so the user can specify the number of weeks they want to display. The report will then need to show a separate table for each individual week (ie the same result as running the existing report several times).

Is there a way I can achieve this? I can't see where I'd even start to resolve this.

[brucevde]

I don't use VS 2005 but wouldn't you just group the report by week.

For example, in Crystal Reports, I would simply add a Group on a date field and set the option "for each week". The Record Selection Formula would include code to select data based on a start and end date. The end date could be user supplied or calculated ie Start Date + Total Number of Weeks.

[FunkyDexter]

Hi Bruce, thanks for the response.

I just managed to find a grouping option (though it's a bit tricky to find, it's not under the main properties). I'll have a play and see if I can get it working. Thanks for the hint, I think it pointed me in the right direction.


edit> Yep this is working a treat. Thanks Bruce.