Remove null or empty fields

ngaheer · Post by **ngaheer** » Sat Jun 28, 2008 2:19 am

Hi,

If I had address1 and address 2 and address3 on three separate lines in one databand, if only address 1 and address3 is filled in, then do not make an empty line space for address 2. My requirement is as following

Example:

I have three fields in a databand as in the following order

Address1
Address2
Address3

If only address1 field has data and other two field has not any data, so how can i remove the empty space for other two fields in preview of report.

Thanks.

Brendan · Post by **Brendan** » Sat Jun 28, 2008 6:10 am

Hi,

Try this thread and see if it helps

http://forum.stimulsoft.com/Default.aspx?g=posts&t=1272

ngaheer · Post by **ngaheer** » Mon Jun 30, 2008 7:15 am

Hi,

I see your forum that is working but my need is still pending. Let me explain you.

Address1(Data exist)
Address2(Data not exist)
City (Data Exist)

yes it populating as follows:

Address1
City

But it displayed the third line space is still displayed.

I dont want to see the blank space line.

it displayed output like following:-

First record:-
3 Cedar
NY
BLANK LINE(EMPTY SPACE)

Second record:-
395 Cedar
Lawn Avenue
NY

Third Record:-
Lawn Avenue
NY
BLANKLINE

So i dont want to show the BLANK SPACE LINE so can you plz guide how to resolve this issue,

Thanks.

Post by **Edward** » Mon Jun 30, 2008 12:56 pm

Hello, Nqaheer.

Please send you report template (*.mrt file) to support[at]stimulsoft.com and we'll provide you a solution.

Thank you.

ngaheer · Post by **ngaheer** » Tue Jul 01, 2008 1:11 am

Hi,

I have sent the report template (.mrt) at support@stimulsoft.com. Please check it.

Thanks.

Post by **Edward** » Wed Jul 02, 2008 4:26 am

Thank you for the report.

The issue was fixed by setting of the 'CanShrink' DataBand's property in true.

Thank you.