Wednesday, November 28, 2007

Microsoft Report Viewer 2008

If you want to use the Report Viewer that comes with VS 2008 you need this version 9 ReportViewer.exe installed on the server.

Note: you need to install .NET 3.5 first.

Download details: Microsoft Report Viewer Redistributable 2008

Monday, November 26, 2007

Visual Studio 2008

Installed Visual Studio 2008. 3.3GB download for the Pro version. Why so big? got me.
Overall, very impressed. The ListView control looks nice. "A repeater on speed."

Monday, November 12, 2007

IE7

Why can't IE7 remember what tab I was looking at last when I remove a tab!?! Firefox can!

Monday, November 5, 2007

Comcast Violates Net Neutrality. File Your Own FCC Complaint!

Yes, this is a blatant solicitation get people to sign this complaint, but Comcast deserves it and Net Neutraility is being violated! ....Today, Free Press filed a legal complaint demanding that the FCC take action to protect the free flow of information on the Internet. By joining our complaint, you can help stop Comcast and other gatekeepers.

read more | digg story

Friday, November 2, 2007

Deploying Reports and ReportViewer Controls

If you get this error:
"Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=8.0.0.0,"

You need to run this file on the server:
The ReportViewer control redistributable is a self-extracting file named ReportViewer.exe that includes an .msi and other files. You can find ReportViewer.exe at the following location: C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\ReportViewer\ReportViewer.exe.

Found the solution here:
Deploying Reports and ReportViewer Controls

SQL Server Reporting Services number of rows per page

Set a number of rows per page with the grouping trick:

Go to Table Properties - GroupsAdd a Row Group with the following function: =Ceiling(RowNumber(Nothing)/30)Make sure "page break at end" is checkedNow you have a set number of rows and with that a set vertical size(assuming text does not wrap).Make the control a little wider then needed and you should not have scrollbars (most of the time).


Found the code here:
SQL Server reportingsvcs ReportViewer control always shows scrollbars

Thursday, November 1, 2007

SQL Server Reporting Services RunningValue in a chart - scope issues

Using SQL 2005 and Visual Studio 2005 I wanted to show a cummulative series in a chart, plotted as a line. I had to add a "fake" series grouping in order to get it to work.

Found the solution here:

sqlserver reportingsvcs RunningValue in a chart - scope issues