Developing Matt

My Technical Journal

New Features of SSRS 2008

with 4 comments

I attended the class New Sq Server Reporting Features 2008 by  Jason Carlson. 

The highlights are below.  The full notes I have are here.  Due to legal constraints I’m not sure that posting the slides would be ok, but I’m leaving the references.

1.       Not hosted in IIS any more  (however it does use http.sys which means it can communicate with IIS).  It uses sql server networking stack instead. (?) There were many settings that they discovered that conflicted with report engine.  See slide on ssrs 2005 vs ssrs 2008 (page 6) to see architecture differences

a.       Settings not supported

                                                               i.      Isapi filter

                                                             ii.      Anonymous authentication

                                                            iii.      Digest authentication

                                                           iv.      Client certificates

b.      You can now pick your own root, not IIS’ root (graphs!)

2.       Memory managmement

a.       Dynamic self-monitoring under memory pressure

b.      Uses file system cache to adapt to memory pressure (receives memory events from server)

c.       Administer can set targets

3.       Suggested using sharepoint with it.

4.       Reports are now hierarchial cursor-based object model

a.       Rdl is exposed as an object model

                                                               i.      Object model reloads based on which group is shown (?)

5.       Report engine modifications

a.       Report processing is not on-demand (only grabs first page.  Expressions will never run until you get to that page)

b.      New rendering architecture

                                                               i.      Slide 17 shows architecture

                                                             ii.      They wrote all their own renderers

                                                            iii.      New word rendorer

6.       Report builder modifications

a.       Format updates to text, paragraphs, lists, etc.

b.      Can use [fieldname].  No need for “this text “ & field.bla.value & “ results in whatever”

c.       Tablix (multiple parallel row/column members at each level)

                                                               i.      Slides 28-33

7.       Other

a.       Still no css, but it is the number one request they receive

b.      Gauges can now be dropped into reportview and used and every series can have it’s own report type.

 

About these ads

Written by matt

May 1, 2008 at 10:42 am

4 Responses

Subscribe to comments with RSS.

  1. Hi,

    thanks for the notes. Do you have any more information about the RDL object model? Did Jason mention if this was going to be part of the final release for SQL Server 2008.

    thanks,
    james

    James

    May 22, 2008 at 2:05 pm

  2. I asked Jason about the object model…specifically if it was going to be any more visible. The problem we have is that you can’t access any of the report’s objects. You can access the printing, parameters…etc. (you can access the report engine objects)..but you can’t access the rdl object. It’s all encrypted. So jumping to a particular page or anything inside the report isn’t possible. The answer I received was no: it won’t be any more accessable than it already is.

    As far as if it’s going to be a part of the final release…I assume so, since it’s apparently in the ctp. link But I don’t have a solid answer for you.

    matt

    May 22, 2008 at 2:18 pm

  3. hi there,

    I am interested to share some information about my experience in setting up SSRS 2005 and SSRS 2008. I believe that most of you have already known the difference in between SSRS 2005 and SSRS 2008 and if you have not, you can simply visit Microsoft website (http://www.microsoft.com/sqlserver/2008/en/us/reporting.aspx).

    Some differences I notice are:

    1. SSRS 2008 is a lot easier to setup and configure. The Reports and the ReportManager folder are easier to configure and the integration with Sharepoint is a lot easier as well. I have had a chance to try the SSRS 2008 service with ASPHostDirectory (http://www.asphostdirectory.com) and they are able to setup my SSRS 2008 beautifully. I can remote connect to my SSRS and I can administer all my reports online.

    2. SSRS 2008 come with the newest Ad-Hoc queries and this feature is only available if you have SQL 2008 Standard Edition or above. My current host, ASPHostDirectory, supports Ad-Hoc query and I believe that they must have at least SQL 2008 installed. I do not have pretty much time to play around this Ad-Hoc report yet but what I can tell you is that this is a very powerful reporting tool.

    Keep up the good work, Microsoft!

    Al Pathew

    May 7, 2009 at 7:47 pm

  4. Can anyone assist with creating a multi-column report in SSRS 2008. Have spent hours browsing the internet, although there’s a lot of articles related to this – none of them work in Visual Studio 2005 or 2008.

    Regards
    Kevin

    kevin

    September 21, 2009 at 5:15 am


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: