Thursday, March 26, 2015

Crystal Reports : The Data, the Text and the Ugly

Ok, so here is a constant problem; combining Data and Text. This can be difficult with dates, numbers and any Crystal object that will be changing size depending on the underlying data. You have but a few options, none of them perfect:

1. Drag your Crystal object into a Textbox. When you do this, you're able to place the object within any Text already present. This can be touchy, however, and you lose the ability to right-click the object and get Properties.

2. Place your Crystal object right next to the Textbox. This is easiest, but looks terrible. Getting everything to look just right can take much trial and error.

3. Create a formula to produce both Text and Object as one unified item. This is my favorite approach. Example;

If I need to print out "From xx/xx/xxxx to xx/xx/xxxx" I do this within a formula;

"From " + {?Starting_Date} + " to " + {?Ending_Date}

The "+" is a concatenator and also an operator, so beware when trying to combine text and numbers; Crystal will think you're trying to perform addition. Also, be mindful of where to put in your extra spaces. Notice that "to" has a space on either side of it. Otherwise it will be "crowded".

Now get out there and make it nice!

2 comments:

Xj Cheng said...

This replica Chanel backpack is fabricated from calfskin.Its trim is leather.It is belted with tweed.There are several multifunction pockets area user can put their corpuscle phone,lipstick,make-up,etc.I begin that the blush of gucci replica the replica Chanel can fit about all kinds of clothes.It is not bad to own it.What abroad can we ask for a replica handbag?I bought this replica Gucci backpack from an online store.I like this affectionate of handle bag actual much.The apparel in the backpack surface,which appearance the adorableness of louis vuitton replica the artist handbag,are fabricated on purpose by the designer.This replica Gucci makes me feel adequate and affluence if I airing about with it.It is glassy in black.I can abrasion any affectionate of clothes to bout it.So I don't charge absorb time abrading my arch and contemplate which clothing to abrasion in the morning.Gucci is no agnosticism a name humans can trust.A Gucci backpack is one you'll be appreciative to own if you can afford.If it it's out of question,bethink there are some agitating replica Gucci handbags in the market.They'll amount you a atom of what an accurate Gucci bag would amount you and you'll attending great.If you wish to chanel replica buy Breitling Replica Watches,you will accept to accomplish a quick analysis on it on the Google as you will go through a account of top replica watches companies over there and accept cartier replica your 100% able aggregation out of the all.Moreover Replica Breitling Bentley Watches are actual adequate actualization accessories.That is why they do not could cause any array of affliction or abasement to you at all.Stunningly online Breitling Replica Watches industry makes you accessible discounted replica watch globally.

林磊 said...

2016-2-20 leilei
michael kors handbags
coach factory outlet online
adidas shoes
louboutin
michael kors handbags
christian louboutin shoes
ray ban sunglasses
gucci borse
nike force 1
air jordan shoes
ture religion outlet
jordan shoes
ralph lauren pas cher
christian louboutin outlet
micahel kors
cheap soccer jerseys
true religion
michael kors outlet
kate spade
toms outlet
michael kors outlet online
nike sb janoski
ugg boots
gucci handbags
ray ban sunglasses
toms outlet
nike blazer
coach factory outlet
fitflop shoes
moncler jackets
north face jackets
louis vuitton outlet onlne
sac longchamp pliage
michael kors handbags
michael kors handbags
instyler max
moncler jackets outlet
mcm handbags
retro jordans 13
michael kors outlet