How to group table records
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=21896
Printed Date: 28 Apr 2024 at 10:26pm
Topic: How to group table records
Posted By: $$Dr
Subject: How to group table records
Date Posted: 02 Mar 2016 at 1:31pm
I am relatively new to Crystal Reports and I am attempting to create a cross tab report against a Viewpoint Vista table where the group the Name#2 row by phase code groups rather than individual phase codes.
Example:
Phase codes 100000 through 199999 would be one phase grouping,
codes 200000 through 299999 would be another and so on.
Currently, the design looks like this:
row1 Job Costtype 1 CostType 2 and so forth
row 2 all Phase $$$$ $$$$$
Currently Row#2 Name displays rows by each individual phase code for the applicable job.
I would like the rows to be in the phase groups that would produce Multiple rows; 010000, 190000, 200000 where each row would summarize the totals from all the inclusive phase codes from each group. The Group name would be @PhaseGrp which is defined by formula, which I am not sure is correct.
row 1 Phase Gp Costtype 1 Cost type 2 and so forth
row 2 10000 $$$$$ $$$$$
30000 $$$$$ $$$$$
Next grp
Any ideas would be much appreciated.
|
Replies:
Posted By: DBlank
Date Posted: 03 Mar 2016 at 7:53am
maybe this...?
create a formula field as:
floor(table.phasecode,100000)
group on the formula field
|
|