Database Field showing as zero in report footer but works in group footer

I'm fairly new to crystal so there may be an obvious solution but I just can't find it. So any help what-so-ever would be excellent and much appreciated...

Problem:

Database field shows correct value and works in formulas properly in group footer.
In Report footer this same database field shows as zero and therefore other formulas in the report footer do not calculate correctly.

Any solutions?Please. Any help would be greatly appreciated. I'm kind of in a time crunch.

I'm not sure why a database field would show the value in the group footer and come up zero in the report footer.

Any ideas??|||Sorry, don't know why either - the report footer always shows the final database record for me!
I have read of other people having this problem, and I believe that assigning the fiele to a shared variable has allowed the value to be used.|||I gave it a variable and now it works. How weird is that?!

Thanks for your help!sql

Database data file does not auto-grow

Dear all,
We are using SQL2000 sp4 on Windows 2000 Svr.
We found one of the database size become zero in Enterprise manager.
We have checked the database setting and the database is already set
auto-growth, without limit, by 1000Mb each time.
The data file size reach 6G now.
Is there anything we miss? That's the first time we meet this case.
We have checked the Harddisk drive for the data file and it still have over
100G space.
IvanIvan wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have over
> 100G space.
> Ivan
Do you get an error message saying the filegroup is full?
What is the output of EXEC sp_spaceused?
Auto-growth is usually a bad idea and isn't something I would normally
recommend for a production application. Why would you want to grow a
6GB database in 1GB increments?
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||dbcc updateusage?
Cheers,
"Ivan" wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have over
> 100G space.
> Ivan
>
>

Database data file does not auto-grow

Dear all,
We are using SQL2000 sp4 on Windows 2000 Svr.
We found one of the database size become zero in Enterprise manager.
We have checked the database setting and the database is already set
auto-growth, without limit, by 1000Mb each time.
The data file size reach 6G now.
Is there anything we miss? That's the first time we meet this case.
We have checked the Harddisk drive for the data file and it still have over
100G space.
Ivan
Ivan wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have over
> 100G space.
> Ivan
Do you get an error message saying the filegroup is full?
What is the output of EXEC sp_spaceused?
Auto-growth is usually a bad idea and isn't something I would normally
recommend for a production application. Why would you want to grow a
6GB database in 1GB increments?
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||dbcc updateusage?
Cheers,
"Ivan" wrote:

> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have over
> 100G space.
> Ivan
>
>

Database data file does not auto-grow

Dear all,
We are using SQL2000 sp4 on Windows 2000 Svr.
We found one of the database size become zero in Enterprise manager.
We have checked the database setting and the database is already set
auto-growth, without limit, by 1000Mb each time.
The data file size reach 6G now.
Is there anything we miss? That's the first time we meet this case.
We have checked the Harddisk drive for the data file and it still have over
100G space.
IvanIvan wrote:
> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have ove
r
> 100G space.
> Ivan
Do you get an error message saying the filegroup is full?
What is the output of EXEC sp_spaceused?
Auto-growth is usually a bad idea and isn't something I would normally
recommend for a production application. Why would you want to grow a
6GB database in 1GB increments?
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||dbcc updateusage?
Cheers,
"Ivan" wrote:

> Dear all,
> We are using SQL2000 sp4 on Windows 2000 Svr.
> We found one of the database size become zero in Enterprise manager.
> We have checked the database setting and the database is already set
> auto-growth, without limit, by 1000Mb each time.
> The data file size reach 6G now.
> Is there anything we miss? That's the first time we meet this case.
> We have checked the Harddisk drive for the data file and it still have ove
r
> 100G space.
> Ivan
>
>