RS and XSLT, pt3.3: Using XSLT for Custom Reporting Services Output
We recently returned to the discussion of using XML style transforms to format flat file output from Reporting Services. The report we created was pretty basic, so let's look at something more complex: a fixed format.
Let's say the client has given us the following file format, and we've trimmed the data in the SQL query to make sure it doesn't exceed the data width: