Weird issue

[hereigns]

Database = Access 97
CR ver = 8.5

I've got a report that pulls customer name + Id + Type + bid price + date field. Basically the report spools based on the date field tblMaster.DateRequested which is an expected customer install date of our product, it also gives us an estimated income based on bid price for each month.

The report is set to sort by each month of the year. Up until September of this year the report was running fine but now for a reason I've not been able to determine the report spits out a $0.00 for September 2004. Which should not have any data. With the help of some CR users in a previous post I was able to get "workaround" the problem by configuring the report to ignore September 2004 data.

Below is an example of how the report should look:

------------------------
October 2004
Customer ID. Customer Name. Expected Date. Bid Price.
1 ABC 10/25/2004 $5,000.00
2 XYZ 10/28/2004 $3,500.00


------------------------
November 2004
Customer ID. Customer Name. Expected Date. Bid Price.
3 ABC2 11/10/2004 $5,000.00
4 XYZ2 11/14/2004 $4,500.00
5 DEF 11/22/2004 $6,200.00

 

[lbass]

I would start by making sure that "convert null fields to default values" is NOT checked in file->report options. Is it possible that during data entry partial data was entered and a space inserted in the price field? You might test for both nulls and spaces by using a group selection formula of:

isnull({table.bidprice}) or
trim({table.bidprice}) = ""

...just to see if any records are returned.

-LB

 

[synapsevampire]

Note that in your previous post I suggested that you supply example data.

One thing I would urge you to do is create a Query (it can be based on other queries) in MS Access as the data source for the Crystal Report, that way all issues can be resolved within the database, and you're using Crystal for what it does best: Presentation.

Note that using the Access ODBC will allow for selecting Database->Show SQL Query in your existing report, which will show you EXACTLY what's being passed, so you can use that as the basis for your Access Query(ies) and for detective work.

I suspect what LB alluded to, that you have September data, but it may be something else. It's very difficult to diagnose without knowing a good deal about the report, such as the tables/joins/selection formulas.

-k