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.
| Author |
Topic |
|
mic9000
Starting Member
2 Posts |
 Posted - 2009-05-21 : 02:38:30
|
| Configuration: report is deployed on report server and webpage accesses that reportThe code from aspx that hides parameters works fine; it's just the code that shows parameters that isn't working. Linked at [url]http://dropster.org/2zis55ifrw2r/Desktop.zip[/url]Please 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 serversee both projects Web app and RS project linked at http://dropster.org/2zis55ifrw2r/Desktop.zip (you really need only report to be deployed on RS server)Environment: Dev server: VS 2005 SP1, IIS6, DOTNET 2.0, Win2K3 server SP2Production 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 serverProduction 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 serverThanks in advance! |
|
|
mic9000
Starting Member
2 Posts |
Posted - 2009-06-01 : 10:38:03
|
| 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 http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=e7d661ba-dc95-4eb3-8916-3e31340ddc2c( 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. |
 |
|
|
|
|
|
|
|
SSRS 2005: Code to show(unhide) parameter doesn’t