New Features in Reporting Services 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Vincent Rainardi » New Features in Reporting Services 2005

21 posts, Page 1 of 3

1 2 3 »»»

New Features in Reporting Services 2005

Rate Topic

Display Mode

Topic Options

Author

Message

VincentRainardi

Posted Tuesday, May 22, 2007 11:29 AM

SSC 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

mitul surti

Posted Wednesday, June 13, 2007 10:30 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, April 03, 2008 6:08 AM
Points: 11, Visits: 2

Thats an interesting Piece of information

Post #373749

Mary Eckmeier

Posted Thursday, June 14, 2007 5:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, March 17, 2013 2:48 PM
Points: 2, Visits: 31

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

vidya sagar reddy

Posted Thursday, June 14, 2007 10:57 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, December 13, 2010 7:38 PM
Points: 2, Visits: 20

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

Philippe Cand

Posted Thursday, June 14, 2007 11:53 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 29, 2013 10:28 AM
Points: 46, Visits: 262

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

Ian Dell

Posted Friday, June 15, 2007 5:06 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:56 AM
Points: 6, Visits: 172

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

Ben Holcombe-270296

Posted Thursday, June 21, 2007 7:39 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:10 AM
Points: 202, Visits: 3,519

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

F. Dwarf

Posted Tuesday, December 04, 2007 10:23 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 2:45 PM
Points: 236, Visits: 377

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

vishrutirdesai

Posted Monday, December 24, 2007 2:50 AM

Forum 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

opdaniel

Posted Thursday, February 28, 2008 3:57 PM

Forum 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 »

21 posts, Page 1 of 3

1 2 3 »»»

Permissions