From: jl45 on
I have a report on reporting server that I need to email as excel file weekly.

As default it comes with document map as the first excel tab when exported
which I need to stop from happening.

I have found on the internet that I can use this

<DeviceInfo><OmitDocumentMap>true</OmitDocumentMap></DeviceInfo>

but I dont know where to put it, I tried putting it in different places in
the xml but no good it keeps coming back with errors such as

Deserialization failed: The element 'Report' in namespace
'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition'
has invalid child element 'DeviceInfo'

So please can anyone tell me exactly where does the device info need to go?


From: Reeves Smith on
HTML Viewer Commands (rc:)

You use HTML Viewer commands to tell SSRS 2005 how to render the report. You
can use the commands to control how the viewer appears to the user, as well
as to control certain aspects of how the report appears in the viewer.

-- Shows or hides the report document map.
rc:DocMap=true

Reeves

"jl45" wrote:

> I have a report on reporting server that I need to email as excel file weekly.
>
> As default it comes with document map as the first excel tab when exported
> which I need to stop from happening.
>
> I have found on the internet that I can use this
>
> <DeviceInfo><OmitDocumentMap>true</OmitDocumentMap></DeviceInfo>
>
> but I dont know where to put it, I tried putting it in different places in
> the xml but no good it keeps coming back with errors such as
>
> Deserialization failed: The element 'Report' in namespace
> 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition'
> has invalid child element 'DeviceInfo'
>
> So please can anyone tell me exactly where does the device info need to go?
>
>