Complex scripts in PDF

There is currently a bug in our SQL Server 2005 PDF renderer which may cause it to generate incorrect glyphs for text in a complex left-to-right script.  The reason this occurs is that we need to embed font glyph indices and metric information into the PDF document.  For text in a right-to-left complex script, we…


SQL Server 2005 SP2 Cumulative Update 4 is available

The latest SQL Server 2005 SP2 Cumulative Update (CU4) is now available.  You can get it by calling into customer support or by making an online request.   There are two fixes in the feature areas I own that are included in this update: (Bug ID 50001816) When you export a SQL Server 2005 Reporting…


Rendering reports via Url Access

Querying Reporting Services for a report couldn’t be easier with Url Access (  For example: String report = "/Folder/Report"; String filename = "Report.pdf"; List<KeyValuePair<String, String>> parameters =     new List<KeyValuePair<String, String>>(); parameters.Add(new KeyValuePair<String, String>("Param1", "Value1")); parameters.Add(new KeyValuePair<String, String>("Param2:isnull", "true")); System.Net.WebClient client = new System.Net.WebClient(); client.Credentials = System.Net.CredentialCache.DefaultCredentials; String url = "http://localhost/reportserver?" +     report +…


Unit testing a Katmai Reporting Services renderer

I am in the process of documenting the way my Katmai unit tests work.  There’s nothing inventive about them – they are straightforward and meant to get the job done.  I use the VSTS unit runner which works though not particularly well.  I do not go through the machinations of using and keeping up to…


PowerPoint Branching

I was experimenting with using PowerPoint to create self-guided training material and discovered the ability to custom slide shows.  I don’t know a whole lot about creating sophisticated PowerPoint decks, but this is a pretty nifty technique that is simple to apply.  It allows PowerPoint shows to contain a rudimentary branching effect. If we think…


Home wireless network

A week or so ago, I finally upgraded my home wireless network to 54MBit/s via 802.11g.  A bit of research led me to choose a Linksys WRT54GL v1.1 router.  The stock firmware didn’t support some of the features I wanted (like using DHCP to assign static IPs based upon MAC address) but there are several…


Vista: Open Command Window Here

Another useful but hard to discover feature of Vista’s Windows Explorer is the ability to shift-right-click on a folder and launch a command window at that path: Note that this trick only works in the viewing pane and not in the tree view.

Vista: Copy as Path

Useful but hard to discover feature in Vista.  To copy a filename with full path information to the clipboard, shift-right-click on a file and choose Copy as Path.  For example: Copies the following to my clipboard: “C:\dump\Reports\10435.rdl”


Reporting Services: PDF Renderer FAQ, part 2

This is a continuation of my work on FAQ for the PDF renderer.  A compiled version of these postings will will live at   File Size   Why are the PDFs exported from the Win/WebForms control so large? Compression of the PDF document is not supported in Visual Studio 2005 WinForms or WebForms controls running…


Reporting Services: PDF Renderer FAQ, part 1

I am working on a FAQ for rendering to PDF in Reporting Services.  This is my first installment, centered around font issues. A compiled version of these postings will will live at   Fonts   Have you first looked at our ‘Designing for PDF Output’ documentation? Reporting Services 2000: Reporting Services 2005:…