Customizing Rendering Extension Parameters in RSReportServer.Config - DAT/CSV(|)

• hunny_capri

  SSC Veteran

  Points: 272

  More actions

  February 13, 2014 at 4:23 am

  #304142

  Hi,

  I am trying to add an two additional extension

  1. based on word but to have a file extension txt

  1. based on word but to have a file extension csv with '|' delimited

  I have tried amending reportserver.config according to the article:

  http://technet.microsoft.com/en-us/library/ms156281(v=sql.105).aspx

  but it doesn't seem to work. Can anyone check my config please and see what I'm doing wrong?

  config

  <Render>

  <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,Microsoft.ReportingServices.DataRendering"/>

  <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>

  <Extension Name="txt" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordDocumentRenderer,Microsoft.ReportingServices.WordRendering">

  <OverrideNames>

  <Name Language="en-US">TXT</Name>

  </OverrideNames>

  <Configuration>

  <DeviceInfo>

  <OutputFormat>TXT</OutputFormat>

  </DeviceInfo>

  </Configuration>

  </Extension>

  <Extension Name="CSV PIPE Delimited" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">

  <OverrideNames>

  <Name Language="en-US">CSV(Delimited)</Name>

  </OverrideNames>

  <Configuration>

  <DeviceInfo>

  <OutputFormat>CSV</OutputFormat>

  </DeviceInfo>

  </Configuration>

  </Extension>

  <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering"/>

  <Extension Name="ATOM" Type="Microsoft.ReportingServices.Rendering.DataRenderer.AtomDataReport,Microsoft.ReportingServices.DataRendering" Visible="false"/>

  <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering"/>

  <Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RGDIRenderer,Microsoft.ReportingServices.ImageRendering" Visible="false"/>

  <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>

  <Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/>

  <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>

  <Extension Name="RPL" Type="Microsoft.ReportingServices.Rendering.RPLRendering.RPLRenderer,Microsoft.ReportingServices.RPLRendering" Visible="false" LogAllExecutionRequests="false"/>

  <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering"/>

  <Extension Name="WORD" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordDocumentRenderer,Microsoft.ReportingServices.WordRendering"/>

  </Render>

  Thanks in advance

• MyDoggieJessie

  SSC-Forever

  Points: 44519

  More actions

  February 13, 2014 at 7:50 am

  #1688746

  Two questions: 1) Are you getting an error? 2) Did you restart the Reporting Service after making the change?

  ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

• hunny_capri

  SSC Veteran

  Points: 272

  More actions

  February 13, 2014 at 11:00 pm

  #1688978

  i had restarted the service,but my custom extensions are not visible when i subscribe my job and choose to export in certain format.

  I ahd made my changes in RSReportServer.config file,do i need to change any other file?

• MyDoggieJessie

  SSC-Forever

  Points: 44519

  More actions

  February 15, 2014 at 10:25 am

  #1689304

  I believe the issue is with the "WordRendering" - can you try this?

  <Extension Name="TXT" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">

  <Configuration>

  <DeviceInfo>

  <NoHeader>True</NoHeader>

  <FileExtension>txt</FileExtension>

  <ExcelMode>true</ExcelMode>

  <SuppressLineBreaks>false</SuppressLineBreaks>

  <Qualifier></Qualifier>

  </DeviceInfo>

  </Configuration>

  <OverrideNames>

  <Name Language="en-US">TXT</Name>

  </OverrideNames>

  </Extension>

  ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience