data retrieval
Hi all....
I have a query while making some modifications to my existing report
My requirement is:
1. Have the stored procedure (with @year and @weekno parameters) to display weekly wise report for 52 weeks
2. When I run my report it has to display the current and previous week details only.
3. Once it is loaded, user should have the flexible to select the week number from drop-down menu which ever he/she wants
4. As per their selection report has to be displayed as well as previous week data also has to be fetched. (for example: if a user selects week number 35 from drop down menu then 35 week report as well as 34 week report has to be displayed)
5. I hope u all got my point, suggest the way to sort out this one
1 reply
-
Use Formulate to calculate current and previous week values based on a parameter of week number.
Show these in your report.
Select "Last" as the default wee number. this will default to the last (current) week.
Parameter will display automatically to allow the user to select the week they want.
Thread closed.