Skip to Content
avatar image
Former Member

with three different objects in one Section with in one report is it possible?

Hi my dear friends,  Good morning

I'm using BO 4.1 sp 6

I needed some help from you could you please .........

here is that table contains ....

Date         Batch NO   Customer account No   amount of check     amount  

01/01/04    5678           123456                         $300                    $ 500

This report contains three different structures based up on user selection Section

system Name , Batch NO, Company code Used in Section

query filters and column are same for all above three structures in query filters all are optional prompts

currently i've created three tabs for three structures but due to optional prompts based upon selection data is fetching for all three tabs ...

is it possible to restrict ?

can i merge these three tabs into one tab ?

query filters are          user selection for System name in Section

class name                     class name :suspense

class type                       Date :

system name :           User selection for Company Code in Section

Date :                              Class Name : Suspense , Class Type : Rejected , System name : Mars , Date :

Company code :          User selection for Batch No In Section

                                 Class Name : Suspense , Class Type : Rejected , System name : Mars , Date :   

End user front end application is Java

Thanks

Ravi Kumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 16, 2014 at 07:43 AM

    hi friends,

    Hi hesters thanks for your help it is helpful but my requirement is not met with that.

    i've got answer

    create condition @ universe level

    with

    'System Name'= @Prompt("Subtotal By','A',{'system Name','Batch No','Company Code'},mono,Persistent,)


    need to create for what are the objects we are using in section

    and create userresponse @ report level

    if(Userresponse("Subtotal By") then [System Name] ......

    you will get it...........

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 15, 2014 at 08:02 AM

    Hi,

    You could use dynamic visibilty to show the view(table) you want in one tab.  Check out document

    Dynamic Visibility within a Webi Report

    I hope it helps you.

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded