Crystal Reports Access-SQL conversion THEN rpt problems

[SiliconeFirefighter]

If you can help me, I'd appreciate it.
I had a crystal reports (9) rpt working just fine until I converted the db's from Access to SQL Server, now my formula which worked in the Access:
not {tripnumbercust.bPosted} and
{TripResources.ResourceType} = "O" and
{TripNumber.dTripFinishDate} in (?)ReportStartDate} to {?ReportEndDate}

continually returns "a boolean is required here" in the place of "tripnumbercust.bPosted". bPosted is a true or false (1, or 0) field in the db.
Any ideas? I am nearing the end of my rope, and I am at the end of my knowledge.

 

[bdreed35]

Just off the top of my head, you can try changing the criteria to this:

not ({tripnumbercust.bPosted}) and
{TripResources.ResourceType} = "O" and
{TripNumber.dTripFinishDate} in {?ReportStartDate} to {?ReportEndDate}

~Brian

 

[SiliconeFirefighter]

Thanks, Brian, I appreciate it, but I tried that, and to no avail, I still get the same err. I even tried changing the formula to the following:
({tripnumbercust.bPosted}<> 1 and
{TripResources.ResourceType} = "O" and
{TripNumber.dTripFinishDate} in
{?ReportStartDate} to {?ReportEndDate}

And this returned a null value. Any other ideas?

 

[bdreed35]

In the formula editor, highlight the bPosted field in the Report Fields list, and choose Browse Data.
A dialog box should open and give you some unique values it found, and also what the data type is.
Please post the datatype and the some sample data from the list

~Brian

 

[SiliconeFirefighter]

the data type is number and the values found was 1 and o, only those two.

 

[bdreed35]

does this work:

{tripnumbercust.bPosted} <> 1 and
{TripResources.ResourceType} = "O" and
{TripNumber.dTripFinishDate} in
{?ReportStartDate} to {?ReportEndDate}

I removed a leading parenthesis which may have just been a typo.

~Brian

 

[SiliconeFirefighter]

Thanks Brian, that last one did it, you are de man! I'd buy you a beer if'n I could.

 

[bdreed35]

Glad I could help right the ship. Where are you so I can get a free beer?

~Brian

 

[SiliconeFirefighter]

Montana!

 

[bdreed35]

I travel around quite a bit but I haven't been there yet.

~Brian

 

[SiliconeFirefighter]

Well if you ever are, you've got beer!