Need help Summarizing a Shared NumVar!

[trialbyfire]

I have had a lot of posts back on a previous posting stating to just create another formula field that summarizes the shared numbervar. I tried that before I made the original post and it didn't work. Here is what I have.

-In group header #2:
/whileprintingrecords;
/shared numbervar unitspicked;
/unitspicked:=0

-In detail section a in the subreport:
/whileprintingrecords;
/shared numbervar unitspicked;
/unitspicked:= {oe-pick-ticket-trl.recommended-qty}

- In detail section b which is underlying detail section a:
/whileprintingrecords;
/shared numbervar unitspicked;
/unitspicked

-Group Footer #2
/sum (shared numbervar unitspicked)
I have also tried to summarize the formula field that I have in detail section b.
/sum ({@tot picked})

In both cases I get a statement saying that;
THE SUMMARY / TOTAL RUNNING FIELD COULD NOT BE CREATED

I am at a loss on this one. Not that I work with a lot of shared numbervar's between subreports to start with, but this has got me stumped. Please help if you could. I know I need to summarize so please give more description than "Create a summary field in the group level of the report"

Thanks for the help in advance.

BJ

 

[Madawc]

In Crystal 8.5, you can check which formula fields etc. you can 'see' for a particular function. Whatever you cannot see cannot be used.

THis in turn reflects the order in which Crystal processes and evaluated the fields. You can't get round this.

You can get totals that are available earlier, using right-click, [Insert] and [Summary]. These let you show the number of members in a group within the group header etc. I'm not clear what your report should be doing, but maybe you can get the desired result that way. Madawc Williams
East Anglia
Great Britain

 

[Naith]

-In group header #2:
/whileprintingrecords;
/shared numbervar unitspicked;
/shared numbervar unitspickedtotal;
/unitspicked:=0;
/unitspickedtotal:=0;

-In detail section a in the subreport:
/whileprintingrecords;
/shared numbervar unitspicked;
/shared numbervar unitspickedtotal;
/unitspicked:= {oe-pick-ticket-trl.recommended-qty};
/unitspickedtotal:= unitspickedtotal + {oe-pick-ticket-trl.recommended-qty};

-Group Footer #2
/whileprintingrecords;
/shared numbervar unitspickedtotal;

Naith