Hi Gurus,
I have a requirement where I need to create a drop down menu which contains the divisions of a firm. Based on the selection of the division, a chart which shows the aggregate sales should be populated. Initially (When no selection is made) the graph should show aggregate value of all the divisions.
How can this be achieved?
Unless I am not understanding your requirement correctly, I believe you can do the following:
- Add a Value Prompt and a Prompt Finish Button to your Report Page (not the Prompt Page)
- Make the Prompt Required = No
- Make the Filter in your Query be Optional
This should first run the Page for all (as there should be no selections for the initial page display), and then give you the ability to re-run by selecting Divisions if you so wish by clicking on the created Prompt Finish Button.
Hope this helps.
Adam.