Skip to main content
New Users: Start Here!
Main Website
Windward Documentation
Search term
Total articles found:
1
Reset Search
Windward Documentation
Windward Designer
Designer for Microsoft Office
sumproduct
Articles tagged:
sumproduct
Windward Functions Reference
Updated on: Nov 19, 2021
Windward Designer
Designer for Microsoft Office
Reference
Windward Functions Reference
boolean
char
dataset
date
datetime
datetimespan
null
number
range
string
variable
datedif
datespan
datevalue
day
days
hour
minute
month
now
second
time
timespan
timevalue
timezone
today
tolocaltime
weekday
weeknum
year
yearfrac
offsettotalminutes
abs
base
base64decode
ceiling
decimal
degrees
even
fact
floor
iseven
isodd
odd
power
quotient
rand
randbetween
round
sec
standardize
stdev
stdeva
stdevp
stdevpa
sum
sumproduct
addtotal
avedev
average
frequency
count
gettotal
max
median
min
percentile.exc
percentile.inc
percentilerank.exc
percentilerank.inc
product
data
datedata
concatenate
contains
indexof
lastindexof
left
len
lower
mid
numbervalue
proper
regexextract
regexmatch
regexreplace
replace
right
search
substitute
substring
text
trim
upper
urldecode
urlencode
value
xpath
false
if
iferror
isnumber
true
multiplyall
pi
sqrt
rangearray
distinct
toutctime
utcnow
workd.intl
workday
Topics
Getting Started with Report Designer Office Edition
6
Report Designer Office Edition User Interface (Ribbon) Reference
How Do I Install Report Designer Office Edition?
Report Designer Office Edition Training Guides
The Five Steps of Report Designer Office Edition
What's New in Version 15?
What's New in Version 16.1?
FAQs
110
All About PODs
AutoTagShim Load Error When Installing the Designer
Best practice for using the Designer with a host machine and VPN
Date Input Format: 29-Rule
Designer Requirements/Compatibility
How can I use my GUID as an Input Parameter?
How Do I Add a Comment to My Template?
How Do I Add and Delete Tags in an Excel Template?
How Do I Add Tags with the Data Bin
How Do I Conditionally Format an Out Tag's Output?
How Do I Conditionally Color Word Table Cells with Dynamic Data?
How Do I Connect to Multiple Data Sources?
How Do I Connect to Google Analytics Using CData
20.0.0 How Do I Connect to HubSpot using CData
How Do I Connect to Jira Data Source Using CData?
How Do I Connect to the Jira Cloud API as a Datasource From Designer?
How Do I Connect to a JSON Data Source?
How Do I Connect to a Microsoft Access Data Source?
How Do I Connect to a Microsoft SQL Server Data Source?
How Do I Connect to a MySQL Data Source?
How Do I Connect to a PostgreSQL Data Source?
How Do I Connect to a Salesforce Data Source?
How Do I Connect to an IBM DB2 Data Source?
How Do I Connect to an OData Data Source?
How Do I Connect to an Oracle Data Source?
How Do I Connect to an Oracle Datasource with a Non-default Listener Port?
How Do I Connect to an XML Data Source?
How Do I Connect to a SQL Database Using the Build SQL Schema Method?
How Do I Connect to Data Using My API Key for Authorization in Designer?
How Do I Correct "#NAME?" in Excel Report Template Cells Instead of Designer Tags?
How Do I Create a Custom Windward Function for the .NET Report Engine?
How Do I Create a Custom Windward Function for the Java Report Engine?
How Do I Create a POD?
How Do I Create a Report Designer Log File?
How Do I Create a Select Statement With the JsonPath Wizard?
How Do I Create a Select Statement With the SQL Wizard?
How Do I Create a Select Statement With the XPath Wizard?
How Do I Create an Equation With the Equation Editor?
How Do I Create Dynamic Formulas in Excel Templates?
How Do I Disable Report Designer in the Windows Registry?
How Do I Dynamically Set A Watermark
How Do I Embed One Template Inside Another?
How Do I Format Dates and Numbers With an Out Tag?
How Do I Generate Report Engine Source Code from Report Designer?
How Do I Group Data Using Nested ForEach Tags?
How Do I Install Fonts in Linux?
How Do I Load a POD?
How Do I Perform a Silent Installation of Report Designer Office Edition?
How Do I Rollback an Office Version?
How Do I Schedule Reports for Solo?
How Do I Show or Hide Microsoft Word Field Codes?
How Do I Skip Checks for Office and .NET in the Windward Installers?
How Do I Tell If a Font is Used in PDF Output?
How Do I Transition my PPTX Templates to 16.2.0 Charts and Bitmaps?
How Do I Transition my XLSX Templates to 16.2.0 Charts and Bitmaps?
How Do I Troubleshoot an Out Tag?
How Do I Turn Off AutoFit in Word Tables?
How Do I Turn On the Solo Server?
How Do I Uninstall the Report Designer
How Do I Use a Bookmark Tag?
How Do I Use a Chart Tag?
How Do I Use a POD?
How Do I Use a Query Tag?
How Do I Use a Set Tag?
How Do I Use Clean Template?
How Do I Use Datasets?
How Do I Use If, Else and EndIf Tags?
How Do I Use Input Parameters?
How Do I Use the Anchor and Var Properties in 16.2?
How Do I Use the Batch Select Wizard in Solo?
How Do I Use the Condition Wizard?
How Do I Use the ForEach Tag VarStatus Variables?
How Do I Use the Link and EndLink Tags?
How Do I Use Microsoft Office to Generate PDF Output in Report Designer?
How Do I Specify My PDF Output Builder in Report Designer?
How Do I Use the autotag() Excel Macro?
How Do I Use the New Bitmaps and Charts in 16.2?
How Do I Use the SQL Connection Debugger?
How Do I Use the Stored Procedure Wizard?
How Do I Use the Switch, Case and EndSwitch Tags?
How Do I Use the XPath Select Debugger?
How do I Update Many Tags at Once?
How Do I Validate Tags?
When Do I Use an Import Tag or an Out Tag?
When Should I Use Word's "Optimize for Compatibility" Setting?
How Do I Use the Salesforce Select Debugger?
How Do I Use the SQL Select Debugger?
How Do I Use the OData Select Debugger?
How Do I Use the JSON Select Debugger?
How Do I Use the JSON Connection Debugger?
How Do I Use the OData Connection Debugger?
How Do I Use the XPath Connection Debugger?
How Do I Use the Salesforce Connection Debugger?
How Do I Use Barcodes in Designer?
How Do I Create a Linked POD?
How Do I Load a Linked POD?
How Do I Use a Linked POD?
How Do I Change the Designer Add-In Language for the Ribbon?
How do I edit templates stored in Dropbox or OneDrive?
How Do I Edit the Datasource Connection on Output?
How Do I Get the PostGRE Connector to Work with Client Certificates?
How Do I Update Values in the Header or Footer with Values from the Templates ForEach Loop?
How Do I Alternate Row Layouts in a ForEach Loop?
How Do I Create a Dynamic Table of Contents for my Template?
How Do I Create a Custom Windward Function for the RESTful Report Engine?
How Do I Use Check Boxes In My Template?
How Do I Find My License Key Version?
How do I Share My Windows version and Office version with Support?
How Do I Format a Date in a Different Language
How to Convert JPEG (Exif) Image
Datasheets
1
Windward Designer
Reference
126
20.1.0 Update Connections Reference
Automatic Data Schema Reference
20.0.0 Automatic Data Schema Reference
Bookmark Tag Reference
Chart Tag Limitations
Chart Tag Reference
Connection Editor Reference
Connecting to a Salesforce Data Source
20.0.0 Connecting to a Salesforce Data Source
Data Access Providers and Authentication Protocols
Data Bin Reference
Data Sources Reference
20.0.0 Data Sources Reference
Differing Versions of Report Designer and the Engine
Equation Editor Reference
Error Handling and Verify Reference
15.34.0 Error Handling and Verify Reference
16.1 Error Handling and Verify Reference
16.2.0 Error Handling and Verify Reference
16.3.0 Error Handling and Verify Reference
16.4.0 Error Handling and Verify Reference
16.5.0 Error Handling and Verify Reference
16.6.0 Error Handling and Verify Reference
16.7.2 Error Handling and Verify Reference
Excel Report Template Output Limitations
20.0.0 Excel Report Template Output Limitations
16.7.0 Excel Report Template Output Limitations
Find/Replace Reference
ForEach and End ForEach Tag Reference
Generating SQL Datasource Schemas Offline
20.0.0 Generating SQL Datasource Schemas Offline
ADDTOTAL and GETTOTAL Functions
How to Calculate Running Totals with ADDTOTAL/GETTOTAL Function
HTML and CSS Tags and Attributes Supported By Out Tags
20.0.0 HTML and CSS Tags and Attributes Supported By Out Tags
16.7.0 HTML and CSS Tags and Attributes Supported By Out Tag
16.6.0 HTML and CSS Tags and Attributes Supported By Out Tags
16.5.0 HTML and CSS Tags and Attributes Supported By Out Tag
16.3.0 HTML and CSS Tags and Attributes Supported By Out Tags
If, Else and EndIf Tag Reference
20.0.0 If, Else and EndIf Tag Reference
16.7.0 If, Else and EndIf Tag Reference
16.5.0 If, Else and EndIf Tag Reference
16.3.0 If, Else and EndIf Tag Reference
16.2.0 If, Else and EndIf Tag Reference
Introduction to Linked PODs
Introduction to Standard PODs
20.0.0 Introduction to Standard PODs
16.7.0 Introduction to Standard PODs
16.5.0 Introduction to Standard PODs
Input Parameters Reference
Import Tag Reference
20.0.0 Import Tag Reference
16.7.0 Import Tag Reference
16.5.0 Import Tag Reference
16.3.0 Import Tag Reference
16.2.0 Import Tag Reference
JPath Wizard Reference
20.0.0 JPath Wizard Reference
16.7.0 JPath Wizard Reference
16.5.0 JPath Wizard Reference
Link and EndLink Tag Reference
List Imports Reference
List of Report Designer DLLs and JARs
20.0.0 List of Report Designer DLLs and JARs
16.7.0 List of Report Designer DLLs and JARs
Output Limitations
Out Tag Reference
20.0.0 Out Tag Reference
16.7.0 Out Tag Reference
16.6.0 Out Tag Reference
16.5.0 Out Tag Reference
16.4.0 Out Tag Reference
16.3.0 Out Tag Reference
16.2.0 Out Tag Reference
Query Tag Reference
Report Designer Office Edition Configuration File Reference
Report Designer Office Edition User Interface (Ribbon) Reference
Report Designer Options Reference
Set Tag Reference
20.1 Show/Hide Tag Reference
Supported Content Controls
Support For Microsoft Office Charts
Support for PowerPoint PPTX Format
SQL Wizard Reference
20.0.0 SQL Wizard Reference
16.7.0 SQL Wizard Reference
16.5.0 SQL Wizard Reference
16.3.0 SQL Wizard Reference
Switch, Case and EndSwitch Tag Reference
20.0.0 Switch, Case and EndSwitch Tag Reference
16.7.0 Switch, Case and EndSwitch Tag Reference
16.5.0 Switch, Case and EndSwitch Tag Reference
16.3.0 Switch, Case and EndSwitch Tag Reference
16.2.0 Switch, Case and EndSwitch Tag Reference
Tag Editor Reference
20.0.0 Tag Editor Reference
16.7.0 Tag Editor Reference
16.5.0 Tag Editor Reference
16.3.0 Tag Editor Reference
Tag Tree Reference
Template Debugger Reference
Template Layout Best Practices
Windward Equations Operators Reference
Windward Equations and Functions Overview
Windward Functions Reference
Windward Input to Output Formats
16.7.0 Windward Input to Output Formats
Windward Tags Reference
20.0.0 Windward Tags Reference
16.7.0 Windward Tags Reference
16.5.0 Windward Tags Reference
16.3.0 Windward Tags Reference
15.0.0 Windward Tags Reference
20.0.0 Windward Input to Output Formats
Word (DOCX) Report Template Limitations
20.0.0 Word (DOCX) Report Template Limitations
16.5.0 Word (DOCX) Report Template Limitations
XPath Wizard Reference
20.0.0 XPath Wizard Reference
16.7.0 XPath Wizard Reference
16.5.0 XPath Wizard Reference
Data Tree Reference
Data Count Reference
REGEXREPLACE Function
PDF Shapes Limitations
Miscellaneous
9
Handling NULL and Non-existent Results in 16.3.0
How Do I Upload Files to Mega.nz?
List of Report Designer v15.2 DLLs and JARs
Windward Designer (f.k.a. Autotag) Dependencies
Windward Software Installers
Windward Reports and DocuSign Anchor Tags
Windward Reports and OneDrive Directories
Where is the datasource information stored within a template?
Headers And Footers on PDF Imports
Generate Manual PDF
Recent Updates
Windward Software Installers
How Do I Perform a Silent Installation of Report Designer Office Edition?
How Do I Create a Custom Windward Function for the .NET Report Engine?
How Do I Create a Custom Windward Function for the Java Report Engine?
Differing Versions of Report Designer and the Engine
More