New Features in Reporting Services 2005

  • VincentRainardi

    SSCrazy

    Points: 2905

    Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/vRainardi/3024.asp

  • mitul surti

    SSC Enthusiast

    Points: 127

    Thats an interesting Piece of information

  • Mary Eckmeier

    Valued Member

    Points: 64

    Keeping the headers when scrolling is a great new feature. I did find that my default report template uses a "transparent" background and as a result when scrolling, the header data appeared to be typing over the text of the report. To fix this problem, just set the background color of the header line to "white".

    mary

  • vidya sagar reddy

    Grasshopper

    Points: 24

    Hi,

    May I know which version of SQL Server 2005 has this functionality. I have SP2 and i dont see this feature in the Visual Studio when i try to Design a report.

    Please Suggest.

    thankyou

    Vidya

  • jhasbufuidh

    SSC Eights!

    Points: 992

    Hi,

    Regarding the interactive sort, What would be the best way to set the initial sort order?

    - Sort the data at the database level with ORDER BY in the query (temps db space increase, performance issue)

    - Set the initial sort order at the report level (How? is it faster or slower than doing so at DB level?)

    Tanks,

    Philippe

    BI Guy

  • Ian Dell

    SSC Enthusiast

    Points: 166

    We're been using these feature in our internal reports for about a year now, and have found a number of interesting results.

    - Set the sort order in the report, as this will put less load on the DB. Depending on the amount of data returned in the query, will govern which order is quicker for you. So test in your reports to find out. Must of our reports do not return too large a result, so we try and set the sort order in the report as part of our standards. (Most of the time

    But give the user the ability to order by any column, and let them know which is the default sort column! Again, users have found this a great help on their reports.

    Also be careful on report exports to excel, as excel will not keep the table header row visible when scrolling down even if this is enabled on the web page!

    Hope these help.

  • Ben Holcombe-270296

    SSC Eights!

    Points: 906

    One problem I noticed with this is when you enable "Header should remain visible while scrolling" and use a document map the links on the document map do not take into account the scrolling header.  When you click on a link in the document map the line is aligned at the top of the screen which is behind the scrolling header. 

  • F. Dwarf

    SSCommitted

    Points: 1538

    I'd add that the "header should remain visible" behaviour can also be applied to columns. In a table region you have to select the column and in the properties tab (F4) set "Fixed Header" to True and you're done.

    In a Matrix region you set the "header should remain visible" property to the group, as described in the article.

    best regards!

  • vishrutirdesai

    SSC Veteran

    Points: 213

    hi,

    when i select the property "header should remain visible while scrolling" it works fine.

    but the problem i got : when there is no data onto the report it displays the javascript error on the left corner of the browser "line : 16

    char:634

    Error:object Required

    code:0"

    kindly guide me...

    thanks,

    vishruti.

  • opdaniel

    SSC Enthusiast

    Points: 147

    Uncheck the option "Header should remain visible while scrolling" from Table Properties.

    That worked for me 🙂

  • steve.troiano

    Grasshopper

    Points: 20

    Does anyone know how to do affect the same scrolling header with a "Page Header"?

    Seems to me like a fundamental requirement, yet I can't get it to work. My report consists of several similar, yet different tables, so I can't place them all in one table, but I'd like the page header to remain while scrolling.

    Since a text box doesn't offer this functionality, and a table or matrix is not permitted in a page header, I'm kinda in a jam. Also tried placing just a simple one column table at the top of the body, but it only survives a scroll until the detail or footer row scrolls off. Also tried taking the "Header Table" mentioned above, and dragged the footer over the entire report - this worked in the VS Preview, but broke everything once deployed to RS server. Am I missing the obvious??

    Thanks in advance.

  • F. Dwarf

    SSCommitted

    Points: 1538

    I don't know. I had to tell my customer that the task cannot be accomplished with reporting services and they believed me XD

  • opdaniel

    SSC Enthusiast

    Points: 147

    steve.troiano (3/6/2008)


    Does anyone know how to do affect the same scrolling header with a "Page Header"?

    Seems to me like a fundamental requirement, yet I can't get it to work. My report consists of several similar, yet different tables, so I can't place them all in one table, but I'd like the page header to remain while scrolling.

    Since a text box doesn't offer this functionality, and a table or matrix is not permitted in a page header, I'm kinda in a jam. Also tried placing just a simple one column table at the top of the body, but it only survives a scroll until the detail or footer row scrolls off. Also tried taking the "Header Table" mentioned above, and dragged the footer over the entire report - this worked in the VS Preview, but broke everything once deployed to RS server. Am I missing the obvious??

    Thanks in advance.

    I am not sure I understand completely your inquiry but I think you can accomplish your needs by two simple settings in table properties: "Repeat header rows on each page" and "Header should remain visible while scrolling". These settings are in "General" tab, in table properties window.

    /daniel

  • steve.troiano

    Grasshopper

    Points: 20

    As mentioned in my post, those settings are functions of a table or a matrix - not a page. Therefore, unless your entire report is a single table or a single matrix, this settings are of no help.

    Once your table with those settings scrolls off the page, and possibly into a subsequent table, the header is gone.

  • james.taylor

    SSC Rookie

    Points: 25

    vishrutirdesai (12/24/2007)


    hi,

    when i select the property "header should remain visible while scrolling" it works fine.

    but the problem i got : when there is no data onto the report it displays the javascript error on the left corner of the browser "line : 16

    char:634

    Error:object Required

    code:0"

    kindly guide me...

    thanks,

    vishruti.

    vishruti,

    I have a solution for this for you that I'd like to share (other than simply turning it off - like the doctor who says just don't do that). Took me awhile to first of all figure out what was causing this problem (this post pointed me in the right direction, and is 100% correct that a fixed header without data in the table will cause this error, thanks).

    To get around this problem, I came up this solution:

    1. in your sql that populates each table in your report, add a UNION clause which will add a dummy record only if the main clause doesn't have any records.

    here is some sample sql that I used in my case:

    select * from vPersonScores

    where personID = @PersonID

    union

    select -99, null, null, null, null, null, null, null

    where (select count(*) from vPersonScores

    where personID = @PersonID) = 0

    2. in the table properties, set the visibility.hidden property to check for valid records only, something like so:

    =iif(Sum(Fields!PersonID.Value, "Scores") > 0, false, true)

    3. remember to re-set the Fixed Header property back to True.

    Now this will work fine even if the main table resultset is empty. I also created another textbox field to indicate if there were no records returned using the same logic on the visibility.hidden property, only in reverse. Hope this helps.

    Cheers

    JT

Viewing 15 posts - 1 through 15 (of 21 total)

You must be logged in to reply to this topic. Login to reply