SSRS No Rows message

  • Hello...I'm stumped! I have defined my No Rows message in the tablix as 'Currently there are no Courses for this Student', but the No Rows message that displays is the old version defined as 'Courses do not exist for this Student.' I could use either message, but it doesn't help me to understand why my current message is not displaying. I have checked and re-checked the tablix properties and I just can't figure this out. Is there another place I should be checking?

    Dana

    "Drats! Foiled again!"
  • Sounds like some caching. Does it appear the same even after closing BIDS and reopening? Or even clearing the cache file in the project directory?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR (12/28/2012)


    Sounds like some caching. Does it appear the same even after closing BIDS and reopening? Or even clearing the cache file in the project directory?

    Hi Jason,

    I thought of that too but it doesn't seem to be the case...it's the same after closing and reopening BIDS, and even after restarting last night.

    Dana

    "Drats! Foiled again!"
  • Try deleting the cache file from the project directory.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply