Subscribe to this blog
Briefcase
Print
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:
-
Reporting Services without Internet Information Services (IIS)
-
New Word export option
-
Redesigned Report Builder
-
Data pane
-
Smart tags
-
Grouping pane
-
-
Tablix
-
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.
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)
Account
Sub Acc1 1 2 1 2 (2-1)=1
Sub Acc2 2 1 1 1 0
Account2
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.
Thanks
Devi
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,
Devi