Skip to Content
0

Issue with refreshing listbox with prompts

Jan 31, 2017 at 02:21 PM

70

avatar image

Hi,

I created report where I have prompts, crosstable and listbox. When I selected value in prompt , crosstable refreshed but listbox shows all values. How can I show only associated value in Listbox?

My Data Source is Bex query and in Bex query I checked posted value and only posted values for navigation.

Best Regards,

Magda

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Dwain Chang Jan 31, 2017 at 02:52 PM
0

Hi,

did you use the data binding option in the listbox? and is the data source that fills the listbox also being filtered by the variable?

Share
10 |10000 characters needed characters left characters exceeded
Mustafa Bensan Jan 31, 2017 at 02:54 PM
0

Hi Magda,

The important point to be aware of in your scenario is that the Crosstab is populated by the data source result set, which is influenced by the prompt but the listbox is populated based on master data which is not influenced by the prompt. Hence the outcome you have experienced is expected.

How are you populating the listbox by the way, via scripting or by direct binding to the data source?

Can you explain why you need the dimension members displayed in a listbox if you are using a prompt for filtering?

Regards,

Mustafa.

Share
10 |10000 characters needed characters left characters exceeded
Tomasz Koziol Jan 31, 2017 at 03:39 PM
0

Dear Mustafa,

I had the same problem and I added datasource by direct binding and via scripting and it is not work...for example filter line works properly but components from basic not work.

Dimesion members are displated at listbox because user needs that filter to analyze.

KD,

Tomasz

Share
10 |10000 characters needed characters left characters exceeded
Magdalena Walentek Feb 01, 2017 at 07:21 AM
0

Hi,

I used direct binding in the listbox and via scripting too, both way don't work. I need associated dimensions members in the listbox becouse in the prompts the user, for example can filter the field YearMonth but he don't have to filter the field Projects, and than he needs the listbox Projects in the layout.

BR,

Magda

Share
10 |10000 characters needed characters left characters exceeded