Technical Articles#

Deeper how-tos for specific integrations, and the Reportworq 5 Excel worksheet function reference.

• Configuring Slack - You can create a Slack application and use it for report distribution.
• PowerPoint Integration - Reportworq supports updating PowerPoint Presentations with information from Excel-based Reports that are processed in a Reportworq Job. To enable this functionality to choose PowerPoint from the...
• Deploying the Reportworq Add-in for Office 365 - The Reportworq add-in for Microsoft Office provides additional features to the following applications:
• Sideloading the Reportworq Office Add-in - This article includes the following topics:

Excel Functions#

• Excel Functions - General - Reportworq is designed to support all of Microsoft Excel's standard, built-in functions. Reportworq additionally supports several data provider-specific Excel functions which are documented, per data...
• Excel Functions - Relational Data Sources - Reportworq supports several functions that are used to "writeback" data into configured SQL data sources. These formulas are only available and executed when Reportworq receives a file for processing...
• Excel Functions - IBM Planning Analytics - Reportworq supports several functions that are used to "writeback" data into configured data sources like IBM Planning Analytics via the native DBS, DBSS, DBSW formulas. These formulas are only...
• Excel Functions - Workday Adaptive Planning - Reportworq supports several functions (RW.ADAPTIVE.INPUT and RW.ADAPTIVE.MODELEDINPUT) that are used to "writeback" data into Workday (specifically Standard Sheets, Modeled Sheets, and Adaptive Cube...