prompts

[sspk]

Hi All,
I am trying to generate a report in which there are data-items like year_qtr, state,zip,reg_no...i want a prompt like if i select year_qtr, it should display the zipcodes (these zip's may change from qtr 2 qtr)in that particular year_qtr.Any suggestions

[Suraj]

If you filter the query for the selected year_qtr, it'll only show zip code for that qtr.
If your objective is to get data for all zip codes but display zip code for selected qtr then you have to get zip code separately from a different query and do a join for reporting.

[almeids]

Or if you are trying to provide prompt selection of zip codes for a particular year_qtr use cascading prompt, see documentation