How to implement floating headers and/or columns

Hello,
I have read in a number of Powerpoint presentation from MS folks that we
have the ability to implement floating headers and/or column, similar to
freezing panes in Excel.
Could somebody please point me to the article/link that explains how to
implement this?
Thanks in advance for your help,
Ashok GThis is only available in SQL Reporting Services 2005.
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/5b282ff53c37b672/a5fcf4b22a3766f7?q=fixed+header&rnum=1#a5fcf4b22a3766f7
Andy Potter|||Thanks Andy. Appreciate your response. I was also looking for floating
columns. Please do let me know if youhave further information.
--
Thank you,
Ashok G
"Potter" wrote:
> This is only available in SQL Reporting Services 2005.
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/5b282ff53c37b672/a5fcf4b22a3766f7?q=fixed+header&rnum=1#a5fcf4b22a3766f7
> Andy Potter
>|||Does this work the same when a report renders to Excel?
I am wondering if this freezes the table header in Excel? so that it prints
out the table header row in every page in Excel and the table header stays
when the user scroll down to the bottom of the report.
Thanks!
"Potter" wrote:
> This is only available in SQL Reporting Services 2005.
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/5b282ff53c37b672/a5fcf4b22a3766f7?q=fixed+header&rnum=1#a5fcf4b22a3766f7
> Andy Potter
>

How to hide subtotals if only 1 row in group?

Hello,

I have established a group so that I can provide subtotals following the presentation of the group's detail rows. I'm finding that many of the groups have only one row and my subtotals just echo what was already presented on the detail line. The overall effect is confusing to the user and a real vertical space-waster.

Can someone give me a technique or expression for hiding subtotals when the group size is 1 but showing subtotals when the group size is >= 2? If I hide the group when the group size is 1 row then the one detail row is hidden as well, no?

Thanks!

BCB

You can give your visibility the expression to count rows in that group and then False if more than 1|||

But I just want to hide the subtotal line. Won't your approach hide the one detail line that belongs to the group as well as the group footer that contains the redundant subtotals?

Thanks.

|||

Gotcha, another technique would be to make the font white or transparent by using the sae kind of expression....in this case you can determine exactly which text blocks you want to use

only problem is spacing issues

|||

I'm, essentially, trying to do the same thing.

In my case, my report is a list of employees that can be generated for either full timers, part timers, or both.

I've set up a group on the full/part time field FT_PT. There is no group header, just a group footer.

When I generate the report for both I get:

Department Header
Full-Time Detail
FT_PT Group Footer
Part-Time Detail
FT_PT Group Footer
Department Footer

This is perfect.

When I generate it for, say, just Full-Time, I get:

Department Header
Full-Time Detail
FT_PT Group Footer
Department Footer

I don't want to see the FT_PT group footer. What I want is:

Department Header
Full-Time Detail
Department Footer

Gotta be a way to do this without having a blank line where the Full-Time Group Footer would be, isn't there?

How to hide subtotals if only 1 row in group?

Hello,

I have established a group so that I can provide subtotals following the presentation of the group's detail rows. I'm finding that many of the groups have only one row and my subtotals just echo what was already presented on the detail line. The overall effect is confusing to the user and a real vertical space-waster.

Can someone give me a technique or expression for hiding subtotals when the group size is 1 but showing subtotals when the group size is >= 2? If I hide the group when the group size is 1 row then the one detail row is hidden as well, no?

Thanks!

BCB

You can give your visibility the expression to count rows in that group and then False if more than 1|||

But I just want to hide the subtotal line. Won't your approach hide the one detail line that belongs to the group as well as the group footer that contains the redundant subtotals?

Thanks.

|||

Gotcha, another technique would be to make the font white or transparent by using the sae kind of expression....in this case you can determine exactly which text blocks you want to use

only problem is spacing issues

|||

I'm, essentially, trying to do the same thing.

In my case, my report is a list of employees that can be generated for either full timers, part timers, or both.

I've set up a group on the full/part time field FT_PT. There is no group header, just a group footer.

When I generate the report for both I get:

Department Header
Full-Time Detail
FT_PT Group Footer
Part-Time Detail
FT_PT Group Footer
Department Footer

This is perfect.

When I generate it for, say, just Full-Time, I get:

Department Header
Full-Time Detail
FT_PT Group Footer
Department Footer

I don't want to see the FT_PT group footer. What I want is:

Department Header
Full-Time Detail
Department Footer

Gotta be a way to do this without having a blank line where the Full-Time Group Footer would be, isn't there?