Hi,
Yes you are doing on a right way, use the split function and create a
variable.
First you go formula field->new->name->use editor->select split
function(In function box)->set the formula -> save it
To pass that variable in the cross tab where you want to retieve the
subvalues.
Thanks,
Vipin
--
[EMAIL PROTECTED]
www.vyomlabs.com
Consulting | Oursourcing | Training || BMC Remedy BSM | ITIL | IT Governance
Ben Cantatore wrote:
**
I think what you want is something like:
split({Remedy field},"|")[1]
Remedy field is replaced with whatever db field you're reporting
against, the delimiter you're using encapsulated with quotes followed
by the array subscript which in Crystal syntax I believe starts at 1.
Hope that helps.
I've found this website VERY helpful when I'm having Crystal
questions: http://www.tek-tips.com/
The home page is busy, but if you use the search option and put
crystal in you'll get to the main forum for crystal.
*Shawn Stonequist <[EMAIL PROTECTED]>*
Sent by: "Action Request System discussion list(ARSList)"
<[email protected]>
04/18/2007 10:52 AM
Please respond to
[email protected]
To
[email protected]
cc
Subject
Crystal Question: Arrays
Greetings List!
I'm trying to run a Crystal Report using Data from Remedy. In one field I
have a menu which sets values such as
Value1: SubValue1
Value1: SubValue2
Value2: SubValue1
etc.
I'm trying use the Split command to break these apart so I can group the
SubValues by the Value in a Cross-Tab.
I've got the formula for the Split, but I can't figure out how to use this
to grab the first element created and display it so that I can use it
in the
groupings.
Is there a way to do this? Or, is there another way to break this one
field
into two (e.g. like Excel's Text to Columns using a Delimiter of ":")?
I've poured through the Crystal Help, but it wasn't helpful- when I seemed
to get a valid solution, I was told that I needed to script the array,
example: Array [i]. When I put the Split into the brackets, it said
that the
rest wasn't part of the equation.
Thanks in advance for your help!!!
Shawn Stonequist
Emns, Inc.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
ARSlist:"Where the Answers Are"
__20060125_______________________This posting was submitted with HTML
in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
