Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSRS 2005: Code to show(unhide) parameter doesn’t work from webpage

Status
Not open for further replies.

AllyPen

Programmer
Aug 9, 2001
36
0
0
US
Configuration: report is deployed on report server and webpage accesses that report

The code from aspx that hides parameters works fine; it's just the code that shows parameters that isn't working. Linked at find a simple report with 1 parameter without DB access, and an aspx page with 1 button to hide the parameter and 1 button to show the parameter

The hide/show buttons worked fine on the dev server, but show button doesn’t work on either of production servers.

Note that it works fine in if run application in VS as well (not on production because those don’t have VS installed) with access of report on report server

see both projects Web app and RS project attached (you really need only report to be deployed on RS server)

Environment:
Dev server: VS 2005 SP1, IIS6, DOTNET 2.0, Win2K3 server SP2
Production config 1: IIS5, DOTNET 2.0, Win2K server SP4, Reportviewer component dll in Bin directory that copied by VS from dev server, report deployed on Win2K3 server, SQL RS 2005 server
Production config 2: IIS6, DOTNET 2.0, Win2K3 server Ent SP2, Reportviewer component dll in Bin directory that copied by VS from dev server, report deployed on same Win2K3 server, SQL RS 2005 server

Thanks in advance!
 
Apparently copying reportviewer DLLs into BIN directory is not enough for some features to work due to bugs in Reportviewer component that was supplied with original .Net 2.0. Furthermore a SP1 to VS2005/.net 2 didn't address those issues and a special reportViewer SP1 needs to be applied/installed separately. While Production server did have reportviewer redistributive installed, the hotfix was not.
I installed the link make sure to choose a correct version Upgrade or Full) and unhiding params started to work. I also had to remove DLLs from BIN and restart webserver to take effect.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top