Floating headers in a matrix

I added floating headers in a RS matrix and it worked great. I developed another RS matrix and decided I would add floating headers. I went back to the first RS matrix looking to find out how I did it. I couldn't find the location of the Header/ footer section that I checked that said " Header should remain visable when scrolling" Can someone help?Well I found it under the column and row heading. It wouldn't let me render a report with a floating header as the matrix is contained in a list. Any Ideas?|||

Please try the following approach:

1. Put the list into a main report.
2. Add a subreport inside the list.
3. Point the subreport to a report that has the matrix as a top-level data region.

-- Robert

|||ty

Floating headers

Hi ,
Is there any way to keep the first set of N columns along with the data as
frozen and the other columns move behind it as in excel horizontally.
I tried to check the option in layout --> fixed header = true but the header
along remains frozen but the data is getting overlapped.
please do help at the earliest.
thanks,
VidulaYup. You can apply a custom XSLT to the report XML, so you can create SSML
(Excel 2003's XML format) with any desired Excel elements you want.
Start like this:
* -- run your report and export to Excel. This will give you a base Excel
layout.
* -- tell your users to make whatever changes they want and give you back
the document.
* -- Save the result As an Xml Spreadsheet (SSML).
* -- write the XSLT you will apply to subsequent report runs to get this
result.
Note: it is probably possible to do the same thing to get XSLX (Excel 2007
base format). However you won't be able to do it by directly applying the
XSLT file using Report Properties, I don't think -- you'd have to specify
XML output and then do the work after receiving the raw XML data.
Either way, you may want to look into the DeviceInfo setting
UseFormattedValues -- you might prefer to receive the values in the columns
raw rather than formatted so that you can format them exactly the way Excel
prefers for various data types. This part really depends on the individual
report.
>L<
"Vidu" <Vidu@.discussions.microsoft.com> wrote in message
news:1D50F22D-EE6B-411D-80B5-27F34040E238@.microsoft.com...
> Hi ,
> Is there any way to keep the first set of N columns along with the data as
> frozen and the other columns move behind it as in excel horizontally.
> I tried to check the option in layout --> fixed header = true but the
> header
> along remains frozen but the data is getting overlapped.
> please do help at the earliest.
> thanks,
> Vidula
>

Fixing Table Headers

Hi,
the problem in one of our reports is, that there are a lot of detail lines
for each group, so if you scroll down to see them, the table header is not
visible. Our customers are complaining about that, because they have to
scroll up and down to see to which field the detail belongs.
Moreover it is not possible to split the table, because all details are a
logical group.
My question: Is it possible to fix a table header like the fixing function
in excel, so it can always be seen when you scroll down the details?
Thanks,
BjörnTable headers can be repeated on each page, but you can not do the excel
like thing... You can make your page smaller, but that's about it I think.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Björn Grünberg" <BjrnGrnberg@.discussions.microsoft.com> wrote in message
news:DE7380C6-C5A0-47C0-9C0E-F267976BCC4A@.microsoft.com...
> Hi,
> the problem in one of our reports is, that there are a lot of detail lines
> for each group, so if you scroll down to see them, the table header is not
> visible. Our customers are complaining about that, because they have to
> scroll up and down to see to which field the detail belongs.
> Moreover it is not possible to split the table, because all details are a
> logical group.
> My question: Is it possible to fix a table header like the fixing function
> in excel, so it can always be seen when you scroll down the details?
> Thanks,
> Björn|||Wayne is right, Reporting Services 2000 does not this particular feature.
Look for this in Reporting Services 2005 (shipping as part of Yukon),
though.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uhCnpeBRFHA.3020@.TK2MSFTNGP12.phx.gbl...
> Table headers can be repeated on each page, but you can not do the excel
> like thing... You can make your page smaller, but that's about it I think.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Björn Grünberg" <BjrnGrnberg@.discussions.microsoft.com> wrote in message
> news:DE7380C6-C5A0-47C0-9C0E-F267976BCC4A@.microsoft.com...
>> Hi,
>> the problem in one of our reports is, that there are a lot of detail
>> lines
>> for each group, so if you scroll down to see them, the table header is
>> not
>> visible. Our customers are complaining about that, because they have to
>> scroll up and down to see to which field the detail belongs.
>> Moreover it is not possible to split the table, because all details are a
>> logical group.
>> My question: Is it possible to fix a table header like the fixing
>> function
>> in excel, so it can always be seen when you scroll down the details?
>> Thanks,
>> Björn
>|||On Mon, 18 Apr 2005 03:57:19 -0700, "Björn Grünberg"
<BjrnGrnberg@.discussions.microsoft.com> wrote:
>Hi,
>the problem in one of our reports is, that there are a lot of detail lines
>for each group, so if you scroll down to see them, the table header is not
>visible. Our customers are complaining about that, because they have to
>scroll up and down to see to which field the detail belongs.
>Moreover it is not possible to split the table, because all details are a
>logical group.
>My question: Is it possible to fix a table header like the fixing function
>in excel, so it can always be seen when you scroll down the details?
>Thanks,
>Björn
Bjorn,
It's a little bit of a kludge but why not add a table footer and
simply repeat the information that is in the table header? That should
make the relevant information visible in a larger part of the page.
Andrew Watt
MVP - InfoPath

Fixed Headers in RS 2005

I've been playing around with RS 2005 for a few days trying to validate
the new features/enhancements with it vs. RS 2000. I'm looking at the
Fixed Headers enhancement and wondering if I'm doing something wrong.
I set the table property of 'Header should remain visible while
scrolling' and the header does this, but it is constantly being
overlayed with the detail rows so it is not easy at all to read.
Is there something else I should be doing to avoid this?
Thanks,
KelOne work around I did figure out was to fill in the header row with a
solid color therefor stopping the details lines from showing through.
Let me know if anyone has any other solutions.
Thanks,
Kel|||I have encountered a diffrent problem. If my data source returns 45 rows or less, the table fits on one page and the header is locked for scrolling,
If the data source returns 46 rows or more, it ignores the "header should remain visible while scrolling" and "fit table on one page if possible" options.
Has anybody found a solution to the "should" and "if possible" problems?
It seems like rs has commitment issues, so any help would be GREAT!
Elina.
From http://www.developmentnow.com/g/115_2006_5_0_0_753604/Fixed-Headers-in-RS-2005.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||Which version of SQL Server 2005 do you have? I had the same issue and found out that this bug doesn't occur on the RTM version Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86). However it does occur on the SP2 version.
There is a SP2 cumulative update that is supposed to fix this issue, but it didn't work for me, you can try to apply the hotfix, check the following link: http://support.microsoft.com/kb/943656
Let me know if that solves the issue for yo
From http://www.developmentnow.com/g/115_2006_5_0_0_753604/Fixed-Headers-in-RS-2005.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Fixed Header issue in SSRS 2005

I am tryign to keep the headers fixed, on a 2005 report.

Hence In the Layout section for table settings properties,I Set the FixedHeader setting to True to keep the headers visible as you scroll down .

However, when I scroll down the report, the headers stay fixed, BUT IT OVERLAPS With the rows of data.

Any idea why this would happen?

To keep it from looking like it is overlapping you can change the background color from transparent to white (or whatever color you choose).

Simone

|||Yes, thats what I did and then it does not appear like it overlaps. However, is there any reason why this happens. AND how can we prevent this from happening, besides changing the Background color?|||I believe it is by design. The background color defaults to transparent. When the header is set to fixed, it doesn't move but the rest of the page does. The transparency results in the "overlap".

Fixed Column Headers

I have a report in Reporting Services that I want the users to be able to
scroll up and down with the column headers fixed, just like freezing a window
in Excel. I'd like to have the far left remain fixed as well, but that's not
as important as the headers. Does anyone know how to do that?This feature is not in RS 2000, but will be supported in the next release.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:E161DB2B-5739-4816-B1BF-0222C3E51C79@.microsoft.com...
>I have a report in Reporting Services that I want the users to be able to
> scroll up and down with the column headers fixed, just like freezing a
> window
> in Excel. I'd like to have the far left remain fixed as well, but that's
> not
> as important as the headers. Does anyone know how to do that?