Hi, I've a report with column groups Year and Month. Month is toggled in the year. The report when exported to Excel is showing two columns in each of Year Column. How to make the report render as displayed in the Normal view. Thanks, Chandu

Hi, Have You Merged any Columns within this Group for Displaying any heading or Something ?Rakesh M J

Hi Chandu, Could you please provide us sample. It will help us understand the problem better. Regards, Bharath

Hi Chandu, As Bharath posted, could you please post an example for more details about your report and the current result in Excel rendering? Based on your description, I created a matrix report and added 2 levels of column groups to the matrix. In order to toggle the Month group, I select the Month group in the Column Groups pane, and then specify the Hidden property to True and specify the ToggleItem property to the textbox of Year. After exported the report to Excel, it also looks fine. The only difference is the total column for each will still be displayed after month columns when the toggle is expanded. And this behavior is by design due to the limitation of Excel. Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi All, Thanks for the response. Sorry for a late reply. My report format would be like Activity 2011 2012 2013 2014 2015 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec The month column is toggled by Year. When I export to Excel the result would be Activity 2011 2012 2013 2014 2015 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Jan Jan Jan You can notice from the above table The year > 2012 there are two columns for each Year. If I exapand the toggling I get all the Twelve monts and the Total too. But when the Year coulmn is collapsed It has to render only the totals column under 2012 etc. But not Jan and the total column. One more Question related to the above is. If I want to have toggling enabled on the Present year only i.e (2011) and the Rest columns (2012,2013,2014 etc) should display only the year data, with toggling disabled. How do I do it? Thanks, Chandu

Hi All, Sorry for a late reply. My report format would be like Activity 2011 2012 2013 2014 2015 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec The month column is toggled by Year. When I export to Excel the result would be Activity 2011 2012 2013 2014 2015 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Jan Jan Jan You can notice from the above table The year > 2012 there are two columns for each Year. If I exapand the toggling I get all the Twelve monts and the Total too. But when the Year coulmn is collapsed It has to render only the totals column under 2012 etc. But not Jan and the total column. Thanks, Chandu

Hi Chandu, Thanks for the example. It is weird that 2 columns are displayed for each year when the Year column is collapsed in Excel rendering. Do you export the report to Excel in Preview mode or in BI Dev Studio or in the Report Manager? If possible, please try to create another similar report and export it to Excel in both ways to see whether it is the same. In addition, please also post the version of Reporting Services you are using. Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Tony, Thanks for the reply. I'm using SSRS 2008 R2. I exported the reported in BIDS/ Report Builder 3.0 and also from the Deployed Url from the report server. The result is the same. I've three more reports of the same format. All of them have the same problem. But what I've observed is when I reduce the size of the Columns. I get only the Jan column. But what I need is the Totals to be displayed as in the normal view. Regards, Chandu

Hi Chandu, Could you please send the report file and dataset with sample data to the following E-mail address with the beginning “Hi Tony”, also send an exported Excel of the report. Then I will reproduce the scenario in my environment and try to resolve the issue. E-mail: sqltnsp AT Microsoft.com (Please replace AT with @) Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.