Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 how to NOT print a blanks line in SSRS

Author  Topic 

AdamWest
Constraint Violating Yak Guru

360 Posts

Posted - 2010-06-08 : 12:53:55
I asked this in the SQL side but I am looking perhaps n SSRS there is a way to do this. This issue is in SSRS.

I want to print

Address1

Address2

Address3



But not leave a blank line if the field is empty… How can this be accomplished? use of a user defined function?

savior faire
Posting Yak Master

194 Posts

Posted - 2010-06-09 : 15:58:22
There is a way to do this. I am not at home so do not have access to BOL. I went to the MSDN web site and apparently Microsoft has reprogrammed the online documentation.
Has anyone been on that site lately? I have not been on it in quite some time. I am not impressed with it at all, in fact, I think it is horrendous and essentially an unusable resource.

______________________________________________
Talk sense to a fool and he calls you foolish.
Go to Top of Page
   

- Advertisement -