Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: create columns by groups Post Reply Post New Topic
Author Message
lorimack
Groupie
Groupie


Joined: 03 Nov 2009
Online Status: Offline
Posts: 48
Quote lorimack Replybullet Topic: create columns by groups
    Posted: 19 Oct 2012 at 2:51am
How can you create 2 columns by using groups?
 
I have the following info
 
9/2012
1
4
 
10/2012
8
9
 
11/2012
3
5
 
12/2012
6
7
 
and i want it to look like this
 
9/2012                              11/2012
1                                       3
4                                       5
 
10/2012                             12/2012
8                                        6
9                                        7
 
Any suggestions?
 
IP IP Logged
shanth
Groupie
Groupie


Joined: 06 Aug 2012
Location: United States
Online Status: Offline
Posts: 75
Quote shanth Replybullet Posted: 19 Oct 2012 at 4:02am
Create two formulas based on condition how you want to split into two columns and then keep those two formulas in details or group footer, where  you need them.
Formula will be something like below if you have Group on Groupfield:
function({field/formula},{Groupfield})

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.