Is this possible in Business Objects?

Hi

Can i have a prompt like Employee Name and Role Name (stored in different tables but both these tables are joined) and when user select particular employee name for specific role name…role id(stored in same table where role name is stored) should be passed to SQL query?

Please advise.

Thanks in advance
.
Regards
KRG


krgodbole (BOB member since 2003-02-24)

I think you’ve asked it before. Unfortunately, you can’t do this directly. You can get close using hierarchical LOVs.


Steve Krandel :us: (BOB member since 2002-06-25)

Can you please brief how we can achieve using hierarchical LOV?

Thanks


krgodbole (BOB member since 2003-02-24)

See below posts:

https://bobj-board.org/t/15526

https://bobj-board.org/t/16694


JaiGupta (BOB member since 2002-09-12)

Thanks. I gone through both these posts. It explain how to impelment hierarchical LOV and it also works for me.

But my issue is for hierarchical LOV

Role Id ->Employee Name->Role Name

i want to pass Role Id to Report SQL. But in Prompt LOV it should display

Employee Name->Role Name

Is this possible?

Thanks

KRG


krgodbole (BOB member since 2003-02-24)

No. The value selected has to be displayed in the LOV.


Dave Rathbun :us: (BOB member since 2002-06-06)