How to display all columns of a Query in WAD?

[Former Member]

I'm showing results from a query with 3 optional filters on a WAD table.

I've notice that not all the columns are displayed on the Table

For Example, this is my table:

Column1     Column2     Column3

a                    0001            0001

b                    0001            0002

a                    0002            0003

b                    0002            0004

When I filter by Column 2 (value 0002) this is the display result

Column1     Column3

c                    0003

d                    0004

When I filter by Column 1 (value a) this is the display result

Column2     Column3

    0001            0001

    0002            0003

How can get all the columns displayed like this? (if filtering by 'a'):

Column1     Column2     Column3

a                    0001            0001

a                    0002            0003

[Former Member]

are you using left pane (rows or columns) to filter or are you using keep filter values? If you use keep filter values then it removes that column from report...Instead use left pane and "select filter values"