I have variable on expirydate (zv_calm), i need out put for quantity greater than zv_calm(expirydate), Expiry date is '000000',in single column i should disply both,how to do this? plshelp me.
If your requirement is showing the quantity for records having expirydate > zv_Calm or exprirydate = '000000' then you can restrict quantity key figure as
What Suman told is right if you want to restrict out put of that KF only if you follow what i told it will restrict the output of all the KF in the Query.
I assume that you want the Variable of Expiry date with selection Greater than or Equal to so that all the materials with that expiry date will be displayed in the report along with the expiry date.
Please go to the query designer and in the filter pane select the ZV_CALM and right click and select filter and in the pop up box select Value ranges in that select GT or Equal to option and in the below dropdown select on the F4 value button you will get another pop up their by default it will be history click on the drop down box you will get variables select the required variable you will get the option what you are looking for.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.