Dynamically suppress

[Former Member]

Hi All,

I have a field and field label in a row format. I need to suppress the field label and the field when the field value is blank.Also, I have other rows below this row. When this row is suppressed, there should not be any white space showing up instead the below rows should be displayed in place of the suppressed row.

Any suggestions would be of great help.

Thanks in advance for the help.

Naresh

[Former Member]

Hi,

Try to put this row in a seperate section.Field label you can suppress using section expert by giving condition if filed value is null.

If there is nothing in that section,you may use the option suppress blank section.

I hope this will work.

[Former Member]

hi all,

i have one question regarding suppress the blank space.

in the report, i am displaying 2 columns which are 1. list of questions and 2. percentage of modification for each question(calculated internally not taking directly from the db)

i have a property called mandatory question.

In data base, its Boolean field. for each question it has a value( 0 or 1).

if user enables that property, report will show only mandatory question list not all.

so i have added a condition in Section Expert -> Suppress(no-drill down) -> if ({Answers.isMandatory}) = true then false else true;and i checked suppress blank section also.

but still blank space is getting added in the report.

how to do this..

[Former Member]

HI,

Need more information,

How many columns are there in a single raw?

In the case of multiple cloumns, do we need to suppress other columns depends on the particulr fields?

what will be the values of the next raw?If it is the next value of same field, why you need to supress the field label?

Try this once

GO to Selection expert->Detail

Check the Suppress(No drill down)-> Click on X-2 buttom(Formula Editor)

Write

IsNull({DB.Field1}) or  ltrim(({DB.Field1})=""

Save and Close(Back to Selection Expert)

Check 'Suppress Blank Setion' check box

Hope this will work. If not, Clear my doubts

Regards,

salah

Edited by: salahudheen muhammed on Aug 25, 2009 7:45 AM

[Former Member]

Hi Salah,

Thanks for the suggestion. I'll check your suggestion and get back.

As for more information, here is the detailed description. I have the data in the below format:

Employee Number 100

Employee Name ABC

Department 100K

Manager XYZ

Product Product Description Sales

-

---

1 AB Wires 1000

2 Cable pr 950

3 Tapers 200

So, when the Department has a blank value, the Department row should be suppressed and the following rows should be displayed as below:

Employee Number 100

Employee Name ABC

Manager XYZ

Product Product Description Sales

-

---

1 AB Wires 1000

2 Cable pr 950

3 Tapers 200

Please suggest on the above. Thanks again.

Naresh

[Former Member]

Hi Naresh,

Put your First 4 raws on diffrent detail section.

Details a:Emp No

Details b:Emp Name

Details c:Dept

Details d:Manager

And do the above given steps in to all the details sections seperatly. That will work for you

Hi SMTendral,

In your case, Why you go with Suppressing functionality. You can filter your data with 'select expert' know?

Any way, try once through suppressing both fieds seperatly, with same condition.

If not working, add it as a new thread for better responds

Regards,

salah

[Former Member]

thanks for ur suggesstion.

i have added the condition in report selection formula and its working fine.

[Former Member]

Thank you all for your suggestions.

The suppress option is now working

Naresh