hello every one , and happy Noel ,
Can you please help me to display list colonne depending on selected prompt :
For ex:In my liste I want to show just information related to a specific brand in a specific store : for example , if I select brand Nike / store X , I will show in my liste just information related to Nike in the store X.
Information shown for each brand are : price by type of clothes , nb of articles available ....
Thank you
Quote from: lahdeb on 27 Dec 2017 03:50:50 AM
hello every one , and happy Noel ,
Can you please help me to display list colonne depending on selected prompt :
For ex:In my liste I want to show just information related to a specific brand in a specific store : for example , if I select brand Nike / store X , I will show in my liste just information related to Nike in the store X.
Information shown for each brand are : price by type of clothes , nb of articles available ....
Thank you
How about this:
- create a prompt page with a prompt control for brand and another prompt control for store
- create a filter in your query for brand to show only what the user selected
- create another filter in your query for store to show only what the user selected
I wouldn't call this conditional display since it is just filtering a query to limit the result set. If I've misunderstood the requirement feel free to elaborate.
Thanks Lynn for your replay ,
The purpose is not to filter data ,it is about displaying or hiding list column , I m doing this with boolean Variabls , but I want to do better :)
Why is showing or hiding a column not a filter?
Invisi , Filter is for data , Variabls are for chart formas and conditional style :)
For me it's still limiting the result of data that you describe, so ultimately it's a filter.
QuoteFor me it's still limiting the result of data that you describe, so ultimately it's a filter.
No, Lahdeb is correct. A filter is reflected in the WHERE clause in the generated SQL, and therefore affects the returned result set.
Here, according to Lahdeb's second post, we're not talking about changing the result set. The requirement is to change the way in which the SAME result set is displayed in the report.
The original post sounded more like filtering but a subsequent post mentions showing or hiding list columns.
I didn't respond further because lahdeb indicated it is already resolved using Boolean variables. The comment "but I want to do it better" implies there is something wrong or less than ideal with the current approach but there is no further explanation of what the concern is. I tend to use Boolean variables in the render property for a list column. Job done.