Tuesday, March 24, 2009

Enabling Dundas reports in VS2005

I often times create graphs for SCOM and other reporting needs, and have come to appreciate the cleanliness of the Dundas reporting widget included in SCOM. below are the steps needed to setup the tools, inspired by http://blogs.msdn.com/eugenebykov/archive/2007/11/20/enabling-enterprisemanagementchartcontrol-in-visual-studio-2005.aspx

  1. Copy the files MicrosoftRSChart.dll and MicrosoftRSChartDesigner.dll from the SCOM reporting server to %programfiles%\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
  2. Edit %programfiles%\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\RSReportDesigner.config and enter the following in the Extensions section


  3. Type="Dundas.ReportingServices.DundasChartDesigner,
    MicrosoftRSChartDesigner" />



    Type="Dundas.ReportingServices.DundasChart,
    MicrosoftRSChart" />



    Type="Dundas.ReportingServices.RSChartConverter,
    MicrosoftDundasRSChartDesigner" />
  4. Restart VS 2005
  5. Drag and drop MicrosoftRSChart.dll from the PrivateAssemblies directory onto the VS Toolbox and the new chart type will appear

Wednesday, March 18, 2009

Running Office 2007 in Ubuntu

MS Office 2007 is the best in the world, and nobody (even openoffice) has come close to functionality of it. Now it looks like we can run it in Ubuntu without issue, thanks to the directions found here: http://www.programmerfish.com/roffice-2007-in-linux

Quick breakdown of steps:
1. From a command prompt, run the following commands:
wget -q http://wine.budgetdedicated.com/apt/387EE263.gpg -O- | sudo apt-key add -

sudo wget http://wine.budgetdedicated.com/apt/sources.list.d/intrepid.list -O /etc/apt/sources.list.d/winehq.list

sudo apt-get update

sudo apt-get install wine cabextract
wine --version
wget http://www.kegel.com/wine/winetricks
chmod +x ./winetricks
./winetricks gdiplus riched20 riched30 msxml3 msxml4 msxml6 corefonts tahoma vb6run vcrun6 msi2

2. Insert the Office CD, or download the installer from http://www.programmerfish.com/free-direct-download-microsoft-office-2007
run:
wine pathToCD/setup.exe

3. Profit!

Your mileage may vary on this depending on the versions of software installed. I ran this process on a couple different systems and had different results each time. Hopefully this will become more stable as teh builds continue