Wednesday, March 7, 2012

reporting services excel export

Messages to the reporting services group get no attention, and I
haven't been able to find anything on MS support so I am going to try
here. We have a prticular report, that when exported to Excel through
Reporting services exports fine, but has an additional Excel sheet
labeled DocumentMap with bogus code in it and it has the focus by
default. There is another tab called Sheet1 which has the correct
report data. Any idea how to get rid of this DocumentMap tab/sheet?FYI, the problem was that there is a field in the properties dialog for
a textbox called document map label - if you ever put anything in
there, the report will do this and you cannot turn it off, even by
blanking the field out. You have to manually edit the XML file and
remove the <Label></Label> field.

No comments:

Post a Comment