Thursday, April 5, 2012

SSRS 2012

With SQL Server 2012 being released there is lot of new features all across the board which are being studied and used. The mechanisms to pull data and use data in different ways is ever exploding. SQL Server Reporting Services 2008 and 2008 R2 were good releases where in SSRS started to being looked at as a reporting tool with good features and capability. SSRS 2012 has an increased set of features, Microsoft has listed the main highlights of the new product. Sharepoint is also getting lot of traction in lots of companies these days. In order to look at what is new in SSRS 2012, here is a link:
http://msdn.microsoft.com/en-us/library/ms170438.aspx
I am planning to start working with the evaluation version of SQL Server 2012 and keep abreast of what is being offered.
As a side note: I am including a nice article on how to land a job as a developer: This appeared in SQL Server Central as well.
http://blogs.msdn.com/b/thebeebs/archive/2012/03/30/6-189-tips-for-landing-a-developer-job.aspx?CommentPosted=true#commentmessage.

4 comments:

  1. Hi ram
    i want to know how to pass multi value parameters to ssrs 2005 using mysql ODBC

    Single value is working,iam used this function in dataset

    =JOIN(Parameters!course_code.value,",")

    How can i pass multi value parameters
    please tell me

    Thanks in advance
    Srujitharam

    ReplyDelete
  2. Hi sivaram,
    Are you using a stored procedure in your dataset or is it a sql statement. In case of a sql statement in the Where clause you need use a IN clause for example:
    It would be WHERE productype IN [@producttype], @producttype would be the report parameter. Let me know, my personal email id is ramdas.jaya@gmail.com

    ReplyDelete
  3. Hi Ram,

    I am using SSRS 2008R2. My issue is I have a large report that I am trying to export to excel. But I keep getting the "Excel Rendering Extension: Number of rows exceeds the maximum possible rows per sheet in this format; Rows Requested: 68563, Max Rows: 65536 (rrRenderingError) ---> ".Is there something I need to do to get around this problem. The excel I am trying to export it to is excel 2007.

    Thanks
    Reeba

    ReplyDelete
    Replies
    1. Hi Reeba,
      Try exporting the data to a csv file format and see if you can export the data.
      Second option is try exporting a limited number of rows say 5000 to excel and see if that works. If not try reinstalling excel 2007 or excel 2010.

      Delete