SSRS Report Parameters disabled

Question

0.00/5 (No votes)

See more:

So here is my question. I have a standing SSRS Report that gets displayed in a DIV on the Web. Now I recently upgraded SQL to 2012 and since then only some of my reports when I run them cannot be run on the web side as the parameter are all disabled. Here is what I have done/checked for:

▓ The DataSource on all is correct (Shared Data Source)
▓ When I run the sps required to populate the given parameter fields it works 100%
▓ When I test on my local and beta site (Different servers) it works 100% and you are able to choose the different required parameters
▓ When I debug from my local pointing to the Live server it works 100%

So does anyone have any idea/solution to why only on the Live server does only some of the parameters not work. Any help much appreciated

Posted 5-Jan-15 2:37am

CBadger

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CBadger · Accepted Answer · 2015-01-14T00:47:00

Solution 1

I will add the solution in case someone else might also need to see this.

Turns out that the reference to the reportBuilder still had a reference in from the older version. When this was removed it worked 100%. But there is no rhyme nor reason to why this happened and why removing this worked :-)

Posted 14-Jan-15 0:47am

CBadger

Comments

Member 12467581 17-Aug-16 4:48am

Hi CBadger. I'm having this same problem. Please could you clarify what you did to fix it? thanks

CBadger 22-Aug-16 1:15am

There is an actual reference in the web.config that links to the report server version you are using. You just need to ensure this is updated to the correct version and shows it. Mine still displayed to the old version. (Version & PublicKeyToken)

add assembly="Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"