Parameters in Report Header not displayed after upgrade to 2005

  • Hi there,

    I just recently upgraded my server to SQL 2005 from 2000. When I open any RDL file, I am prompted to convert the file. Ok, fine. The problem I am having is that in my reports, the headers are filled with parameters based on the various datasets returned when the report is generated. When I preview the report - I get no data where the parameters should be. Just blank space. Is there some kind of trick about parameters in headers in this version? I have looked and looked, so any help would be great!

    Thanks!

    Leigh

  • To the best of my knowledge there is no such thing as a Report header in SSRS. Can you clarify that you are talking about a Page Header? Or have I been missing something all this time?

    Cheers

    Andrew

  • Yes, I mean page header.....I guess that's why no one has any ideas for me. Sorry about that! I think I figured it out - I had to change all the parameters to allow nulls and now everything is working as expected.

  • Good pickup...and well done for posting the solution 😉

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

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