BIZZARE issue with a simple Label report

[WestView]

I’m experiencing a BIZZARE issue with a simple Label report

I’m using the following formula to get the names & address for the labels:

{Name.FIRST_NAME} & " " & {Name.LAST_NAME} & Chr(13) &

If IsNull({Name_Address.ADDRESS_2}) Or {Name_Address.ADDRESS_2} = "" Then {Name_Address.ADDRESS_1} & Chr(13) &
{Name_Address.CITY} & " " & {Name_Address.STATE_PROVINCE} & " " & {Name_Address.ZIP} & Chr(13) &
{Name_Address.COUNTRY} Else

{Name_Address.ADDRESS_1} & Chr(13) & {Name_Address.ADDRESS_2} & Chr(13) &
{Name_Address.CITY} & " " & {Name_Address.STATE_PROVINCE} & " " & {Name_Address.ZIP} & Chr(13) &
{Name_Address.COUNTRY}

So far, so good.

I created a date (range) parameter. When I impose a date range parameter – 12/01/2004 to 12/09/2004 – No problem.

However, when I try to run the report with a single date parameter – say, just those records created today – it returns NO DATA! I know there is data in the tables.

What’s the dillio?

Any/all help greatly appreciated

Thanks,

- Tom

 

[dgillz]

Please post your record selection formula.



Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[WestView]

Hi dgillz,

Thank you for your reply. Here is my record selection formula (he date parameter is a range):

{table.DATE_FIELD} = {?Request_Date} and
{table.TOGGLE_FIELD} = True


Thanks again!

- Tom

 

[scottostanek]

Try this
{table.DATE_FIELD} in {?Request_Date} and
{table.TOGGLE_FIELD} = True


Scotto the Unwise

 

[WestView]

Hi scottostanek,

Thank you for your reply!

I tried that previously (I should have posted that). However, I seemed to have stumbled on a solution - of sorts.

Even though the Date field IS a date field (not a DateTime field) in the SQL2K database I tried this and it seems to work - but much more slowly:

DateTime({table.DATE_FIELD}) = {?Request_Date} and
{table.TOGGLE_FIELD} = True

Anyone have any clue why this would work?

Thanks again!

Tom