Skip to Content
0
Feb 24, 2011 at 09:28 AM

Breaks in Web Intelligence

28 Views

Hi

When I apply break in WEBI the table brekas vertically by giving the information one below the other. For example I have 3 fields like Country, Order ID, no. activity instances

when I apply break on country it shows the data like this

country 1:
order id   instances
1               23
2               43
3               45

country 2:
order id   instances
4               56
5               76
6               12

But since I have only two columns I dodn't want to waste the remaninng space in my report and i want the output like this

country 1:                                           country 2:
order id   instances                            order id   instances
1               23                                      4               56 
2               43                                      5               76
3               45                                      6               12

I tried using crosstab but since the orderids are not same for both the countries i'm getting blanks for the other countries and the output is like this

country 1:                                      country 2:
order id   instances                       order id   instances
1               23
2               43
3               45
                                                       4               56
                                                       5               76
                                                       6               12

The only way what I found was to place multiple blocks side by side and apply filter on each block. But by doing this the report needs manual work for every new country as the data is dynamic and the number of countris varies based on filter condition.

I want this format dynamically. Is there any option available for breaks to show the data side by side?

I appreciate your help!!!!!

Thanks

Raghavendra.G