Skip to Content
0
Former Member
Apr 07, 2015 at 09:44 AM

URGENT:Displaying only data with multiple line items

14 Views

Hi ,

I have the below scenario and need to address 2 requirements

STATE VENDOR VENDOR NAME ROUTE S1 V1 ROUTE VENDOR R1 S2 V1 ROUTE VENDOR R1 R2 R3 S2 V2 O'BRIEN TRANSPORT SERVICES PTY LTD R4 S2 V3 Yorkie Bar Trucks R1

I need to display '*' in case of multiple route for a State - Vendor combination.Example screen shot as below:

STATE VENDOR VENDOR NAME ROUTE S2 V1 ROUTE VENDOR *

Also need a separate report which will display only the details of multiple routes.Example screen shot as below:

STATE VENDOR VENDOR NAME ROUTE S2 V1 ROUTE VENDOR R1 R2 R3

Please let me know if the above could be achieved in BEx Query???? If not is it possible in BO WebI report?

Regards,

AR