I have a Crystal 10 report connecting to a Oracle 10 db.
When the selection criteria is set to below, the report pulls in the record fine:
({USERFIELD.USERFIELDPROFILE_ID} = 10059.00 and {USERFIELD.USERFIELDVALUE} = 'True')
and {MEMBER.RELATIONSHIPCLASS_ID} in [1020,1030] and
(day(currentdate) in 1 to 14 and
{MEMBER.STARTDATE} in dateserial(year(currentdate),month(currentdate)-1,15) to
dateserial(year(currentdate),month(currentdate),1)-1
or
day(currentdate) in 1 to 14 and
{MEMBER.ENDDATE} in dateserial(year(currentdate),month(currentdate)-1,15) to
dateserial(year(currentdate),month(currentdate),1)-1
) or
(
day(currentdate) >= 15 and
{MEMBER.STARTDATE} in date(year(currentdate),month(currentdate),1) to
date(year(currentdate),month(currentdate),14)
or
day(currentdate) >= 15 and
{MEMBER.ENDDATE} in date(year(currentdate),month(currentdate),1) to
date(year(currentdate),month(currentdate),14))
However when I place the top code in the bottom, it multiplies the record:
(day(currentdate) in 1 to 14 and
{MEMBER.STARTDATE} in dateserial(year(currentdate),month(currentdate)-1,15) to
dateserial(year(currentdate),month(currentdate),1)-1
or
day(currentdate) in 1 to 14 and
{MEMBER.ENDDATE} in dateserial(year(currentdate),month(currentdate)-1,15) to
dateserial(year(currentdate),month(currentdate),1)-1
) or
(
day(currentdate) >= 15 and
{MEMBER.STARTDATE} in date(year(currentdate),month(currentdate),1) to
date(year(currentdate),month(currentdate),14)
or
day(currentdate) >= 15 and
{MEMBER.ENDDATE} in date(year(currentdate),month(currentdate),1) to
date(year(currentdate),month(currentdate),14))
and ({USERFIELD.USERFIELDPROFILE_ID} = 10059.00 and {USERFIELD.USERFIELDVALUE} = 'True')
and {MEMBER.RELATIONSHIPCLASS_ID} in [1020,1030]
Trying to figure out why??
When the selection criteria is set to below, the report pulls in the record fine:
({USERFIELD.USERFIELDPROFILE_ID} = 10059.00 and {USERFIELD.USERFIELDVALUE} = 'True')
and {MEMBER.RELATIONSHIPCLASS_ID} in [1020,1030] and
(day(currentdate) in 1 to 14 and
{MEMBER.STARTDATE} in dateserial(year(currentdate),month(currentdate)-1,15) to
dateserial(year(currentdate),month(currentdate),1)-1
or
day(currentdate) in 1 to 14 and
{MEMBER.ENDDATE} in dateserial(year(currentdate),month(currentdate)-1,15) to
dateserial(year(currentdate),month(currentdate),1)-1
) or
(
day(currentdate) >= 15 and
{MEMBER.STARTDATE} in date(year(currentdate),month(currentdate),1) to
date(year(currentdate),month(currentdate),14)
or
day(currentdate) >= 15 and
{MEMBER.ENDDATE} in date(year(currentdate),month(currentdate),1) to
date(year(currentdate),month(currentdate),14))
However when I place the top code in the bottom, it multiplies the record:
(day(currentdate) in 1 to 14 and
{MEMBER.STARTDATE} in dateserial(year(currentdate),month(currentdate)-1,15) to
dateserial(year(currentdate),month(currentdate),1)-1
or
day(currentdate) in 1 to 14 and
{MEMBER.ENDDATE} in dateserial(year(currentdate),month(currentdate)-1,15) to
dateserial(year(currentdate),month(currentdate),1)-1
) or
(
day(currentdate) >= 15 and
{MEMBER.STARTDATE} in date(year(currentdate),month(currentdate),1) to
date(year(currentdate),month(currentdate),14)
or
day(currentdate) >= 15 and
{MEMBER.ENDDATE} in date(year(currentdate),month(currentdate),1) to
date(year(currentdate),month(currentdate),14))
and ({USERFIELD.USERFIELDPROFILE_ID} = 10059.00 and {USERFIELD.USERFIELDVALUE} = 'True')
and {MEMBER.RELATIONSHIPCLASS_ID} in [1020,1030]
Trying to figure out why??