Freeze Panes?

Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report? Similay to the freeze panes functionality in Excel.

Thanks

Yes, RS 2005 provides this functionality. E.g. in the table properties dialog on the general tab, select "Header should remain visible while scrolling".

-- Robert

|||Sorry.. i may be missing something obvious within the properties, but where is this functionality with a Matrix for row and column headings?|||

In the matrix case, the setting is on the row / column groupings. For instance, you can
1. open the matrix properties dialog
2. go to the Groups tab
3. edit a column or row group
4. and on the general tab of the grouping and sorting dialog, select "Group header should remain visible while scrolling"

-- Robert

|||

I noticed that facility in RS 2005, but could not found it in RS 2000.
I'd appreciate if anybody could give a work around.
Vincent

|||

As I mentioned in my initial response, only RS 2005 provides this feature. It is not available in RS 2000.

-- Robert

|||Thank you Robert.
Vincent|||

I am unable to get this to work on my matrix. When I select 'group header should remain visible while scrolling' (for either row or column), I then get the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

Can anyone provide any help?

|||It seems that your matrix is nested inside another data control which as the error message suggests does not allow fixed headers.|||

Hi ,

Is ther 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.

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

|||

Hi,

I got the same problem when I select 'group header should remain visible while scrolling' (for either row or column), I got the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

I have matrix inside a table which I set FixedHeader to False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!

Thanks in advance!

Freeze Panes?

Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report? Similay to the freeze panes functionality in Excel.

Thanks

Yes, RS 2005 provides this functionality. E.g. in the table properties dialog on the general tab, select "Header should remain visible while scrolling".

-- Robert

|||Sorry.. i may be missing something obvious within the properties, but where is this functionality with a Matrix for row and column headings?|||

In the matrix case, the setting is on the row / column groupings. For instance, you can
1. open the matrix properties dialog
2. go to the Groups tab
3. edit a column or row group
4. and on the general tab of the grouping and sorting dialog, select "Group header should remain visible while scrolling"

-- Robert

|||

I noticed that facility in RS 2005, but could not found it in RS 2000.
I'd appreciate if anybody could give a work around.
Vincent

|||

As I mentioned in my initial response, only RS 2005 provides this feature. It is not available in RS 2000.

-- Robert

|||Thank you Robert.
Vincent|||

I am unable to get this to work on my matrix. When I select 'group header should remain visible while scrolling' (for either row or column), I then get the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

Can anyone provide any help?

|||It seems that your matrix is nested inside another data control which as the error message suggests does not allow fixed headers.|||

Hi ,

Is ther 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.

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

|||

Hi,

I got the same problem when I select 'group header should remain visible while scrolling' (for either row or column), I got the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

I have matrix inside a table which I set FixedHeader to False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!

Thanks in advance!

Freeze Panes?

Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report? Similay to the freeze panes functionality in Excel.

Thanks

Yes, RS 2005 provides this functionality. E.g. in the table properties dialog on the general tab, select "Header should remain visible while scrolling".

-- Robert

|||Sorry.. i may be missing something obvious within the properties, but where is this functionality with a Matrix for row and column headings?|||

In the matrix case, the setting is on the row / column groupings. For instance, you can
1. open the matrix properties dialog
2. go to the Groups tab
3. edit a column or row group
4. and on the general tab of the grouping and sorting dialog, select "Group header should remain visible while scrolling"

-- Robert

|||

I noticed that facility in RS 2005, but could not found it in RS 2000.
I'd appreciate if anybody could give a work around.
Vincent

|||

As I mentioned in my initial response, only RS 2005 provides this feature. It is not available in RS 2000.

-- Robert

|||Thank you Robert.
Vincent|||

I am unable to get this to work on my matrix. When I select 'group header should remain visible while scrolling' (for either row or column), I then get the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

Can anyone provide any help?

|||It seems that your matrix is nested inside another data control which as the error message suggests does not allow fixed headers.|||

Hi ,

Is ther 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.

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

|||

Hi,

I got the same problem when I select 'group header should remain visible while scrolling' (for either row or column), I got the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

I have matrix inside a table which I set FixedHeader to False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!

Thanks in advance!

Freeze Panes?

Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report? Similay to the freeze panes functionality in Excel.

Thanks

Yes, RS 2005 provides this functionality. E.g. in the table properties dialog on the general tab, select "Header should remain visible while scrolling".

-- Robert

|||Sorry.. i may be missing something obvious within the properties, but where is this functionality with a Matrix for row and column headings?|||

In the matrix case, the setting is on the row / column groupings. For instance, you can
1. open the matrix properties dialog
2. go to the Groups tab
3. edit a column or row group
4. and on the general tab of the grouping and sorting dialog, select "Group header should remain visible while scrolling"

-- Robert

|||

I noticed that facility in RS 2005, but could not found it in RS 2000.
I'd appreciate if anybody could give a work around.
Vincent

|||

As I mentioned in my initial response, only RS 2005 provides this feature. It is not available in RS 2000.

-- Robert

|||Thank you Robert.
Vincent|||

I am unable to get this to work on my matrix. When I select 'group header should remain visible while scrolling' (for either row or column), I then get the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

Can anyone provide any help?

|||It seems that your matrix is nested inside another data control which as the error message suggests does not allow fixed headers.|||

Hi ,

Is ther 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.

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

|||

Hi,

I got the same problem when I select 'group header should remain visible while scrolling' (for either row or column), I got the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

I have matrix inside a table which I set FixedHeader to False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!

Thanks in advance!

Freeze Panes?

Is there functionality within the Table or Matrix objects to freeze columns or row headers when you scroll thru a wide or long report? Similay to the freeze panes functionality in Excel.

Thanks

Yes, RS 2005 provides this functionality. E.g. in the table properties dialog on the general tab, select "Header should remain visible while scrolling".

-- Robert

|||Sorry.. i may be missing something obvious within the properties, but where is this functionality with a Matrix for row and column headings?|||

In the matrix case, the setting is on the row / column groupings. For instance, you can
1. open the matrix properties dialog
2. go to the Groups tab
3. edit a column or row group
4. and on the general tab of the grouping and sorting dialog, select "Group header should remain visible while scrolling"

-- Robert

|||

I noticed that facility in RS 2005, but could not found it in RS 2000.
I'd appreciate if anybody could give a work around.
Vincent

|||

As I mentioned in my initial response, only RS 2005 provides this feature. It is not available in RS 2000.

-- Robert

|||Thank you Robert.
Vincent|||

I am unable to get this to work on my matrix. When I select 'group header should remain visible while scrolling' (for either row or column), I then get the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

Can anyone provide any help?

|||It seems that your matrix is nested inside another data control which as the error message suggests does not allow fixed headers.|||

Hi ,

Is ther 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.

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

|||

Hi,

I got the same problem when I select 'group header should remain visible while scrolling' (for either row or column), I got the error

[rsFixedHeadersInInnerDataRegion] The matrix ‘matrix1’ includes a table header or column with FixedHeader set to true. This is not allowed on data regions inside other data regions.

I have matrix inside a table which I set FixedHeader to False but still got the same error. I can't find other places who set fixedheader properties. Any suggestion would be very appraciate!

Thanks in advance!

Freeze Pane functionality during Export to Excel

Hi All,

I have created a Report using Sql Server 2005 Reporting Services.

When I export the report to excel, I want to freeze the pane of the headers in the exported excel.

Any pointers on how to achieve this will greatly help me.

Thanks,

S Suresh

There is no way to tell the Excel renderer to freeze an arbitrary pane. However, the renderer does set a freeze pane for the page headers (not the table headers), so that might be a possibility for you.|||Will you please tell me how to set a freeze pane fo rthe page headers? We do not want to export the page headers to the excel because it merges servera columns for one actual data column. That makes it impossible to change the sorting columns. Thanks,|||I'm not sure I understand what you mean, but the only thing exported to a freeze pane is the page headers. There is no way to put any other part of the report into a freeze pane.

If you are trying to have the headers not show up in Excel, you can have them export as "simple" headers. This would put them into Excel as actual Excel headers, and not as part of the worksheet. To do this, you need to set the SimplePageHeaders device info setting:
http://msdn2.microsoft.com/en-us/library/ms155069.aspx

Hope that helps...|||

Thanks a lot for your reply.

What I want to do is exactly what you said not to put page headers into the excel. My page header has two textboxes, so I do not know if that working. I will try your suggestion tomorrow. Thanks again!

|||

Geoff,

Thank you so much for your link. Looks like it is for sql sever reporting service 2005. We are using 2003 but I tried anyway.

I used the way change the setting through adding render section in xml code but got error. The question I have is where should I put the render section in the xml code? Below is the code, please help me out. Thank you very much for your help!

<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

<Render>

<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ImageReport,Microsoft.ReportingServices.ExcelRendering">

<Configuration> <DeviceInfo>

<SimplePageHeaders>True</SimplePageHeaders>

</DeviceInfo> </Configuration> </Extension>

</Render>

<PageHeader>

<ReportItems>

<Textbox Name="textbox7">

Error message:

c:\catsreports\catsreports\Contractor.rdl(4): Deserialization failed: The element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Report' has invalid child element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Render'. An error occurred at , (4, 4).

Freeze Pane functionality during Export to Excel

Hi All,

I have created a Report using Sql Server 2005 Reporting Services.

When I export the report to excel, I want to freeze the pane of the headers in the exported excel.

Any pointers on how to achieve this will greatly help me.

Thanks,

S Suresh

There is no way to tell the Excel renderer to freeze an arbitrary pane. However, the renderer does set a freeze pane for the page headers (not the table headers), so that might be a possibility for you.|||Will you please tell me how to set a freeze pane fo rthe page headers? We do not want to export the page headers to the excel because it merges servera columns for one actual data column. That makes it impossible to change the sorting columns. Thanks,|||I'm not sure I understand what you mean, but the only thing exported to a freeze pane is the page headers. There is no way to put any other part of the report into a freeze pane.

If you are trying to have the headers not show up in Excel, you can have them export as "simple" headers. This would put them into Excel as actual Excel headers, and not as part of the worksheet. To do this, you need to set the SimplePageHeaders device info setting:
http://msdn2.microsoft.com/en-us/library/ms155069.aspx

Hope that helps...|||

Thanks a lot for your reply.

What I want to do is exactly what you said not to put page headers into the excel. My page header has two textboxes, so I do not know if that working. I will try your suggestion tomorrow. Thanks again!

|||

Geoff,

Thank you so much for your link. Looks like it is for sql sever reporting service 2005. We are using 2003 but I tried anyway.

I used the way change the setting through adding render section in xml code but got error. The question I have is where should I put the render section in the xml code? Below is the code, please help me out. Thank you very much for your help!

<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

<Render>

<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ImageReport,Microsoft.ReportingServices.ExcelRendering">

<Configuration> <DeviceInfo>

<SimplePageHeaders>True</SimplePageHeaders>

</DeviceInfo> </Configuration> </Extension>

</Render>

<PageHeader>

<ReportItems>

<Textbox Name="textbox7">

Error message:

c:\catsreports\catsreports\Contractor.rdl(4): Deserialization failed: The element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Report' has invalid child element 'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Render'. An error occurred at , (4, 4).