SSRS2005: Problem on exporting to excel file

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

SSRS2005: Problem on exporting to excel file

Author

Topic

derisen
Starting Member

4 Posts

Posted - 2009-01-06 : 01:46:29

Hi,

Iam using SSRS2005 for generating reports.
I have a report with a table to display the contents from dataset.
The table is in the following format:

Table Header
--Group Header1
----Group Header2
------Group Header3
--------Group Header4
Table Footer

There is no 'Table Details' as the contents are displayed in the group headers itself. Also, the 'Repeat Header Group' property of the Groups(1,2,3 and 4) is set to true. Iam also toggling the visibility of the groups(using + and -).

The problem is that, when I try to export the report to excel format the groups 1,2 and 3 are not found in the output excel sheet. Its exported in the format, like:
Table Header
--------Group Header4
Table Footer

When reset the 'Repeat Header Group' property of the Groups(1,2,3 and 4) to false, the exporting is working fine. But it will cause trouble in displaying exported PDF file. Because new page will not contain the respective group headers.

Is there any measure to rectify the problem? So that the exporting to excel and pdf will be working fine.

Thanks in advance....

derisen
Starting Member

4 Posts

Posted - 2009-01-07 : 04:22:59

Solution Obtained:
=================

The problem occured when the property 'Repeat group header' of the group header was set and toggling of the group header was done.

This happened in the scenario:
1. Right click the group header and select 'Edit Group'.
2. Under the tab - General, check the property 'Repeat group header'.
3. Under the tab - Visibility, select the report item used to toggle the group header.
On generating the excel sheet from the report, this setting will omit the group header containing the report item used for toggling.

Workaround:
1. Right click the group header and select 'Edit Group'.
2. Under the tab - General, check the property 'Repeat group header'. Save changes.
3. Right click the group header and select 'properties'.
4. Go to 'Visibility -> ToggleItem' and select the report item used for toggling the group.
Now all the records will be included in the excel sheet.

This setting helped me to solve the issue. If anyone has had this problem, can try it out...

Thanks,
Derisen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources