Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts

Wednesday, July 02, 2008

SQL 2005 32 bit on Vista 64 bit

I've decided to upgrade my work system to Vista 64bit (mainly due to larger memory). As I go on installing stuff, i keep running into various issues which I'll try to post here.
SQL 2005 Developer Edition (32 bit).
First issue is with the compatibility check-list - namely IIS and ASP.Net

This KB article outlines which features need to be turned on Vista in order for Reporting Services to work.

This link describes how to fix ASP.Net by running following:
cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1

Wednesday, August 15, 2007

Open linked report in new window

Unfortunately, there's no simple way to open linked-report in new browser window. The work-around is to use the URL link, rather than report, however that has couple of issues. (a) you have to specify the location, which is a problem if you have dev/test/live environments (basically you have modify the report for each). (b) passing parameters is possible, but can be tricky in case you're passing complex texts.

Here is detailed solution.

In short:

Non-parameterized Solution
="javascript:void(window.open('http://servername
/ReportServer?%2freportFolder%2freportName&rs:Command=Render'))"



Parameterized Solution
="javascript:void(window.open('http://servername
/ReportServer?
%2freportFolder%2freportName&rs:Command=Render
&MyParam1=" & Fields!MyField.Value & "'))"

Couple things to know:

1) Notice that you have to use "http://server/
ReportServer" and NOT the "http://server/Reports" link!

2) In case your "reportFolder" and "reportName" contain spaces, either leave them there or replace them with "+" (e.g. "My Report" -> "My+Report").

3) Notice the "
&" in parametrized solution - it's safer to use than "+", because it will force string conversion on the parameter value.

4) There are more parameters you can use to modify the way the report is presented. Nice description is in this MSDN article.