CODEWITHSUNDEEP
crystal-reports
Anthony Aziz
Anthony Aziz

Reputation: 135

Summarizing each subgroup in Group Footer - Crystal Reports

I'm trying to work on a report for a client. Basically I need something like such

Group 1: Customer ID Group 2: Truck ID

CustID    Vehicle ID    Detention Time
------    ----------    --------------
   ABX           100                60
                                    35
                                    20
                            TOTAL: 115

                 200                80
                                    15
                            TOTAL:  95

                 300                10
                            TOTAL:  10

TOTALS FOR CUSTOMER ABX
    100    115
    200     95
    300     10

Is there anyway to accomplish this without a subreport? I was hoping for a "summary field" that I could summarize more than just a single value.

Thanks!

(FYI using Crystal Reports 2008)

Upvotes: 2

Views: 3429

Answers (2)

craig
craig

Reputation: 26262

Use a crosstab; place it in the report-footer section.

Upvotes: 4

Ryan
Ryan

Reputation: 7287

There might be a better way to do this, but the one that comes to mind is to use two arrays: One to store the truck ID and another to store the corresponding total. In each inner grouping (TruckID), just tack on another array element and store its total time. To display, you could cast the values to strings, attach a newline character after each entry, and set the field to "Can Grow". So altogether, you'd need three formulas: one to initialize the arrays (in GH1), one to update the arrays with sum({truck.time},{truck.ID}) (in GF2), and one to display each entry (in GF1).

With that being said, CR has terrible support for containers... You're limited to 1-dimensional, non-dynamic arrays that are gimped at 1000 items max. It doesn't sound like these would be big problems for what you're trying to do, but you will need to redim preserve the arrays unless you know ahead of time how many trucks you'll have per customer.

Upvotes: 0

Related Questions