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

[saikumar1]

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

[saikumar1 · Accepted solution]

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...........

[kohesco]

Hi,

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

I hope it helps you.

Grtz

Koen