<DeviceInfo>

Hello,
Is it possible to set a default for an export <DeviceInfo> setting. I'd
like to set some defaults for Excel, but haven't seen any documentation on
how to do this in RSReportServer.config (I would presume?).
Here's what I have so far, but to no avail:
<Extension Name="EXCEL"
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Micr
osoft.ReportingServices.ExcelRendering">
<DeviceInfo>
<SimplePageHeaders>True</SimplePageHeaders>
</DeviceInfo>
</Extension>
Any ideas would be greatly appreciated.
Best Regards,
Benjamin PierceThis is on the wish-list for a future release. Currently, the only way is to
construct the URL or use SOAP API.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Benjamin Pierce" <bpierce@.opentext.com> wrote in message
news:OCtCh4bbEHA.2572@.tk2msftngp13.phx.gbl...
> Hello,
> Is it possible to set a default for an export <DeviceInfo> setting. I'd
> like to set some defaults for Excel, but haven't seen any documentation on
> how to do this in RSReportServer.config (I would presume?).
> Here's what I have so far, but to no avail:
> <Extension Name="EXCEL"
>
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Micr
> osoft.ReportingServices.ExcelRendering">
> <DeviceInfo>
> <SimplePageHeaders>True</SimplePageHeaders>
> </DeviceInfo>
> </Extension>
> Any ideas would be greatly appreciated.
>
> Best Regards,
> Benjamin Pierce
>|||To eliminate the merged cells I built an extract utilizing a
webreference to the reporting websevice and then passing the
deviceinfo as such in the Render call.
If format.Extension = ".xls" Then deviceInfo ="<DeviceInfo><SimplePageHeaders>True</SimplePageHeaders></DeviceInfo>"
Dim data() As Byte
data = _rs.Render(reportItem.Path, format.Name, Nothing,
deviceInfo, parameters, Nothing, Nothing, _
encoding, mimeType, parametersUsed, warnings, streamIDs)
It does return the excel report with no headers and no merged cells.
All of this is in the Wrox book - Professional SQL Server Reporting
Services.
Chapter 9 on programmatic rendering.
--John
"Benjamin Pierce" <bpierce@.opentext.com> wrote in message news:<OCtCh4bbEHA.2572@.tk2msftngp13.phx.gbl>...
> Hello,
> Is it possible to set a default for an export <DeviceInfo> setting. I'd
> like to set some defaults for Excel, but haven't seen any documentation on
> how to do this in RSReportServer.config (I would presume?).
> Here's what I have so far, but to no avail:
> <Extension Name="EXCEL"
> Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Micr
> osoft.ReportingServices.ExcelRendering">
> <DeviceInfo>
> <SimplePageHeaders>True</SimplePageHeaders>
> </DeviceInfo>
> </Extension>
> Any ideas would be greatly appreciated.
>
> Best Regards,
> Benjamin Pierce|||John:
According to the WroxBook, I need to buid an Application Interface to do this.
Is there a way that I can programatically do this inside of Reporting
Services.
My problem is with the csv export, I need to eliminate the hearders in the
output file.
Ravi Mumulla at Microsoft suggested the append method in the URL -- my users
are not computer friendly and therefore this task is not going to be easy for
them.
PLEASE HELP!
Thanks,
john jr.
"John" wrote:
> To eliminate the merged cells I built an extract utilizing a
> webreference to the reporting websevice and then passing the
> deviceinfo as such in the Render call.
> If format.Extension = ".xls" Then deviceInfo => "<DeviceInfo><SimplePageHeaders>True</SimplePageHeaders></DeviceInfo>"
> Dim data() As Byte
> data = _rs.Render(reportItem.Path, format.Name, Nothing,
> deviceInfo, parameters, Nothing, Nothing, _
> encoding, mimeType, parametersUsed, warnings, streamIDs)
> It does return the excel report with no headers and no merged cells.
> All of this is in the Wrox book - Professional SQL Server Reporting
> Services.
> Chapter 9 on programmatic rendering.
> --John
>
> "Benjamin Pierce" <bpierce@.opentext.com> wrote in message news:<OCtCh4bbEHA.2572@.tk2msftngp13.phx.gbl>...
> > Hello,
> >
> > Is it possible to set a default for an export <DeviceInfo> setting. I'd
> > like to set some defaults for Excel, but haven't seen any documentation on
> > how to do this in RSReportServer.config (I would presume?).
> >
> > Here's what I have so far, but to no avail:
> >
> > <Extension Name="EXCEL"
> > Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Micr
> > osoft.ReportingServices.ExcelRendering">
> > <DeviceInfo>
> > <SimplePageHeaders>True</SimplePageHeaders>
> > </DeviceInfo>
> > </Extension>
> >
> > Any ideas would be greatly appreciated.
> >
> >
> > Best Regards,
> >
> > Benjamin Pierce
>|||URL Access is one option. You can also use the SOAP API Render() method as
suggested eariler on this thread. Check
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_6x0z.asp
for sample code. Use appropriate device info setting,
<NoHeader>true</NoHeader> in your case.
Check the sample code in the following links on how to create simple
winforms/web applications for your end users:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_intro_35pi.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_intro_6f6q.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_intro_7vqa.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_intro_0bs6.asp
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"John" <John@.discussions.microsoft.com> wrote in message
news:7F394F59-D1E7-4759-A6A3-E6DAC5E0CD25@.microsoft.com...
> John:
> According to the WroxBook, I need to buid an Application Interface to do
this.
> Is there a way that I can programatically do this inside of Reporting
> Services.
> My problem is with the csv export, I need to eliminate the hearders in the
> output file.
> Ravi Mumulla at Microsoft suggested the append method in the URL -- my
users
> are not computer friendly and therefore this task is not going to be easy
for
> them.
> PLEASE HELP!
> Thanks,
> john jr.
>
> "John" wrote:
> > To eliminate the merged cells I built an extract utilizing a
> > webreference to the reporting websevice and then passing the
> > deviceinfo as such in the Render call.
> >
> > If format.Extension = ".xls" Then deviceInfo => > "<DeviceInfo><SimplePageHeaders>True</SimplePageHeaders></DeviceInfo>"
> >
> > Dim data() As Byte
> > data = _rs.Render(reportItem.Path, format.Name, Nothing,
> > deviceInfo, parameters, Nothing, Nothing, _
> > encoding, mimeType, parametersUsed, warnings, streamIDs)
> >
> > It does return the excel report with no headers and no merged cells.
> > All of this is in the Wrox book - Professional SQL Server Reporting
> > Services.
> > Chapter 9 on programmatic rendering.
> >
> > --John
> >
> >
> > "Benjamin Pierce" <bpierce@.opentext.com> wrote in message
news:<OCtCh4bbEHA.2572@.tk2msftngp13.phx.gbl>...
> > > Hello,
> > >
> > > Is it possible to set a default for an export <DeviceInfo> setting.
I'd
> > > like to set some defaults for Excel, but haven't seen any
documentation on
> > > how to do this in RSReportServer.config (I would presume?).
> > >
> > > Here's what I have so far, but to no avail:
> > >
> > > <Extension Name="EXCEL"
> > >
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Micr
> > > osoft.ReportingServices.ExcelRendering">
> > > <DeviceInfo>
> > > <SimplePageHeaders>True</SimplePageHeaders>
> > > </DeviceInfo>
> > > </Extension>
> > >
> > > Any ideas would be greatly appreciated.
> > >
> > >
> > > Best Regards,
> > >
> > > Benjamin Pierce
> >