Skip to Content
author's profile photo Former Member
Former Member

Group Totals - Crystal 2008

I have created an inventory aging report that ages based on reciept type transaction date. In order to calcualte this, I created a formula in a document transction group.

I would now like to summaries the transactions by inventory item, but the fields are not available to be used running total.

Am I missing something?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 06, 2010 at 09:14 PM

    and what fields are not available.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      You create your own running total.

      (A) At Item Group Header, create a formula to initilize the variable:

      Variniit

      Whileprintingrecords;

      Numbervar g30:=0;

      Numbervar g60:=0;

      (B) Then you create an accumulation formula to accumulate your aging fields. Eg: you have a formula called 30d and 60d

      Whlieprintingrecords;

      numbervar g30;

      numbervar g60;

      g30:=g30 + 30d;

      g60:=g60 + 60d;

      Then you place this formula at the section where the aging is done.

      (C) At Item Group Footer, create formullas to display the variable.

      Eg: For 30days, create a formula named Display30, In it, the formula is:

      Whilepritningrecords;

      numbervar g30;

      Create another formula to display 60days, eg: Display60. the formula is:

      Whilepritningrecords;

      numbervar g60;

      Then put the formula at the section where aging of item should be displayed (in your case, Item Group Footer)

  • author's profile photo Former Member
    Former Member
    Posted on Oct 06, 2010 at 08:49 PM

    Wendy,

    It's not very clear what you are trying to do... What is the formula you are using and where are you placing it on the report?

    Jason

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.