Sections Issue

building reports webintelligence
1

Hi All,

I have an issue with the section.I have the following condition in my section

If(Match([Car Code];“V*”) And [Rate] = 0 ;“cars”;if(Match([Car Code];“V*”) And [Rate] > 0;“cars-fast”; “bus”)

now my sections are like

cars
vallue = 1000

cars-fast
value = 500

bus
value = 800

but i want my section to show as follows

my condition is – but doesnt work

( If(Match([Car Code];“V*”) ;“cars”;if(Match([Car Code];“V*”) And [Rate] > 0;“cars-fast”; “bus”)

cars
value = 1500 --------(this should have total value for all cars)

cars-fast
value = 500 ----------(this is the subset of cars with condition rate >0)

bus
value = 800

please correct me if im doing something wrong. any advice would be appreciated. Thanks in advance

kingbutnothing :india: (BOB member since 2007-01-12)

2

Kumar,

I don’t see anything wrong with your syntax, but not having visibility to your data values it’s hard to determine further what might be going wrong. For instance, you have with your match() function to test if [car code] begins with a “V” (denoted by “V*”), but what if there is a leading space in the data, or something else that you are not expecting?

Your final example where you want to get a subset of cars with condition rate >0, is probably not going to work the way you’re thinking unless you add a second grid to your report. The reason is that as the report processes, it can only deal with a row (or aggregation) once, hence once a record passes through as true (a hit) then work is done and output is displayed. The report processor cannot regurgitate the record again to do something else for you (at least not with the basic functionality offered in WebI). You would have to set up “hold” registers, comparators, and more breaks, all of which I don’t think you’ll be able to do in WebI. An alternative that I’ve done from time to time is to put another block side-by-side to the first block to “simulate” this second sub-handling. Good luck with your report.

Thanks,
John

jsanzone :us: (BOB member since 2006-09-12)

3

thank you John, As of now that is how im displaying my data. But i wanted to see if any of the BO gurus have any work around for this issue. Anyway that advice helped me a lot. thanks once again

kingbutnothing :india: (BOB member since 2007-01-12)

4

A good explanation by jsanzone… 8) .

I think what you are trying to acieve is similar to a two phase calcuation which you can’t do in Business Objects…

Mak 1 :uk: (BOB member since 2005-01-06)