Skip to Content
avatar image
Former Member

Web Intelligence Dynamic Table

I have a query that returns 2 columns of data Category and Item.

Fruit | Grapes
Fruit | Apples
Fruit | Lemons
Fruit | Strawberries
Fruit | Oranges
Fruit | Bananas
Fruit | Cherries
Fruit | Mangos
Vegetables | Beets
Vegetables | Cabbage
Vegetables | Carrots
Vegetables | Celery
Vegetables | Lettuce
Vegetables | Onions
Other Stuff | Oatmeal
Other Stuff | Bread
Other Stuff | Chocolate
Other Stuff | Popsicles
Other Stuff | Meat
Other Stuff | Yogurt
Other Stuff | Popcorn

I need to create a table in Business Objects Web Intelligence 4.1 SP7 that will display the CATEGORY as a column and then display all of the ITEMs for each CATEGORY under it. i.e.:

Fruit | Vegetables | Other Stuff
Grapes | Beets | Oatmeal
Apples | Cabbage | Bread
Lemons | Carrots | Chocolate
Strawberries | Celery | Popsicles
Oranges | Lettuce | Meat
Bananas | Onions | Yogurt
Cherries | | Popcorn
Mangos | |

Is this possible? If so, what do I need to do to achieve this result in the report?
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 21, 2018 at 04:32 PM

    Hi Christopher,

    The way you want to represent the data i think it is not possible but you can try try break or section that will help to achieve the requirement which will near to your result set.



    Add comment
    10|10000 characters needed characters exceeded

  • Feb 22, 2018 at 11:26 AM

    This is the closest i could get to your requirement. I used crosstab to do this.

    Add comment
    10|10000 characters needed characters exceeded