Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  Major bug in RS

Author  Topic  jhermiz 3564 Posts Posted - 2005-07-13 : 10:41:42 Create a report with some parameters using a stored procedure. Save the report and run it. You just realized that you need one or two other parameters that you need to add. You add them to your stored procedure as well as your report from the report parameters menu. You run the report and notice the results are not what you expected. You go to QA and everything is fine. You look at the xml of the rdl file and notice that the [Query] section of the [QueryParameters] is missing the newly added parameters. You end up having to write that XML out into the RDL. This has happened to me in the past, but back then I was rarely modifying reports on development and releasing back to production. With a lot of changes coming in this happens to me a lot. Somehow or someway RS looses touch with the RDL XML when adding additional parameters and I wonder if MS's rs team knows about this. What a pain, wasted a lot of time thinking somewhere in my sproc logic something was wrong. Ended up being this silly error! I thought after the first service pack this would have been taken care of. Just wanted to post this in case anyone else runs into something where everything was fine until you added more parameters at a later time. Keeping the web experience alive -- [url]http://www.web-impulse.com[/url] Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url]