If JavaScript is disabled, please continue to the
sitemap
.
Infor Query & Analysis Online Help
Home
Back
Back
Forward
Forward
Search
Copy URL
PDF
Print this page
Topic URL copied to clipboard
Show the Table of Contents
Hide the Table of Contents
About Query & Analysis
Extracting data
Absolute and relative cell addressing
Automatic filter lookups
Query Definition dialog
Setting filter options
Selecting filter options
Extraction types
Sorting output items
Output options
Period selection
Selecting a period
Current Period Override
Date lookup
Report style
Using Auto Format
Report Designer
Accessing and exiting Report Designer
The Report Designer window
Creating a simple report
Creating a simple report without Page Headers or Totals
Designing a report
Adding and deleting columns
Adding and deleting empty columns
Moving columns
Copying columns
Adding and removing rows
Adding and deleting names
About sections
Adding and deleting sections
Expanding and collapsing subtotal rows
Example of adding headers and subtotals
Example of setting different levels for headers and subtotals
Adding a running total
Example of adding running totals
Including filters in your report layout
Example of setting a filter
Including user-defined outputs in your report layout
Example of including user defined output in a report
Clearing content
Formatting cells
Selecting a cell category
Aligning cells
Selecting a font
Adding a border
Adding a background color to the report design
Copying a formatted cell using Format Painter
Clearing the formats applied to cells
Cell Referencing in Report Designer
Summary links
Creating a summary link
Summary reports
Creating a summary report
Detailed reports
Creating a detailed report
Reference links
Creating a reference link
Named cells
Creating named cells
Filtering on named cells
Designing efficient reports
Data extraction examples
Drilling down
Drill Path Manager
Current Drill Path
Replay Saved Drill Path
Removing Saved Drilled Path
Linked sheets
Moving the Drill Path Manager
Resizing the Drill Path Manager Window
Summary Drilldown
Using Summary Drilldown
Transaction Drilldown
Using Transaction Drilldown
Breakout
Using Breakout
Expand
Using Expand
Drilldown examples
Suppressing zeros
Using Zero Suppress in rows or columns
Suppressing zeros in reports
Suppressing zeros in drilldown functions
Example using Zero Suppress in the Breakout function
Suppressing zeros in analysis sheets
Analyzing data
Recalculating
Data Send
Data Send dialog
Constructing a Data Send definition
Creating a Data Send
Data Send to SunSystems SSC
User-defined outputs
Creating user-defined output
Managing user-defined output
Output formats
User-defined output functions
&
Mid
Left
Right
UCase
LCase
DateDiff
DateValue
DateSerial
Day
WeekdayName
Month
Year
Now
DateTime
CDATE
And
OR
If statements
Mathematical operators
Excel plugin utilities
Enabling the Excel plugin checker
DataLink Server utilities
Setting up user details
User password policies
Editing a user
Deleting a user
Clearing a user
Using the user wizard
Adding a user profile
Editing a user profile
Deleting a user profile
Assigning user profiles
Restricting Table level access
Setting up the log details
Setting up email
Setting the client setup
Viewing the server events and log file
Viewing the server settings and statistics
Web-enabled user management
Accessing and exiting User Management
The User Management window
Adding a user
Editing a user
Deleting a user
Unlocking a user
Clearing users
Resetting a password
Mapping a user to a SunSystems user
Clearing the DataLink cache
Macros
Supported macros
Creating macros
Recalculate the report
Run and populate a query formula
Insert and run a query formula
Executing an Internal Data Send Definition
Log on / log off server
Alert Scheduler
Alert Scheduler
Alert tasks
Creating Alert tasks
Managing Alert tasks
Administering Alert tasks
Alert processes
Creating an Alert Process
Creating a Microsoft® Office Excel Process
Scheduling the Workbook
Creating a Command Line Process
Creating an E-mail Process
Scheduling a task
Defining the duration and frequency of a Scheduled Task
Editing a scheduled event
Utilities
Migrate
Offline Formulas
Hierarchy Designer
Creating a parent hierarchy
Managing hierarchies
Adding a parent node to the hierarchy
Adding a child node to the hierarchy
Removing a node from the hierarchy
Removing all nodes from a hierarchy
Validating filters in the hierarchy
Hierarchy extraction types
Extracting data from hierarchies
Reporting on a hierarchy
Filtering on a hierarchy
Product Task
Adding a product task to a workbook
Formula Import
Change Password
Open link in new tab
Open link in new window
Copy link to clipboard