Running Total Question

Posted on 2011-10-31
Last Modified: 2012-05-12
I have a parameter field {?Warehouse} that allows for All or single or multiple...

How can I create a Running Total Grand Total based on each one of these selected items in this {?Warehouse} field..

I have 11 Items
... and so on
I cant get the Report Footer to show Summary for various fields to show by these 11 items
Question by:Mikeyman_01
    LVL 77

    Expert Comment

    Can you be clear about what you are trying to do.

    DO you actually want a running total or do you just want a single total for each warehouse?

    If you want warehouse totals then can you not group the data by warehouse?
    LVL 14

    Expert Comment

    if i understand correctly, you want totals in the report footer for each of the possible 11 items available in the parameter.

    2 ideas:
    you could create formulas that are manual running totals for each possibility. Insert them into the detail section, and then right click to insert a summary in report footer.
    each formula would be similar to:
    if {table.field} = 'DS' then {table.amount} else 0 //must compare against table.field, not the parameter field.

    You could insert a cross tab in the report footer, which would have the amount field as detail, and the "type" (DS, HA) as columns.
    LVL 100

    Accepted Solution

    Are you adding all values or is the running total excluding some?

    I think the easiest to do is the cross tab idea.  That will work regardless oh how may values there are for Warehouse.  Also you won't get ones where there is no data.

    How do you want the report to look?


    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Suggested Solutions

    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    This video discusses moving either the default database or any database to a new volume.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now