Incorrect Operating system error 112(There is not enough space on the disk.) -

MSsql server gives this error while there is 24 GB physical disk space available.
I think an bug.
I have a disk of 100 GB All the files together are 100 GB big, but an part is windows-nt compressed so the pysical disk space of these files is 77 GB.
I tried to increase the tempdb by hand, but still gives this message.
If I delete files from the disk I can increase the tempdb.Forgot to mention is SQL2000 sp2 on W2K server sp1sql

Inconsisten Crystal Report

Hiya,

Been putting a report together in Crystal Reports X, and its giving inconsisten results.

I have 3 charts that are being created over a set of data, 2 are fine, but 1 is being inconsistent.

Its using a formula with a global array to store sales figures for the next 12 months (its something with the dataset), doing a bunch of calcs for current months sales, and rolling those figures forwards.

When you first run the report, it comes up with a set of values that bear no relation to the actual data.

If you then go in and just add a blank line to the formula and refresh it, the report runs exactly as expected.

Very strange, and totally repeatable, kinda clueless on what to do with it.Can you post the formula you used?
Also make sure you verify database everytime the table schema changes