Report Page Prompt Filter Issue

[nsaxena]

Hi All ,

My requirement is : We have one table emp ,which i am taking into report studio via sql connection like select * from emp .
Now from that two table we have to generate 2 crosstab charts. One chart is will show emp count based on country and other will show emp count based on state.When user will run the report he will see in single page two crosstabs without filters. In report page we will show 2 prompts..dropdown type..one country and other for state.Now if user select any one country then crosstab for that only should get filter ,other crostab which is showing emp# state wise should still show all data.And if user select state only data forthat crosstab should change and country crosstab should show all data.

I have created 2 prompt queries(q_country,q_state),one will fetch country via sql from same table(with different name),and other will fetch state.

So i have created two queries used for crosstabs query1 and query2 with same query items but different optional filter ,with one having prompt filter for country(country=?p_country? and state=?p_state?.

In report page i have created two crosstabs for each query (query 1 and query 2) .Then created two value prompts in report page and assign them to the existing prompts ?p_country? and ?p_state? .Then drag a finish prompt button below that.

Issue : When i am running report first time,i am seeing data in both crosstabs without filter and this is fine. But when i am selecting country from dropdown and then clicking finish button,i am expecting data change only for crosstab which has filter for country and other crosstab data should be unchanged. But data for other crosstab is also changing.

Please suggest what i am doing wrong ,or any better way to achieve requirement.

Many thanks in advance! I have to deliver report very soon so need badly help on this.




Then in report page i created two value prompt and assign one

[nsaxena]

Hi All ,

Additionally my client wants requirement lke this only.He does not want page rendering with each crosstab on different page.

[bdbits]

It seems like you set things up correctly. Could you attach a copy of the report spec? Maybe I can spot something if I can open the report.

[nsaxena]

Hi All ,

I figure out the bug..i was using the java scripting for prompts in report page,the purpose of script was to rename the drop down prompt to defined name...i removed that and issue was fixed..so you were right..approach was right...but not sure why this script was caussing issue...