SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

JSSUG Speaking Event: Reporting Services 2008

We had a great group of about 35 people last night at the JSSUG (Jacksonville SQL Server User Group) meeting. If you missed it I spoke on Reporting Services 2008. I called the presentation Introduction to SSRS 2008 but we focused mainly on the new features in 2008. If you would like the slide deck just email me or it should be posted at www.JSSUG.com shortly.  If you have any question about it feel free to email me.
Some of the top features we highlighted were:
  1. Reporting Services without Internet Information Services (IIS)
  2. New Word export option
  3. Redesigned Report Builder
    • Data pane
    • Smart tags
    • Grouping pane
  4. Tablix
  5. Gauges and Charts

I really would suggest getting a head start on getting used to the new reporting environment in either Report Builder or BIDS. Here's the link to download both: http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx

There are two separate downloads so make sure you download the feature pack as well to get Report Builder 2.0. Report Builder has changed drastically from the past and had almost every capability of BIDS.

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).


Posted by aponduri on 10 January 2011

Hi Devin,

I attended some of your classess on SSRS. they are very helpful. I know that this is a wrong thred to post my question. I am stuck with an issue and unable to find any information. Hope you can provide me with some suggestions.

My issues is

Data Source :SSAS 2008 R2

Report Type :Matrix (Drill Down)

I have a report

Year :2010

Jan Feb March April Avg(last2 months)


Sub Acc1 1 2 1 2 (2-1)=1

Sub Acc2 2 1 1 1 0


Sub Acc2 3 3 1 1 0

Sub Acc 1 4 4 1 3

I am able to create the report create totals , sub totals etc, my issue is the population or calculation of the last column “Avg” last column depends on the parameter (EndMonth), it is always  EndDatevalue –EndDate-1.value.

Is there a way that I can get to that column

I tried to first display the last 2 columns but could not get to that. I tried

=IIF((Format(CDate(Fields!MonthFirst.Value), "yyyyMM"))=Parameters!ToDimDateYearMonth.Value,0,IIF(IsNothing((Fields!Orders.Value)), 0,(Fields!Orders.Value)))

Is there a way to get the last column.

Any suggestions are highly appreciated.



Posted by knight_devin@hotmail.com on 11 January 2011

It's kind of hard to visiualize can you send me some screen shots.

Posted by aponduri on 11 January 2011

Hi Devin,

Thanks for a Quick response, I sent a mail to "knight_devin@hotmail.com " wit the screen shots.

Thanks for your help,


Leave a Comment

Please register or log in to leave a comment.