weekly / monthly / seasonly figures

[rprameshwor]

I have to display the sales figure  of current year to date.

The requirement is to provide the user with the option to display the list weekly/monthly/seasonly  and then display the list  month by month  OR week by week OR season by season from the beginning of this year to current day.

                            week1   week2  week3. ...... <curr week>
sales quantity

sales unit


                            January   February March. ...... <curr month>
sales quantity

sales unit


                            Season1   Season2 <curr season>
sales quantity

sales unit

One Approach could be using CONDITIONAL BLOCKS to prepare individual report and then display them according to the answer provided by the user through the static value prompt.
But i guess through this approach all the blocks are computed but just one of them is displayed. 

if the user inputs 'season' through the value prompt , why should we waste time calculating weekly or monthly data .
Is there any other / better approach to doing this ?

[blom0344]

With 3 seperate queries, only the query that is used to display data will be fired. That is pretty economical..

[rprameshwor]

blom0344 : Didnt get it  , would you mind elaborating a little Please

[cognostechie]

If you create 3 seperate pages (one for Monthly, one for Weekly and one for by Season) and use a Render variable then only that page will be rendered that needs to run based on what is selected from the prompt. 

[rprameshwor]

Thanks Guyz !! Worked :)