Summary


This article describes the various formats available for content publishing. Format options will vary based on source document type.



Format Matrix


Formats vary based on document type or query.



Web Intelligence
Crystal Reports
Tableau Workbook
SSRS
Database Query
Description
PDFXXXX

Excel (.xls)
X
X

BusinessObjects only supports .xls format for Crystal

Excel (.xlsx)X
XXX
Excel Data (.xlsx)XX


Data only. No formatting.
Excel CSVXX
XX

BusinessObjects does not support report-level CSV. InfoBurst extracts Excel and converts to CSV.

CSV

X


HTMLX

XX
PNGXXX

Image file
Plain TextX



Report-level text with formatting
Data Provider CSVX



One CSV file per data provider
Tableau HyperX


X
Tableau TDEX




Tableau Packaged WorkbookX



Requires TWBX to embed
NativeXX


Web Intelligence: .wid
Crystal Reports: .rpt



PDF


  • Content Password (optional): Supply a password to protect the file. This option provides password protect and not encryption.
  • Select Use Macro to supply customized password(s) using the Extra Column macro.
  • Split Report Tab(s)/Split View(s): Select and publish individual report tabs or views
  • Recombine: Select this option to combine the selected report tabs into a single PDF
  • View Selection (Tableau Workbook only): Select view or views to be published as PDF


Print Options


Available when Destination is Network Printer.

  • XOffset: Select an XOffset value
  • YOffset: Select a YOffset value
  • First Page: Select first page to print
  • Last Page: Select last page to print
  • Options: Enter one or more print options



Excel (.xls) / Excel (.xlsx) / Excel Data (.xlsx)

  • Content Password (optional): Supply a password to protect the file. This option provides password protect and not encryption.
  • Select Use Macro to supply customized password(s) using the Extra Column macro.
  • Split Report Tab(s): Select and publish individual report tabs or views
  • Recombine: Select this option to combine the selected report tabs into a single document 


Extensions


Select the + icon to add one or more Excel Extensions.



Excel CSV


Publish report-level CSV.
  • Delimiter: Select delimiter
  • File Extension: Specify file extension
  • Suppress Headers: Check this option to omit column headers from resulting file
  • Quote Character: Specify a string quote character
  • Remove byte order mark (BOM): Select this option to omit the BOM from the resulting file
  • Keep data formatting: Select this option to retain report-formatted values (all values returned as STRING). Disable this option to return raw data formats (STRING/DATE/NUMBER).

Requirements


Report-level CSV is not a supported format by BusinessObjects. To produce CSV, InfoBurst extracts Excel and converts to CSV. CSV formatting can be influenced by use of report-level formatting in the BI report. To avoid unused space in the resulting Excel which can influence CSV formatting, we recommend the following:

  • Original report table must contain column headers
  • Original report table must not contain duplicate column headers
  • Margins are minimized (0px)
  • Report HEADER and FOOTER are disabled
  • Report table block is aligned to top and left edge of report (0px)
  • Report table(s) must have a header row



CSV


  • Select View(s): Select view(s) to publish



HTML


  • Split Report Tab(s): Select and publish individual report tabs

Database Query


Formatting of HTML output from a database query can be customized by editing the DBQry_Table.css file located in the InfoBurst application root folder (default = C:\Program Files (x86)\InfoSol\InfoBurstPlatform).



PNG

Recommended for mobile devices.

  • Page Range (optional): Specify range of report pages to render as PNG image. Leave blank if the range of pages is variable.
  • Image Width (optional): Specify image width (pixels)
  • Image Height (optional): Specify image height (pixels)
  • Split Report Tab(s)/Split View(s): Select and publish individual report tabs or views


Plain Text


  • Delimiter: Select a delimiter
  • File Extension: Specify file extension
  • Split Report Tab(s): Select and publish individual report tabs


Data Provider CSV


  • Delimiter: Select delimiter
  • File Extension: Specify file extension
  • Quote Character: Specify a string quote character
  • Suppress Headers: Check this option to omit column headers from resulting file
  • Remove byte order mark (BOM): Select this option to omit the BOM from the resulting file
  • Select Data Provider(s): Select and publish individual data providers



Tableau Hyper


  • First Row Headers: Un-check if first data row is not column headers
  • Select Report Tab(s): Select and publish individual report tabs
  • Select Data Provider(s): Select and publish individual data providers



Tableau TDE


  • First Row Headers: Un-check if first data row is not column headers
  • Select Report Tab: Select report tab to publish



Tableau Packaged Workbook


  • TWBX To Embed: Select a TWBX file
  • First Row Headers: Un-check if first data row is not column headers
  • Select Report Tab: Select report tab data to use