Reportpax Labels Questions

ID #1007

How do I eliminate blank lines when printing labels?


Here is a quick tip on eliminating blank lines when printing labels. To give you an example of this, let's say you are printing an Address Line 1 and an Address Line 2 on your labels. However some records do not have an Address Line 2 and you do not want to have the blank line printed for those labels (similar to the picture below where the first record does not have a company so a blank line is printed):


To fix this, you just need to add some custom code to fit your needs:

1) Bring up the report in VS and click Report -> Report Properties menu item

2) Click the Code tab and paste this code at the bottom:
function FieldThenNewLine(field)
    if field = "" then
        return ""
    else
        return field & chr(13) & chr(10)
    end if
end function


3) Now you must edit the Label expression to something like this:
=
Code.FieldThenNewLine(Fields!ContactName.Value) &
Code.FieldThenNewLine(Fields!CompanyName.Value) &
Code.FieldThenNewLine(Fields!Address.Value) &
Code.FieldThenNewLine(Fields!City.Value  & ", " & Fields!Region.Value  & "  " & Fields!PostalCode.Value) &
Code.FieldThenNewLine(Fields!Phone.Value)

Now a new line will only print if the field is not blank.

Last update: 2007-12-11 15:41
Author: ReportPax Support
Revision: 1.1

Print this record Print this record
Send to a friend Send to a friend
Show this as PDF file Show this as PDF file
Export as XML-File Export as XML-File

Please rate this entry:

Average rating: 0 out of 5 (0 Votes )

completely useless 1 2 3 4 5 most valuable

You can comment on this entry

Comment of mbt shoes (2009-12-24 20:38:30):
mbt trainers85% off, $87 only. Mbt shoes, shoes mbt are on sale.

Comment of bushworlda (2010-01-06 03:55:05):
Mbt Lami and Mbt Chapa are first choice of Mbt shoes.

Comment of bushworlda (2010-01-14 19:26:37):
CHI Flat iron and ghd hair straightener have advantage in straightening as well as curling. we recommend trying ghd.

Comment of asdf (2010-02-02 07:44:47):
チャットレディー募集 サラ金・消費者金融のすべて キャッシング Real Estate もりりんさんのStudio キャッシング 中国株で貧乏 銀行のウンチク ふろむ堺PJ ネットでお小遣い 夢見るモモの貯金道 資格を取ろう 商品先物取引トレーディング入門 投資比較.net キャッシングの安心君 MINI SHOP FXトレーダーズ FXはじめました 車の用語集 ＨＰ宣伝ＢＢＳ 基礎代謝 ペット大好き 転職・就職なら キャッシング比較 金融用語辞典 消費者金融　比較 素材屋ごちゃ 経営用語集 女性の悩み ネットで収入 seego

Comment of GHD (2010-02-10 20:41:28):
CHI Flat iron and ghd hair straightener have advantage in straightening as well as curling. we recommend trying ghd.

Comment of discount GHD (2010-02-19 20:33:20):
ghd hair straighteners and CHI Flat iron sell at low prices, you will find cheap ghd straightener.

Comment of GHD (2010-02-22 01:26:53):
ghd straighteners and chi flat iron are both excellent hair irons.ghd sells at discounted prices.

Comment of Classic cardy Ugg (2010-02-22 09:15:16):
If there is one gift that is ideal for a football fan, it's an NFL cheap jerseys . This item is suitable for any occasion and it is a fantastic idea for a long-time follower of a team. You can find an authentic nfl jerseys in a number of different places and you have plenty of options to consider.Nowadays, online shopping become people's hobbies, because it is very convenient. There are numbers of online stores which sellauthentic jerseys . Our site offers many different NFL jerseys with high quality and fashion style, such as 2009 PRO BOWL, Buffalo Bills, Green Bay Packers and so on. Thoseauthentic football jerseys will bring you the same comfortable feeling as the authentic ones. authentic nfl jerseys

Comment of True Religion Jeans (2010-02-24 20:38:23):
Seven jeans are about sexy, adventurous, trendsetting apparel and accessories. Shop from our entire line of Seven for mankind.And latest designer True Religion Jeans here, welcome to buy.

Comment of GHD (2010-03-04 17:51:28):
ghd pure white and ghd straightener purple are on sale, our web offers reasonable prices of GHD straighteners.

Comment of mbt shoes (2010-03-05 00:18:08):
Mbt shoes are in the fashion,discount mbt shoes Sport and mbt tataga Mbt shoes encourage an active, healthy lifestyle

Comment of Replicawatches (2010-03-05 01:45:31):
aqian100305 Designer Watches Men's Watches Women's Watches Wrist Watches Cartier Watches Chanel Watches Armani Watches Omega Watches Iwc Watches A Lange & Sohne Watches Audemars Piguet Watches Bell & Ross Watches Breguet Watches Breitling Watches Tudor Watches Bvlgari Watches Baume mercier Watches Burberry Watches Chopard Watches Carrera Watches Corum Watches Calvin Klein Watches Constantin Watches Chronoswiss Watches Dewitt Watches Dolce & Gabbana Watches Ebel Watches Eberhard & Co Watches Enicar Watches Franck Muller Watches Glashutte Watches Gucci Watches Geneve Watches Graham Watches Hermes Watches Jaeger LeCoultre Watches Longines Watches Louis Vuitton Watches Tag Heuer Watches Hublot Watches Tissot Watches U-Boat Watches Ulysse nardin Watches Related log Honeyreplica Louis Vuitton Handbags yanrikun hermes handbags hermes handbags hermes handbags honeyreplica hermes handbags hermes handbags hermes handbags replica handbags Honeyreplica Wholesale Rolex Watches 2010 Audemars Piguet Watches 2010 wholesale Breguet Watches Bvlgari Watches 2010 Tudor Watch 2010 Baume Mercier Watches 2010 Cartier Watches 2010 Chanel Watches 2010 Chopard Watches 2010 austria bangkok berlin best of 2008 Cheap Airfare, Hotels, Flights Hotels, Flights, Vacations Vacations, Cruises & Car Rentals sydney thailand things to do tokyo tours london lonely planet adidas shoes, air jordans iceland istanbul japan las vegas france germany grand canyon other link replica handbags replica handbags Replica Bags Replica Watches