Scheduling to a Specific Format

The location of the output format setting is slightly strange in that it really is only relevant in the context of scheduling, so it might make more sense in the ISchedulingInfo interface, but instead its found in the IReport interface. The IReport interface is obtained by casting from an IInfoObject interface. The following code obtains the IReport interface for an InfoObject:

IInfoObjects results = iStore.query("SELECT SI_ID FROM CI_INFOOBJECTS WHERE" + " SI_NAME=World Sales Report AND SI_INSTANCE=0"); IInfoObject infoObject = (IInfoObject) results.get(0); IReport report = (IReport) infoObject;

After this interface is obtained, there are many methods available. The following sections focus on the relevant settings for scheduling.

To set the output format, call the getReportFormatOptions method, which returns an IReportFormatOptions interface. With this interface, the setFormat method can be called that accepts a member of the CeReportFormat enumeration. The following values are allowed:

• CeReportFormat.CRYSTAL_REPORT: The default value, keeping the report in its native format
• CeReportFormat.EXCEL: Microsoft Excel format
• CeReportFormat.EXCEL_DATA_ONLY: A variation of the Microsoft Excel format, which exports the data from the report without the formatting
• CeReportFormat.PDF: Adobe PDF format
• CeReportFormat.RTF: Microsoft Rich Text Format (RTF)
• CeReportFormat.TEXT_CHARACTER_SEPARATED: Character separated value (CSV) format
• CeReportFormat.TEXT_PLAIN: Plain text format
• CeReportFormat.TEXT_PAGINATED: A variation of the plain text format that adds pagination
• CeReportFormat.TEXT_TAB_SEPARATED_TEXT: Tab-separated text format
• CeReportFormat.WORD: Microsoft Word format

The following code snippet schedules a report to Word format:

IReport report = (IReport) infoObject; IReportFormatOptions format = report.getReportFormatOptions(); format.setFormat(IReportFormatOptions.CeReportFormat.WORD); iStore.schedule(results) ;