ListBoxes : Populate from values of a column

Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have a scenario where the filters in my report are to be created as List Boxes, which are actually values in one column .

Example:

A table say Fruits has the below columns

Attribute , Value

Season, Summer

Season, Winter

Season, Spring

Color, Red

Color, Green

Color, Yellow

Along with these two columns, there are other columns which may tell the fruit name its description etc.

Now, we want to show the dimension as Color & Season

So Select distinct value where attribute =’Season’ is our Dimension1

Select distinct value where attribute =’Color’ is our Dimension2

What is the best way to achieve this?

Thanks,

Re: ListBoxes : Populate from values of a column

Anil_Babu_Samineni — Wed, 05 Apr 2017 16:35:11 GMT

How you want to get in output

MarcoWedel — Thu, 06 Apr 2017 05:54:08 GMT

Search for "generic load"