I don't have anything set to be supressed. It's a very simple report. It is basically a straight table pull (of the table RESULT_VIEW) with the following in the selection expert:
{RESULT_VIEW.MNEMONIC}='WAL' AND
{RESULT_VIEW.TESTSEQ}='1' AND
{RESULT_VIEW.TESTCODE} IN...
I got excited, not knowing about the population stdev (I know nothing about statistics, I was just asked for the standard deviation) but unfortunately the results were the same or very close to it when I ran a populationstdev.
No actually that was it, I missed a couple of words when I trimmed something. Basically it's all there, using the same set of data with Excel, I get a drastically different standard deviation than when I compute it in Crystal 8.
I use Crystal 8 connected to an Oracle database to analyze laboratory results. I have come to the conclusion that the standard deviation function is flawed. It seems that the larger our sample population, the farther off the standard deviation becomes, which does not fit our data. To confirm...
If there was a normal test with a higher sequence number, then it would be invalid for my criteria.
I managed to get the data I needed through Toad, our oracle application, by running an sql query there.
What I am trying to do is find out which labnumbers have test results where test 10001 is 'abnormal' AND test 07001 is 'ff'. I don't want the other results. It's this combination of different test results that I need. This database contains about 300,000 different labnumbers for each year...
I am running CR 8 off of an oracle database. The data I need is in the table result_archive. It is arranged like this:
labnumber test sequence value mnemonic
(many more fields but these are the ones of interest)
This is a database of laboratory test results. Each labumber may have several...
This keeps getting better. I added a hotfix, cr85mainwin_en.zip, which came up when I searched for updates for Crystal 8, hoping this would resolve any issues, and now when I load crystal, it is asking for a keycode again, which would be fine. However it doesnt match the length of the keycode...
I am having a problem using the StDev function in Crystal 8.0. I am trying to determing the mean and stdev of lab values for specimens. The mean comes out fine, but the stdev comes out far above what is expected. However, when I run the report for a smaller number of samples, it comes out...
To further explain my problem, I just ran a report calculating the mean and standard deviation of test results for about 120,000 specimens. When I ran the report for all the specimens at once, I got a mean of ~14.5 and a standard deviation of ~40. I reran the report using the specimens one...
I am having a problem using the StDev function in Crystal 8.0. I am trying to determing the mean and stdev of lab values for specimens. The mean comes out fine, but the stdev comes out far above what is expected. However, when I run the report for a smaller number of samples, it comes out...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.