Print Page | Close Window

CrossTabValues

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21906
Printed Date: 29 Apr 2024 at 4:46am


Topic: CrossTabValues
Posted By: $$Dr
Subject: CrossTabValues
Date Posted: 09 Mar 2016 at 7:28am
I am new to Crystal Reports.
Question is how do I design a cross tab that provides max values in the rows, but sums the max values in the totals?

Example:
            Cost Type
Job
Phase       Max Value (per phase on job)
Total       Sum of Max Values for each column(Cost Type)

Second question is how can phases be grouped such that report looks like this:

           Cost Type
Job
Phase      Sum of hrs or cost (phase is a group of phases rather than a single phase.
Total      Grand total sum of all phase hrs or cost by cost type column.



Print Page | Close Window