Formula problems

[ready4data]

Why doesn't this formula work? It used to with the old version of Sales Logix.
If I take out the HISTORY.ACCOUNTNAME section the report works.
We are using SQL server and switched to an OLE DB connection for Crystal reports rather than the ODBC connection we had with the old Sales Logix.

(if {?Region} <> "All"
then{USERINFO.TITLE} = {?Region}
else if {?Region} = "All" or {?Region} = '""'
then True) and
{USERINFO.USERNAME}<>"" and
{USERINFO.USERNAME}<> "Administrator" and
(if {?User Name} <> "All"
then{HISTORY.USERNAME} = {?User Name}
else if {?User Name} = "All" or {?User Name} = '""'
then True) and
{HISTORY.STARTDATE} = {?Date Range} and
(if {?Brand} <> "All"
then{DEALER_PROFILE.ASSOCIATION} = {?Brand}
else if {?Brand} = "All" or {?Brand} = '""'
then True) and
(if {?Wildcard Dealer} <> '""'
then {HISTORY.ACCOUNTNAME} like "*" + {?Wildcard Dealer} + "*"
else if {?Wildcard Dealer} = '""'
Then True)
Open to ideas
Scott

 

[rosemaryl]

Dear ready4data,

When you say it doesn't work ... what does that mean?

Does it error?
Does it return different data?

It would also help to know the version of Crsytal.

It would also be helpful to know what the Database/Show SQL query states in the original and in this one.

What is different?

Regards,

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.