PageSet Causing Multiple Database hit

[stapas]

Hi All,

I have a report which uses SQL Tabular query item. The report has a prompt for 'region'. The report has a pageset on region_code so that when running the report in excel the output is generated in different sheets (one excel sheet per region). The problem is when user is selecting more than one 'region' in the prompt (say 5), the cognos is hitting the database 5 times with all region_code in the where condition.

Any idea what I'm doing wrong.

Thanks
Tapas