Re: Crystal Question: Arrays

2007-04-19 Thread Susan Palmer 

Ben,
Thanks for the great website tip.
Susan


On 4/18/07, Ben Cantatore <[EMAIL PROTECTED]> 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)" <
arslist@ARSLIST.ORG>

04/18/2007 10:52 AM   Please respond to
arslist@ARSLIST.ORG

   To
arslist@ARSLIST.ORG  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"

Re: Crystal Question: Arrays

2007-04-19 Thread Vyom Labs - ITSM Support 

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)" 



04/18/2007 10:52 AM
Please respond to
arslist@ARSLIST.ORG


    
To
        arslist@ARSLIST.ORG
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"

Re: Crystal Question: Arrays

2007-04-18 Thread Ben Cantatore 
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)" 

04/18/2007 10:52 AM
Please respond to
arslist@ARSLIST.ORG


To
arslist@ARSLIST.ORG
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"


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Crystal Question: Arrays

2007-04-18 Thread Shawn Stonequist 
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"