Hi,
I am new to QReport Builder. I hope I am submitting my question properly. I am trying to write a report to filter out records of customers by a custom date field and an interval (annual, semi, monthly). The problem I have is that the conditions will work fine with partial code but if I add all the code I get a random meaningless error code. I have tried shortening the code as much as possible with shorter field names , is there a limit on the number of characters I can use in a filter expression?
Here is the code.....
(Customertypereffullname = "AFA")
.AND.
(
(dte = month(:reportpmpt))
.OR.
(Customfieldprvinterval = "MONTHLY")
.OR.
(
(Customfieldprvinterval = "SEMI")
.AND.
(
(dte = month(:reportpmpt) + 6)
.OR.
(dte = month(:reportpmpt) - 6)
))
.OR.
(
(Customfieldprvinterval = "BIMONTHLY")
.AND.
(
(dte = month(:reportpmpt) + 2)
.OR.
(dte = month(:reportpmpt) - 2)
.OR.
(dte = month(:reportpmpt) + 4)
.OR.
(dte = month(:reportpmpt) - 4)
.OR.
(dte = month(:reportpmpt) + 6)
.OR.
(dte = month(:reportpmpt) - 6)
.OR.
(dte = month(:reportpmpt) + 8)
.OR.
(dte = month(:reportpmpt) - 8)
.OR.
(dte = month(:reportpmpt) + 10)
.OR.
(dte = month(:reportpmpt) - 10)
)
)
.OR.
(
(Customfieldprvinterval = "QUARTERLY")
.AND.
(
(dte = month(:reportpmpt) + 3)
.OR.
(dte = month(:reportpmpt) + 6)
.OR.
(dte = month(:reportpmpt) + 9)
.OR.
(dte = month(:reportpmpt) - 3)
.OR.
(dte = month(:reportpmpt) - 6)
.OR.
(dte = month(:reportpmpt) - 9)
)
)
)
I am new to QReport Builder. I hope I am submitting my question properly. I am trying to write a report to filter out records of customers by a custom date field and an interval (annual, semi, monthly). The problem I have is that the conditions will work fine with partial code but if I add all the code I get a random meaningless error code. I have tried shortening the code as much as possible with shorter field names , is there a limit on the number of characters I can use in a filter expression?
Here is the code.....
(Customertypereffullname = "AFA")
.AND.
(
(dte = month(:reportpmpt))
.OR.
(Customfieldprvinterval = "MONTHLY")
.OR.
(
(Customfieldprvinterval = "SEMI")
.AND.
(
(dte = month(:reportpmpt) + 6)
.OR.
(dte = month(:reportpmpt) - 6)
))
.OR.
(
(Customfieldprvinterval = "BIMONTHLY")
.AND.
(
(dte = month(:reportpmpt) + 2)
.OR.
(dte = month(:reportpmpt) - 2)
.OR.
(dte = month(:reportpmpt) + 4)
.OR.
(dte = month(:reportpmpt) - 4)
.OR.
(dte = month(:reportpmpt) + 6)
.OR.
(dte = month(:reportpmpt) - 6)
.OR.
(dte = month(:reportpmpt) + 8)
.OR.
(dte = month(:reportpmpt) - 8)
.OR.
(dte = month(:reportpmpt) + 10)
.OR.
(dte = month(:reportpmpt) - 10)
)
)
.OR.
(
(Customfieldprvinterval = "QUARTERLY")
.AND.
(
(dte = month(:reportpmpt) + 3)
.OR.
(dte = month(:reportpmpt) + 6)
.OR.
(dte = month(:reportpmpt) + 9)
.OR.
(dte = month(:reportpmpt) - 3)
.OR.
(dte = month(:reportpmpt) - 6)
.OR.
(dte = month(:reportpmpt) - 9)
)
)
)
Comment