I have a formula that is designed to place a 0 or a 1 in a column:
if (({Query.STRTDATE}) < Date({?Year of Query},{?Month Of Query},01)) AND (({Query.INACTIVE}=0) OR (({Query.INACTIVE}=1) AND ({Query.DEMPINAC}>=Date({?Year of Query},{?Month Of Query},01))) )then 1
This works as I want in a report based on an ODBC Data source. However when I use this exact formula in a report that has a Crystal SQL Query (.qry) as it's source, the value of the {Query.INACTIVE} field is actually changed. Why? I have not discovered a pattern in the values placed in the field, but they are in the hundreds of thousands-millions range. In the database and if I just pull the Query itself the values are only 1 or 0.
Why is it doing this and what am I doing wrong?
Thanks!
Douglas Genne
Palm Management Corporation
if (({Query.STRTDATE}) < Date({?Year of Query},{?Month Of Query},01)) AND (({Query.INACTIVE}=0) OR (({Query.INACTIVE}=1) AND ({Query.DEMPINAC}>=Date({?Year of Query},{?Month Of Query},01))) )then 1
This works as I want in a report based on an ODBC Data source. However when I use this exact formula in a report that has a Crystal SQL Query (.qry) as it's source, the value of the {Query.INACTIVE} field is actually changed. Why? I have not discovered a pattern in the values placed in the field, but they are in the hundreds of thousands-millions range. In the database and if I just pull the Query itself the values are only 1 or 0.
Why is it doing this and what am I doing wrong?
Thanks!
Douglas Genne
Palm Management Corporation