How to hide a table header on a RTC report

Alisha
Alisha Member Posts: 217
edited 2010-11-29 in NAV Three Tier
Any ideas?

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


Thanks!

Comments

  • matttrax
    matttrax Member Posts: 2,309
    What is the business need? It sounds like a silly request to me.
    Matt Traxinger - ArcherPoint
  • Alisha
    Alisha Member Posts: 217
    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
    ara3n Member Posts: 9,258
    every row in RTC report has a visibility property where you can specify if it's visible or not based on expression.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Alisha
    Alisha Member Posts: 217
    I've tried all the possible expressions I can think of, and it doesn't work with headers, only with the normal Rows.
  • Belias
    Belias Member Posts: 2,998
    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)
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • deV.ch
    deV.ch Member Posts: 543
    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.
    My Blog

Categories