incorrect and inconsistent results each time rpt runs

[ksnpc]

I'm running CR 9 on Windows XP, connecting to an Oracle 9i database. My report is showing rare and endangered species grouped into types of species. I was checking over a printout of the report and found that 12 species were missing from the list. I checked the database and could find nothing wrong so I reran the report. The 12 missing species came back but 10 different ones were dropped. I've had the report since last year and haven't had this problem until now. I haven't changed the report structure and the database has not changed so I can't figure out why the report is giving inconsistent results. Does anyone have any ideas what could cause such a problem?

 

[aaronburro]

Hmmm... Before anyone else slams into you for not giving more specifics about the report implementation, I'll ask how you are implementing said report?

The problem you are describing, from my computer science background's standpoint, sounds like a problem w/ data being random and you not actually requesting the whole set of data. Of course, this kind of problem would normally not be present in Crystal, unless you intentionally limited the number of records displayed...

Without knowing more about your implementation, I'd have to say that it is potentially a DB side problem, whether it be an actual error or a restructuring of the DB or change of DB values or whatnot. To test for this, see how many records your DB is returning overall, and then see how many records are actually being displayed in the report. Also, you could try unchecking "Use Server or Indexes for Speed" in Report Options and look and see if any records are being filtered out (does the first increasing number always equal the second increasing number in the "xxx of xxx" box in the status bar as the report loads the data?)

but thats just my uneducated opinion...

 

[ksnpc]

Thanks for your response and I'm sorry for the lack of detail. The report selects species tracked by our state that are not extirpated or extinct. It is broken into three groups:
Group 1 - breaks species into general groups - lichens, plants, animals
Group 2 - subgroups within the main groups (for example, mammals, amphibians, etc.)
Group 3 - shows the scientific name and the status (endangered, threatened, etc).
Details contain an id value for observed reports of the species (because we don't want to report species with no confirmed data) but the section is suppressed so it doesn't show up on the report.

Hopefully that made more sense. I will check on that "Use Server or Indexes for Speed" option.

 

[Turkbear]

Hi,
OK, more info please..

More than 1 table involved? If so, what kind of joins?
What connection method?
Same Oracle user account each time the report is run?
Have you tried the 'verify Database' option before running the report ( should not be needed if only data has changed and not structure, but can't hurt).







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[shakespeare5677]

I have a similar problem on CR10. I have a few formulas running, keeping totals on read and write. The results that I'm getting based on the calculations, seem to suggest that some of the variables I'm using in the report clear out while others don't. Since the problem is not that big a deal in my report I have not gone into depth to prove my theory, but I think it's just the need to properly initialize the variables.
-Max

 

[ksnpc]

It is an ODBC (RDO) connection, and always the same Oracle user account.

Unfortunately the database has a rather complicated structure (which I have no control over). For this report, there are ten tables, connected by inner joins except two of the domain tables connected by left outer joins.

Yes, I have the verify database option checked and it always says the database is up to date. I thought if it were a database problem I would get the same species showing up as problems each time rather than this random problem. One of my co-workers suggested maybe I had a corrupt driver. I'm not even sure how to check that, but I think I'll see if I can run the report on a different machine with better results.

Shakespeare, I don't think I have any of the variables like you're describing, but I'll take a closer look to make sure. My formulas are pretty basic and just deal with formatting.

 

[Turkbear]

Hi,
Just as an experiment, try using the Native Oracle driver instead..

In your first posting, did you try refreshing the report ( the lighting bolt)rather than rerunning it?


I suspect, however, that the issue is related to the joins..





To Paraphrase:"The Help you get is proportional to the Help you give.."