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 Thursday, March 6, 2008 1:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 18, 2014 2:18 PM
Points: 2, Visits: 62
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.
Post #465472
Posted Thursday, March 6, 2008 2:39 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 4:00 PM
Points: 236, Visits: 417
I don't know. I had to tell my customer that the task cannot be accomplished with reporting services and they believed me XD
Post #465503
Posted Thursday, March 6, 2008 8: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
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
Post #465621
Posted Thursday, March 6, 2008 9:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 18, 2014 2:18 PM
Points: 2, Visits: 62
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.
Post #465624
Posted Tuesday, March 11, 2008 1:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 8, 2008 7:54 AM
Points: 1, Visits: 14
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
Post #467725
Posted Wednesday, March 26, 2008 3:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 26, 2008 4:23 AM
Points: 1, Visits: 2

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

Thanks
Post #474580
Posted Wednesday, March 26, 2008 3:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 16, 2008 7:12 AM
Points: 1, Visits: 6
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!
Post #475132
Posted Monday, August 11, 2008 1:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 6, 2012 4:59 AM
Points: 2, Visits: 24
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.

Regards

Shiva.
Post #550071
Posted Thursday, September 4, 2008 1:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 9, 2011 8:58 AM
Points: 1, Visits: 1
How do you get the "non scrolling headers" to work with a matrix?
Post #564120
Posted Sunday, September 14, 2008 6:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 30, 2013 12:31 PM
Points: 6, Visits: 148
solson (3/26/2008)
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.


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
Post #569163
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse