It’ll Be Cool

I’m Brian Welcker, Group Program Manager for SQL Server Reporting Services. I was doing a webast last week on the new Report Viewer controls in Visual Studio 2005 and during the question and answer phase, someone asked me if the sample code would be on my blog. My response was that I didn’t have a blog. Then I though “why not?” I have always loved to write and I spend lots of times answering questions on the newsgroups. I think I simply felt like I couldn’t do a “proper” blog. I’m not one to do things halfway and I never felt I could post with any reasonable frequency. Nonetheless, I’ll do my best to keep you up to date on what’s going on with me and my areas of interest.

Most of the contents here will be about the product I work on, SQL Server Reporting Services. If you haven’t given it a try, I would encourage you to do so. I will might throw in a little music, politics, or games (I have a level 45 paladin in the Dragonblight realm of WOW). Don’t look to me for lots of code samples (it’s been close to 10 years since I’ve written production code) but I’ll try to give you some tips and tricks and some insight into the innerworkings of Microsoft product development. If you have specific topics you would like me to blog about, feel free to suggest them.

Comments (2)

  1. Far says:

    Hi Brian,

    I desperate need help about putting row headers and iteractive sorts on a matrix – the way that report builder does AUTOMATICALLY.

    But I can not figure out how to it when I build a reprot manually!

    So to demonstrate this, get adventureworksDW, then make a model, deploy it, bring it up in report builder to do a matrix -cross tab.

    Now put Product and Product subcategory as row data, the column data can be "English County Name", and the count data can be anything with a number like unit price.

    filter on subcategory bikes

    run report

    see that the row columns have headers and sort button. That is waht I am trying to do on my own.

    I tried doing an interactive sort on the matrix corner for the first field, that worked. No header but I got sort button in the matrix corner and the sort worked for Product. This is what Teo Lachev had recommended.

    But I want my report to look like the one from report builder.

    I tried view the rdl for the report that the report builder built but I can not find the actually report. It deployed it in the Home folder so I can see it in the report server. But I can not find it to see what it’s rdl says and do a comparsion.

    Please help. I have spent 3 months on this problem and I am tired.