Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

New Features in Reporting Services 2005 Expand / Collapse
Author
Message
Posted Tuesday, May 22, 2007 11:29 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, January 14, 2013 4:24 AM
Points: 81, Visits: 188
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/vRainardi/3024.asp
Post #368026
Posted Wednesday, June 13, 2007 10:30 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 3, 2008 6:08 AM
Points: 11, Visits: 2
Thats an interesting Piece of information
Post #373749
Posted Thursday, June 14, 2007 5:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 26, 2013 7:27 PM
Points: 2, Visits: 32

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

Post #373817
Posted Thursday, June 14, 2007 10:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 26, 2014 1:50 AM
Points: 2, Visits: 25
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
Post #373986
Posted Thursday, June 14, 2007 11:53 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 12:10 PM
Points: 49, Visits: 279
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
Post #373994
Posted Friday, June 15, 2007 5:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 18, 2014 6:44 AM
Points: 6, Visits: 220
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.
Post #374200
Posted Thursday, June 21, 2007 7:39 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 9:48 AM
Points: 202, Visits: 3,531
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. 
Post #375585
Posted Tuesday, December 4, 2007 10:23 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, May 23, 2014 1:26 PM
Points: 236, Visits: 410
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!
Post #429433
Posted Monday, December 24, 2007 2:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 17, 2009 11:00 PM
Points: 5, Visits: 64
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.
Post #436123
Posted Thursday, February 28, 2008 3:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 15, 2013 9:30 AM
Points: 3, Visits: 69
Uncheck the option "Header should remain visible while scrolling" from Table Properties.
That worked for me :)
Post #462053
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse