BusinessObjects Board

Split one record into two

building reports crystal reports
#1

I want to split a record value into two. The record contains information for two users, Is there a way i can separate them and make it two separate records?

For eg. Tom and Sam is stored in a field FirstName as a single record.

bohelp22 (BOB member since 2011-05-14)

#2

You may be able to split the field, but not sure how you would create a new record.

kevlray :us: (BOB member since 2010-06-23)

#3

I know. I am trying to display the split value as another record. Is that possible?

bohelp22 (BOB member since 2011-05-14)

#4

  1. Create two formulae separating each user.

  2. Create two Detail sections. Keep all the fields as it is in both sections except one. That one field should be your formulas. Formula1 goes to your Details a section and Formula 2 goes to Details b section.

  3. Suppress one detail section based on a unique identifier with Previous() function. The idea is to hide one detail section if there is only one user.

anil.ganga1 :us: (BOB member since 2007-07-04)