Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have aproblem and I hope you can help me ..
I am goingto make a report that shows ALL active orderlines plus orderlines ended in a specific(Selected)period.
The following fields are being used: ItemNo, Status, EndDate
Status canbe either Active or Ended. EndDate can be actual enddate OR if status = ActiveEndDate = Today
Does myquestion make any sence ?
Maybe you could use something like
=only({<Status={Active},EndMonth=>+<EndMonth=EndMonth>} EndDate)
as additional expression (which could be hidden in presentation tab) in a straight table, if you select in EndMonth as your relevant period.
See also attached.
Stefan
Hi,
please upload a short example *.qvw we can work with.
Thank you!
Rainer
Hi.
You can combine set analysis to do a OR in the set analysis clause. You can read the Help (search Set Analysis), some examples are provided.
Hi,
Here's an example.
What i would like is that if i select "jan" in month, item 1001 should appear since its still active.
So the result would be:
Item | Status | EndDate |
---|---|---|
1001 | Active | 08-02-2012 |
1003 | Ended | 31-01-2012 |
Maybe you could use something like
=only({<Status={Active},EndMonth=>+<EndMonth=EndMonth>} EndDate)
as additional expression (which could be hidden in presentation tab) in a straight table, if you select in EndMonth as your relevant period.
See also attached.
Stefan
Just what i needed.
Thanks a lot!!