SQLServerCentral / Discuss Content Posted by Vincent Rainardi / Article Discussions / Article Discussions by Author / New Features in Reporting Services 2005 / Latest Posts

RE: New Features in Reporting Services 2005

mspblr2000 — Tue, 16 Sep 2008 05:36:18 GMT

Hi,1.Open the matrix table property2. select the tab groups3.Select the matrix group from row or columns.4. Click Edit then un check the check box "Group Header should remain visible while Scrolling.Let me know if u get any problem.RegardsShiva

RE: New Features in Reporting Services 2005

beth-447786 — Sun, 14 Sep 2008 06:42:46 GMT

[quote][b]solson (3/26/2008)[/b][hr]Need related advice on 2 points: 1. In my table properties, I have the "Header should remain visible while scrolling" checked. I have changed my header row to white from transparent, and I am still getting a flicker when scrolling through the report.[/quote]I'm getting the same flicker effect - it is highly unpleasant, and I doubt our users will find it acceptable. We want to use RS instead of Business Objects for reporting whenever possible, but effects like this will kill that objective.If anyone has a solution to this, I would greatly appreciate it.regards, beth

RE: New Features in Reporting Services 2005

teresa.stewart — Thu, 04 Sep 2008 13:16:37 GMT

How do you get the "non scrolling headers" to work with a matrix?

RE: New Features in Reporting Services 2005

mspblr2000 — Mon, 11 Aug 2008 01:56:45 GMT

Hi, Give some message in the table property "NoRows". Then if there is no data it will display that message and it will not give any java script error.RegardsShiva.

RE: New Features in Reporting Services 2005

solson-689723 — Wed, 26 Mar 2008 15:59:03 GMT

Need related advice on 2 points: 1. In my table properties, I have the "Header should remain visible while scrolling" checked. I have changed my header row to white from transparent, and I am still getting a flicker when scrolling through the report.2. In same table, when I use the interactive sort option, and set my field, the functionality doesn't work.Any thoughts or help is greatly appreciated!

RE: New Features in Reporting Services 2005

arunsingh84 — Wed, 26 Mar 2008 03:43:13 GMT

I am also facing the same issue. Did u get the solution for this???Thanks

RE: New Features in Reporting Services 2005

james.taylor — Tue, 11 Mar 2008 13:35:48 GMT

[quote][b]vishrutirdesai (12/24/2007)[/b][hr]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 : 16char:634Error:object Requiredcode:0"kindly guide me...thanks,vishruti.[/quote]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 vPersonScoreswhere personID = @PersonIDunionselect -99, null, null, null, null, null, null, nullwhere (select count(*) from vPersonScores where personID = @PersonID) = 02. 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.CheersJT

RE: New Features in Reporting Services 2005

steve.troiano — Thu, 06 Mar 2008 21:03:46 GMT

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.

RE: New Features in Reporting Services 2005

opdaniel — Thu, 06 Mar 2008 20:57:24 GMT

[quote][b]steve.troiano (3/6/2008)[/b][hr]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.[/quote]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

RE: New Features in Reporting Services 2005

F. Dwarf — Thu, 06 Mar 2008 14:39:02 GMT

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

RE: New Features in Reporting Services 2005

steve.troiano — Thu, 06 Mar 2008 13:36:24 GMT

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.

RE: New Features in Reporting Services 2005

opdaniel — Thu, 28 Feb 2008 15:57:46 GMT

Uncheck the option "Header should remain visible while scrolling" from Table Properties.That worked for me :)

RE: New Features in Reporting Services 2005

vishrutirdesai — Mon, 24 Dec 2007 02:50:38 GMT

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 : 16char:634Error:object Requiredcode:0"kindly guide me...thanks,vishruti.

RE: New Features in Reporting Services 2005

F. Dwarf — Tue, 04 Dec 2007 10:23:04 GMT

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!

RE: New Features in Reporting Services 2005

Ben Holcombe-270296 — Thu, 21 Jun 2007 07:39:00 GMT

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.

RE: New Features in Reporting Services 2005

Ian Dell — Fri, 15 Jun 2007 05:06:00 GMT

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.

RE: New Features in Reporting Services 2005

Philippe Cand — Thu, 14 Jun 2007 11:53:00 GMT

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

RE: New Features in Reporting Services 2005

vidya sagar reddy — Thu, 14 Jun 2007 10:57:00 GMT

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.thankyouVidya

RE: New Features in Reporting Services 2005

Mary Eckmeier — Thu, 14 Jun 2007 05:35:00 GMT

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

RE: New Features in Reporting Services 2005

mitul surti — Wed, 13 Jun 2007 22:30:00 GMT

Thats an interesting Piece of information

New Features in Reporting Services 2005

VincentRainardi — Tue, 22 May 2007 11:29:00 GMT

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