Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Display Verticle data to horizontal Post Reply Post New Topic
Author Message
shaz62
Newbie
Newbie


Joined: 06 Jul 2011
Online Status: Offline
Posts: 1
Quote shaz62 Replybullet Topic: Display Verticle data to horizontal
    Posted: 06 Jul 2011 at 10:45am
Hi Can anyone help.
 
My data is being displayed as detailed below.
 
CNCT1
CNCT2
CNCT3
CNCT4
 
I wish to transpose this so it is displayed like this
 
CNCT1, CNCT2, CNCT3, CNCT4
 
Appreciate any assistance.
shaz62
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 06 Jul 2011 at 12:17pm
Is your data grouped in any way?  If so, what grouping levels do you have and which group do you want this displayed in?
 
The only way I know of to do this is to create a formula using a variable that gets updated for each record that is read.  This formula then has to be used in a group footer section in order to display the data.  The formula looks something like this:
stringvar mydata;
if OnFirstRecord or {group field} <> previous({groupfield}) then
  mydata := {table.mydatafield};
else
  mydata := mydata + ', ' + {table.mydatafield};
mydata
 
-Dell
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.031 seconds.