Conditional Grouping

Hi,
I want to create a report and do some grouping based on some condition.
my senario is like this
I have a column test which has couple of "x" values and couple of "y" values. I want to group on test cololum. I want to display
row["test"]="x" values in one column
row["test"]="y" values in another column.

Please let me know how can I do it.

Thanks in advance for any help.

Thanks,
Sekhar.

Find more posts tagged with

Comments

mwilliams

Hi Sekhar,

You want to group the table based off of a column? Or you want them to be in parallel columns separated by the value of that column?

ssekhar

Hi Michael,

I want them to be in parallel columns separated by the value of that column.

like this
test test
x y
x y
x y
x y

Thanks,
Sekhar.

mwilliams

Sekhar,

All you'd need to do then would be to set up a 1 row, 2 column grid. Put a table in each grid with 1 column and 1 detail row. Put the test data element in the detail row in each table and put a filter on each table that was something like:

row["test"] equal to "x" in one table

-AND-

row["test"] equal to "y" in the other

Hope this helps.

ssekhar

Hi Michael,
Thanks for your reply. where can I add filter in the table. I added a filter in Editdatabinding., but still I see all the results.

Please let me know how can I do this.

Thanks,
Sekhar.

mwilliams

Sekhar,

If you select the entire table and go down to the property editor, you'll see a filter tab. That's where you would put the filter on each table.

Susmitha

Thanks very much Michael. That solved my problem.

You guys are doing great job!

Thanks,
Sekhar.