Rdl file not updating

Question

I'm having a weird problem. I changed the prompt text for one of my report parameters in Layout view and I also changed the labels of the values for another parameter. When I do preview in VS 05 everything looks fine. I then take the rdl files and upload them on the machine running the report server via the Report Manager tool. When I view the report from the report server the old text appears. At first I thought that I did not upload the correct files, but that was not it.
I then opened the rdl file's source code (the XML code) in VS and I noticed that the old text is there not the new.

I think I'll try deleting the offending parameter and creating it again, as it seems VS has not generated the XML correctly.

Is there anything else I should try?

Answer 1

After deleting the parameters and creating them again, the prompt text is now correct. Still, the parameters are declared as Boolean, Multi-value and each value (True, False) has associated label. When I do preview on the development box (in VS) the parameters are shown as dropdown boxes with the correct labels being displayed.
On the report server, the parameters show as radio buttons instead of dropdown box and the labels do not appear. (It shows True,False instead of Active,Inactive).

Answer 2

Have a look at this bug posted on the microsoft Connect site https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=299372

What versions of Visual Studio and SQL Server Reporting Services are you using on your client dev machine and on the report server?

---

Adam Tappis. (MCSD VB6 & .NET, MCDBA SQL 2000)

Answer 3

VS 2005 & SQL Server 2005 on both  machines.

Answer 4

That kind of looks related to what I get. Still on my report the labels do not show either, which is the main problem for me because I'm not trying to modify the default values, just the labels.

Answer 5

Check this link which talks about some details on how the parameters properties can be changed for a published report
http://msdn.microsoft.com/en-us/library/ms155908.aspx
In your case, did you change parameter properties directly on server(through report manager) after you published the report initially?

Answer 6

Initially I did not. I had the parameters show true / false but later changed the labels on my development machine to show / hide. When I uploaded the new reports the change did not carry through. Then I started trying things. One of the things I tried was checking / unchecking the default value for the parameters, but that did not seem to affect anything. I don't see how is this article relevant to my situation because I'm trying to modify the label of the value. For example, I have the following prompt:

Extended Results: Show  Hide

What I get now is this:

Extended Results: True  False

Answer 7

I see, that's probably because you have the data type set up as boolen. I beileve in this case you don't get to change the labels associated with true and false. Insteaqd you need to set up your parameter as a string and then provide the 2 values with labels. This will then appear as a dropdown list as opposed to radio buttons.

It's a limitation of SSRS parameters. If you want anything more sophisticated then you have to start looking into presenting the parameter choices manually.

---

Adam Tappis. (MCSD VB6 & .NET, MCDBA SQL 2000)

Answer 8

Yes the data type is indeed set as boolean. The interesting part is that on my development machine when I view the report in Preview mode, the labels do display correctly and the report runs just fine. The problem only occurs on the report server.

I'll try declaring the parameters as strings and then converting them to Boolean somehow.

Answer 9

It appears that others have also noticed this behaviour:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/d9f79197-5e5c-463c-b74d-6a835d7ce3fd/

Sounds like a bug to me. I'll have alook at the Connect site...

---

Adam Tappis. (MCSD VB6 & .NET, MCDBA SQL 2000)

Answer 10

Does this resolve your issue?

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=391241

---

Adam Tappis. (MCSD VB6 & .NET, MCDBA SQL 2000)

Answer 11

Yes, that's seems to be it. Thanks Adam. I've been beating my brains out to get this.

Answer 12

Glad I could help. I'd appreciate if you could mark the post as an answer. Thanks.

---

Adam Tappis. (MCSD VB6 & .NET, MCDBA SQL 2000)