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 DLL

Hope someone here can help.
When I set up a Crystal report to an application , I got an application
error like this:
****Error : 532 Cannot find databse DLL
****Execute<PEStartPrintJob>
Is ths related to different version of Crystal or SQL server?
Thanks
Catelin
I have some ugly memories about that...532 Cannot find
database DLL is a Crystal error. There should be several (if
not more) articles on their support web site about the
error.
-Sue
On Wed, 26 Jan 2005 16:40:30 -0600, "Catelin wang"
<cwang@.cemstone.com> wrote:

>Hope someone here can help.
>When I set up a Crystal report to an application , I got an application
>error like this:
>****Error : 532 Cannot find databse DLL
>****Execute<PEStartPrintJob>
>Is ths related to different version of Crystal or SQL server?
>
>Thanks
>Catelin
>

Database DLL

Hope someone here can help.
When I set up a Crystal report to an application , I got an application
error like this:
****Error : 532 Cannot find databse DLL
****Execute<PEStartPrintJob>
Is ths related to different version of Crystal or SQL server?
Thanks
CatelinI have some ugly memories about that...532 Cannot find
database DLL is a Crystal error. There should be several (if
not more) articles on their support web site about the
error.
-Sue
On Wed, 26 Jan 2005 16:40:30 -0600, "Catelin wang"
<cwang@.cemstone.com> wrote:

>Hope someone here can help.
>When I set up a Crystal report to an application , I got an application
>error like this:
>****Error : 532 Cannot find databse DLL
>****Execute<PEStartPrintJob>
>Is ths related to different version of Crystal or SQL server?
>
>Thanks
>Catelin
>

Database DLL

Hope someone here can help.
When I set up a Crystal report to an application , I got an application
error like this:
****Error : 532 Cannot find databse DLL
****Execute<PEStartPrintJob>
Is ths related to different version of Crystal or SQL server?
Thanks
CatelinI have some ugly memories about that...532 Cannot find
database DLL is a Crystal error. There should be several (if
not more) articles on their support web site about the
error.
-Sue
On Wed, 26 Jan 2005 16:40:30 -0600, "Catelin wang"
<cwang@.cemstone.com> wrote:
>Hope someone here can help.
>When I set up a Crystal report to an application , I got an application
>error like this:
>****Error : 532 Cannot find databse DLL
>****Execute<PEStartPrintJob>
>Is ths related to different version of Crystal or SQL server?
>
>Thanks
>Catelin
>