Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to Add a filter for: Margin > X and Margin < X
In script, use IF clause.
If you have a field "MARGIN", just put in a list box which you can use as a filter.
Regards,
sebablum
How can I provide range? and how do i pass it to report?
Do you have the margin in your data or is it a scripting matter? If you send a qvw-file it will be much easier to understand your needs.
Margin needs to be calculated as
Revenue - Cost
In the load script, you can use
Revenue - Cost AS Margin;
Then you get the margin as a field. Pls find attached a QVW showing use of the listbox (Margin is generated as load inline in the example).
/sebablum
How can I provide range? Less than greater than range?
Just mark more than 1 value in the list box by CTRL + click. If this is not what you want to know, I do not understand your problem, I am afraid. If this is the case, please describe your problem and attach an application showing its core.
If you have your margin in a field, then you can write a search string '>100<500' (without the quotes) which will give you the range 100-500.
User will input Margin range like From = 100 and To = 500
Report data will be filtered for this range.
So the value 100, 500 is not hard coded and is based on user input.
any ideas how i can achieve this?
.png "Former Employee"){kind=icon}