How to suppress detail lines in Web Intelligence report

building reports webintelligence
1

Please tell me how to suppress detail data shown in a Summary report. I have a Summary report which was converted from BO 5.1 to XI WebI through the XI Conversion tool, but it has been converted with showing detail lines of data along with the sum amounts. :hb:

Thanks in advance for your help.

Kxh0 (BOB member since 2006-04-21)

2

Could you send us a screenshot of what you have and what you want

  • if possible the “structure view”

Thanks

superoliv :fr: (BOB member since 2008-06-17)

3

The structure of the Summary report is as follows:

A | Queue | Nbr of PO | Cost | Ln Amt

=[A] | =QName | =[Nbr of PO] | =Sum([Cost]) | =Sum([Ln Amt])
| =QName | =[Nbr of PO] | =Sum([Cost]) | =Sum([Ln Amt])
Total: | | =[Nbr of PO] | =Sum([Cost]) | =Sum([Ln Amt])

ALL | || =[Nbr of PO] | =Sum([Cost]) | =Sum([Ln Amt])

The report shows

A               Queue          Nbr of PO         Cost             Ln Amt

Not Assigned ADD ASSET
ADD ASSET 1 $100.00 $100.00
Not Assigned Costed
Not Assigned
Not Assigned
Not Assigned
Not Assigned
Costed 2 $358.28 $310.14
Total: 3 $458.28 $410.14

   AB           ADD ASSET
                      ADD ASSET       1          $200.00          $500.00
   BA           Costed 
   BA 
   BA
   BA 
                  Costed                  1          $200.00          $500.00   
  Total:                                    1          $200.00          $500.00
   ALL                                      4          $658.28          $910.14

Thanks,

Kxh0 (BOB member since 2006-04-21)

4

Please see the attached.

Thanks,
The structure of the Summary report is as follows.doc (23.0 KB)

Kxh0 (BOB member since 2006-04-21)

5

i would imagine this is tied to the original report having folds which is not supported in Webi. You should be able to accomplish the same thing with the proper calulation contexts.

maverick976 :us: (BOB member since 2004-07-06)