Click View - > "Page Break Preview" in Excel and make it to one page

CREATE FUNCTION fnReturnTotalHoursFromTime(

@p varchar(14)

)

RETURNS decimal(20,6)

AS

BEGIN

DECLARE @hoursColon tinyint, @hours decimal(12,6), @minsColon tinyint, @mins decimal(6,4), @seconds decimal (8,6)

SELECT @hoursColon = CHARINDEX(':',@p) --Find 1st colon

SELECT @hours = SUBSTRING(@p,1, @hoursColon -1) --Take all data...

Make sure that you have UNCHECKED "Keep header visible while scrolling" for the tablix. Also make sure that you haven't put FixedData = True for every column, you need to...

This works! http://www.bidn.com/blogs/hardikabhavsar/bidn-blog/1638/keep-column-headers-visible-while-scrolling-in-ssrs-2008

I just posted this here: http://www.sqlservercentral.com/Forums/Topic1324882-1633-1.aspx

That should solve it for you. So to clarify...firstly untick "Keep header visible while scrolling" haha! Then, yeah, follow what it says in...

I posted "put it in the SELECT statement", then reread your question...I don't know how to delete posts sorry!!

...ignore

Hey. All of this, combined, worked to solve the problem.

1) Share the workbook.

2) Ensure that the workbook is in a place for which the security is right to allow access...

Have you tried CTRL-Mouse Wheel scrolling to get right up close? Focus on the table and CTRL-Arrow until they are snug (2005 solution!).

The workbook is shared, yes. Thanks, though, that is in the right area!

I have put it on the local c:\ drive of the BIDS machine I'm developing on, and...

You could be better just copying the chart beneath a page break then filtering each chart to only return a set number of data points.

If you can't do this in...