Skip to Content
0
Former Member
Jun 02, 2008 at 09:16 PM

Urgent : grouping in front end

29 Views

Hi Friends,

I have a requirement in which I need to group the Vendors into Required and Not Required based on the Vendor group. All Vendors given in selection must fall under REQUIRED and the rest all group under NOTREQUIRED . This needs to be done in frontend, that is report.

Suppose the data in cube is as

Vendor......Vendor Group.....Matl Qty

ABC..............11..................100

BBD..............13..................500

HHY..............12..................300

AAA..............44..................200

In Selection (Vendor Group=11,13)

Report should be

Grouping......................Matl Qty

REQUIRED

ABC..............11..................100

BBD..............13..................500

NOTREQUIRED

HHY..............12..................300

AAA..............44..................200

In this the end user need to get the selection

where he need to select the required group number....

so in the report the required groups must fall under REQUIRED

and the rest of all must come under NOTREQUIRED.

please through some light ...

Regrads

Sandy