Wrox Programmer Forums
|
BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7
This is the forum to discuss the Wrox book Professional SQL ServerReporting Services by Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney; ISBN: 9780764568787
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 18th, 2005, 12:48 PM
Registered User
 
Join Date: Mar 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Suppressing Blank Lines?

I've been stumbling on this for too long and need some help. I'm very new to Sql Reporting Services .. 1 day actually doing anything with it.

Add1 = "120 Main St."
Add2 = ""
Add3 = ""
City = "City"
State = "ST"
ZIP = "11111"

I need it to show up as:

121 Main St.
City, ST 11111

I'm having problems removing the blank Add2 and Add2.

I'm sure this is very simple to do, could someone please explain it to me.

Thanks,

- Vince

 
Old April 19th, 2005, 08:20 PM
Registered User
 
Join Date: Mar 2005
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello and good luck with the Reporting Services

I have a mail label report that has to do this also, so i would combine the add1, add2 and add1 into the one field/textbox and use the following expression:

=Fields!Add1.Value & iif(Fields!Add2.Value = "" ,"", vbcrlf) & iif(Fields!Add2.Value = "" ,"", Fields!Add2.Value) & iif(Fields!Add3.Value = "" ,"", vbcrlf ) & iif(Fields!Add3.Value = "" ,"", Fields!add3.Value)

This will always show (not supress add1, but suppress add2 and/or add3 is blank)

And you should be able to work out how to do the second line.

Hope this helps

Blowinoil






Similar Threads
Thread Thread Starter Forum Replies Last Post
Suppressing content fatex9994 Crystal Reports 0 November 20th, 2006 01:30 PM
Blank Lines DAnne XSLT 1 July 31st, 2006 01:53 PM
Blank Lines DAnne XML 0 July 20th, 2006 11:10 AM
Suppressing login KiwiMark .NET Framework 2.0 0 June 13th, 2006 10:58 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.