Skip to Content
0
Former Member
Nov 21, 2013 at 10:08 AM

Composite Expression

188 Views

Hello,

Within a sub-report in CR11 I am trying to produce a report that I need to use the select expert to use two separate date ranges as below

{CnGf_1.CnGf_1_Date} in DateTime (2013, 04, 02, 00, 00, 00) to DateTime (2013, 06, 30, 00, 00, 00) and

{CnGf_1Ins_1.CnGf_1Ins_1_Date} in DateTime (2013, 04, 02, 00, 00, 00) to DateTime (2013, 06, 12, 00, 00, 00)

but what I really need to do is something like this

{CnGf_1.CnGf_1_Amount} >= $5000.00 and

{CnGf_1.CnGf_1_Date} in DateTime (2013, 04, 02, 00, 00, 00) to DateTime (2013, 06, 30, 00, 00, 00) or

{CnGf_1Ins_1.CnGf_1Ins_1_Date} in DateTime (2013, 04, 02, 00, 00, 00) to DateTime (2013, 06, 12, 00, 00, 00)

which is only changing the 'and' operator to an 'or' but when I do this I get the message 'Composite expression'.

Can anyone help me please????