Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Displaying multiple data fields on one line Post Reply Post New Topic
Author Message
apuente
Newbie
Newbie
Avatar

Joined: 26 Nov 2012
Online Status: Offline
Posts: 15
Quote apuente Replybullet Topic: Displaying multiple data fields on one line
     Posted: 26 Nov 2012 at 7:32am
Hi, I have some data that i want to conditonally display on one line. The data can be found below. I would like to get BC_SEQ  000500, 000501 and 000502 on one line, since they represent one set of instructions. It seems like the data only allows for a certain number of characters before it moves the data to another row. Can anyone help me with this.
Thank You!
 
BC_SEQ EXTRA_DESC
*000200* 1. CHANGE FILTER ELEMENTS.
*000300* 2. INSPECT BELT FOR CRACKS.
*000400* 3. INSPECT BELT FOR FRAYING
*000500* 4. INSPECT CONDENSER FAN TO
*000501* MAKE SURE ITS WORKING AND
*000502* CORRECT AIR FLOW DIRECTION
Thank You,
Antonio
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 27 Nov 2012 at 2:52am
are you familiar with shared variables?

if the instructions generally format 0005##, would create a formula with

left(BC_SEQ, 4)

group by this formula
...


create another formula

shared stringvar extradesc:='';

this goes in group header

-----

another formula

-----
in details

shared stringvar extradesc:=extradesc;
if left(BC_SEQ,4) = formula used for grouping first four variables then

extradesc:=extradesc+' ' + {EXTRA_DESC};

----

in group footer

shared stringvar extradesc:=extradesc;
extradesc


---

This may work, I am still in vacation mode first.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 28 Nov 2012 at 9:11am
you don't need the assignment in the group footer, just:
shared stringvar extradesc;
extradesc
 
otherwise looks fine to me...
and if you use this all time, then it obviously doesn't hurt.
 
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 28 Nov 2012 at 9:14am
Originally posted by lockwelle



you don't need the assignment in the group footer, just:
shared stringvar extradesc;
extradesc
 
otherwise looks fine to me...
and if you use this all time, then it obviously doesn't hurt.
 


I noticed that and was curious if I should change it, leave it to Lock to find my mistake, or Kev :)

Actually thanks, I wasn't aware you didnt need to redefine.
IP IP Logged
apuente
Newbie
Newbie
Avatar

Joined: 26 Nov 2012
Online Status: Offline
Posts: 15
Quote apuente Replybullet Posted: 30 Nov 2012 at 5:54am
I was not too familiar with variables but this i worked through the variables you suggested and it worked perfectly.
 
Thank You both!
Thank You,
Antonio
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.