01-03-2014 11:14 AM
Hi all,
i got a report as support issue and it looks like below
here, the 4th column is address of vendor which goes for 4 lines and remaining columns data donot repeat.
now when i add filter on the non repeating columns i am getting only the first line.
but i need to get the whole set of 4 lines of the vendor.
eg : if set filter on manufactur code as 91579 only 1st line is coming.
my requirement is to get the complete first 4 lines.
please help,
ujwal
01-03-2014 11:21 AM
hi,
do one thing what ever the field u r filtering make that field value also repeat along with the address lines, and try to use sort functionality on that column in the grid display then it will display single time only and if u go for filtering also it shows four line of address...
regards,
Siva
01-03-2014 11:44 AM
hi siva,
i suggested sort functionality but the business is not ok with it.
is there any other way
01-03-2014 11:28 AM
Hi ujwal,
Assign same value to all the manufacturer code.
Arivazhagan S
01-03-2014 1:03 PM
As suggested, standard solution is to have same values in every record of a same manufacturer and hide duplicate with sort option. Else you have to go to a long painly development handling event like AFTER_REFRESH and the like...
Else you could just deactivate filter options...
APPEND grid->mc_fc_filter TO gt_toolbar_excluding.
APPEND grid->mc_fc_delete_filter TO gt_toolbar_excluding.
Regards,
Raymond