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 ?
With 3 seperate queries, only the query that is used to display data will be fired. That is pretty economical..
blom0344 : Didnt get it , would you mind elaborating a little Please
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.
Thanks Guyz !! Worked :)