01-07-2008 3:44 PM
Hello All,
I am displaying a query through SQ01, it is as any ALV report, there are a few controls on top of the list one of them is filter and thats where I have the question.
I have a list like this as output of the program:
Status Hours Name
True 0 John
True 1 Joe
False 0 Smith
True 1 Scott
False 1 Cindy
Now, do not want to show the records that have (Status = False and Hours = 0), Which will remove the 3rd record from the display.
How can this be accomplished through the FILTER icon?
Again, this is not a custom program so I cannot simply add this condition inside ABAP, I have to do something through toolbar icons.
I have tried different options in FILTER but it is not putting an "AND" logical condition between the two.
Thanks a lot!
01-07-2008 4:20 PM
You need to set two filters to achieve this functionality.
One for the Status and Second for the Hours.
Press the Filter Icon.
Select both fields from the right side and move it to left side by pressing the left arrow button. Press Enter
In the next screen, use the F4 for avaliable values and select FALSE for the status and 0 for the Hours.
You can save this setting in one Layout variant and use that for future use to avoid setting filter everytime you run the report.
Regards,
Naimesh Patel
01-07-2008 4:20 PM
You need to set two filters to achieve this functionality.
One for the Status and Second for the Hours.
Press the Filter Icon.
Select both fields from the right side and move it to left side by pressing the left arrow button. Press Enter
In the next screen, use the F4 for avaliable values and select FALSE for the status and 0 for the Hours.
You can save this setting in one Layout variant and use that for future use to avoid setting filter everytime you run the report.
Regards,
Naimesh Patel
01-07-2008 4:36 PM
Thanks for your reply, but it does not put an "AND" condition between the two fields. It will suppress all fields that are False and all fields that are 0.
01-31-2008 2:59 PM
Create a local field in SQ01, and build a formula to output 1 or 0 based on your condition then at the report output level you can suppress rows with 1s or 0s using filter.