delete the entire row if data is not present??

How to delete the entire row if data is not present in row?? Example , if somedata is null , how to delete that row, so that it consumes no data??/

Find more posts tagged with

Comments

madhu_2009

Try to put a filter while retrieving the data from the database.. this is one of the way to eliminate null values..

rashad01

Hi Madhu,

I dont want to get rid of null values.. In a report, when using table layout, a row, if it fetches no data from database then instead of showing blank space should get deleted. It should not counsume any space. There is a similar function used in e-spreadsheet known as delete() function.

tuan

I have similiar requirement for my report. I want to delete (suppress) the entire row or section when the field value is null or empty. Anyone has a solution for this?

Thanks,
Tuan

mwilliams

Hi Tuan,

Either a filter or a visibility expression should work for you to not show the entire row if one of the values is null.