How to hide a table header on a RTC report

Alisha

Any ideas?

When there are no rows, the header still appears, and I don't want it to...


Thanks!

matttrax

What is the business need? It sounds like a silly request to me.

Alisha

I have a report with 2 sections, showing different VAT Entries (Sales & Purchases). Each section has its own header, but the Purchases one appears even if there are no Purchase VAT Entries...

ara3n

every row in RTC report has a visibility property where you can specify if it's visible or not based on expression.

Alisha

I've tried all the possible expressions I can think of, and it doesn't work with headers, only with the normal Rows.

Belias

did you already try to set TRUE to the hidden property? because it works, no matter what...
anyway, a common error is to confuse the hidden property value:

if you want to show the header, the property must be false (hidden = false)
if you want to hide the header, the property must be true (hidden = true)

deV.ch

You should always get the primary key of a dataitem used in thre report. so if that PK is a integer value you could Sum it up and then use somethink like this:

=(Sum(Fields!YourTable.YourPK)=0)

if you have no data in the dataitem you should get no row with a value in the pk, so the sum up of all would be zero and the exp. in hidden property is TRUE

BTW: i never tried sum in a header row but i think it should work.