Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Data with mutliple values, need to export Post Reply Post New Topic
Author Message
poppy
Newbie
Newbie


Joined: 02 May 2011
Location: United States
Online Status: Offline
Posts: 4
Quote poppy Replybullet Topic: Data with mutliple values, need to export
    Posted: 16 May 2011 at 4:54am
Hello there, I have a report that I need to export to excel. There is a field that has multiple values and I need it to be in a single column when exported to excel.
 
For example
 
Color
Blue Green Yellow
 
How do I export to excel with separate columns? Any suggestions or recommendations would help, Thanks!
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 25 May 2011 at 5:07am
if there is consistency within the field, you could setup an array and "split"

A more straight forward approach may be to just do this:
Create however number of formula fields (equal to the max number of values in that field).

If its three, you would just need a left/mid/right function thought.

@form1
left({Field1},4)

@form2
mid({Field1},5,4)

@form3
right({field1},4)

I didnt check the functions syntax, I hoped you would get the idea.
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 08 Jun 2011 at 3:10am
Did your question get answered?
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.016 seconds.