January 2, 2008 at 2:27 pm
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
January 7, 2008 at 3:24 pm
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
January 7, 2008 at 4:16 pm
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.
January 7, 2008 at 4:19 pm
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