Inforiver
FormulaPricingProductAll Products
Reporting & Writeback Matrix Docs
Reporting & Writeback Matrix Docs
  • Introduction to Inforiver
    • Why Inforiver
    • Get Started
      • Installing Inforiver for yourself
      • Installing from AppSource
      • Installing Inforiver for your organization (Org visual)
      • Inforiver Writeback Matrix pre-requisites
        • Whitelist Inforiver IPs
        • Admin consent for Inforiver's Entra ID
          • Basic consent
          • Full admin consent
      • Inforiver Customer Portal
        • Billing Admin
          • Update Profile
          • Update Subscriptions
        • License Admin
      • Licensing
        • License renewal
      • Registering Inforiver on Azure AD (Entra ID)
  • Working with Inforiver
    • 1. Build your first Inforiver report
    • 2. Displaying information
      • Report interface
      • Layout options
      • Templates
      • Basic formatting
        • Number formatting
        • Cell, header & value formatting
        • Totals & subtotals
        • Insert blank rows
      • Basic inline charts
    • 3. Basic interactions
      • Explore & filter data
        • Search & Filter
        • Explorer
        • Top N + others
      • Sort & reorder data
      • Show/hide values
      • Manage column widths
      • Manage hierarchies
      • Create visual hierarchies
      • Pin rows & columns
      • Blend measures
      • Dynamic measure headers
      • Context menus
        • Column gripper
        • Row gripper
      • Actions
        • Rails
        • Toolbar options
        • Keyboard shortcuts
        • Reset
    • 4. Adding business logic and formulae
      • Insert calculated rows
        • Template rows
      • Insert calculated columns
      • Insert manual input rows
      • Insert manual input columns
        • Number
        • Dropdown
          • Dropdown options from semantic models
          • Lookup visuals for dropdowns
        • Text, checkbox & date
        • Writeback Matrix features
      • Invert sign
      • Editing cells
      • Quick formula
      • Visual column inside visual measures
      • Manage inserted rows
      • Manage inserted measures & columns
      • Pivot data
      • Insert image URLs
    • 6. Working with charts
      • Sparkline charts
      • Stacked charts
      • Bullet charts and clustered bar charts
      • Waterfall charts
      • Bar and pin charts
      • Change/deviation charts
    • 5. Conditional formatting
      • One-click options
      • Create rule
        • Rules (If conditions)
        • Color scale & data bars
        • Classification
        • Ranking
      • Manage rules
    • 7. Planning, budgeting & forecasting
      • What-if analysis & simulations
      • Goal Seek
      • Scenarios (Writeback Matrix only)
      • Budgeting & allocations
      • Forecasting
        • Date rollover and extending forecasts
        • Editing forecasts and reforecasting
        • Autoclose forecasts
        • Distribute deficit
        • Row level forecast
        • User Access Control
        • Common Scenarios
          • Forecast using a Blank Template
          • Forecast using Existing Data
          • Adding Forecasts for Periods unavailable in the model
          • Creating daily and weekly forecasts
      • Set version
    • 8. Paginated reporting
      • Pagination
      • Header & footer
        • Text
        • Images
        • Charts
        • KPI cards
      • Report layouts (Report+)
      • Display and themes
    • 9. Commenting and collaboration
      • Notes
      • Comments
        • Data-level comments
        • Assign & track tasks
        • Track changes
        • Report-level comments
        • Comment settings
    • 10. Exporting reports
      • Export to PDF & Excel
        • Excel export - operational boundaries
      • Ad-hoc emails
      • Snapshot (Writeback Matrix only)
        • Comparing snapshots
    • 11. Scheduling reports
      • Create new subscription
        • Select a report
        • Set subscription frequency
        • Select destination(s)
          • Email
          • OneDrive
          • Microsoft Teams
          • SharePoint
        • Review & save subscription
      • Manage your subscriptions
      • Administration
    • 12. Data writeback
      • Settings
        • General Settings
        • Data Settings
        • Destination Settings
        • Writeback security settings
        • Writeback time-out & batch size settings
        • Advanced Settings
      • Destinations
        • Azure SQL (Managed DB)
        • Azure SQL
        • Microsoft SQL Server
        • Synapse Dedicated SQL Pool
        • Azure Data Lake Storage
        • Databricks
        • Snowflake
          • Setting up Snowflake OAuth
        • Amazon Redshift
        • BigQuery
        • SingleStore
        • SAP HANA
        • Oracle
        • PostgreSQL
        • MySQL
        • OneDrive
        • SharePoint
        • Dataverse
        • Fabric Warehouse
        • Fabric lakehouse
        • Fabric SQL
        • URL as destination
      • Logs
      • Reading mode
    • 13. Context awareness
    • 14. Manage aggregation
      • Row aggregation
      • Column aggregation
    • 15. Managing Inforiver Writeback Matrix visuals
      • Inforiver deployments in Power BI pipeline setup
      • Duplicating Writeback Matrix Visuals - Best Practices
      • Recommended practices while working with Power BI desktop
    • 16. Approval workflows
    • 17. Collaborative adjustment workflows
    • 18. Variables
      • Variable types
        • Number
        • Select
        • Text
        • Date
        • Date range
        • Boolean
        • Button
      • Variable bookmarks
    • 19. Leveraging Power BI bookmarks
  • Admin Console
    • Manage Profile
    • User management
      • User Roles and Permissions
      • Create custom roles and policies
    • Settings
      • General
      • Generate builds - on prem
      • Forecast
      • Holidays
      • API token
      • Writeback
      • Managed DB
      • Assets
    • Onboarding actions
    • Writeback
  • Display settings
    • General settings
    • Hierarchy settings
    • Number settings
    • Miscellaneous settings
    • On-load scripting
  • Formula syntax
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
      • FILTERIF
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • AVERAGEIF
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • INDEXOF
      • LOG
      • ODD
      • MAX
      • MIN
      • NORMDIST
      • NORMSDIST
      • NORMINV
      • NORMSINV
      • PCT
      • POWER
      • RAND
      • RANDBETWEEN
      • ROUND
      • SORT
      • SQRT
      • SUM
      • PMT
    • Text formatting functions
      • CONCATENATE
      • HYPERLINK
      • LEFT
      • LOWER
      • MID
      • PROPER
      • REPLACE
      • REPT
      • RIGHT
      • TEXT
      • TRIM
      • UPPER
      • VALUE
    • Date functions
      • DATEADD
      • DATEDIFF
      • DAY
      • DATE
      • DATE.SET
      • DATE.FORMAT
      • SOWEEK
      • SOMONTH
      • SOQTR
      • SOYEAR
      • EOWEEK
      • EOMONTH
      • EOQTR
      • EOYEAR
      • NETWORKDAYS
      • ADDDAYS
      • ADDWEEKS
      • ADDMONTHS
      • ADDQTRS
      • ADDYEARS
      • FROMEXCELDATE
      • MONTH
      • NOW
      • PERIOD_RANGE
      • TODAY
      • TOEXCELDATE
      • YEAR
    • Time intelligence functions
      • AGGREGATE
      • FILTER
      • COLUMN_PERIOD
      • LASTNDAY
      • LASTNMONTH
      • LASTNQTR
      • LASTNYEAR
      • MONTHPERIOD
      • MOVINGAVERAGE
      • MOVINGSUM
      • MTD
      • NEXTNDAY
      • NEXTNMONTH
      • NEXTNQTR
      • NEXTNYEAR
      • QTD
      • QTRPERIOD
      • SHIFT
      • TOTALYTD
      • TOTALQTD
      • TOTALMTD
      • VALUEAT
      • YEARPERIOD
      • YTD
    • Other operators
    • Identifiers
      • CLOSEDPERIOD
      • COLUMN.DATE
      • COLUMN.PARENT
      • COLUMNS
      • CURRENT_PERIOD
      • DESCENDANTS
      • FORECAST.CLOSED_END
      • FORECAST.CLOSED_START
      • FORECAST.OPEN_END
      • FORECAST.OPEN_START
      • GROUP INDEX
      • HAS
      • HAS_ALL
      • HAS_SOME
      • LEAVES
      • LEVEL
      • LOGGEDIN_EMAIL
      • LOGGEDIN_NAME
      • MATCH
      • MAXDATE
      • MEMBERS
      • MINDATE
      • RELATIVE
      • RELATIVE_COLUMN
      • ROW.PARENT
      • ROW.LABEL
    • Scripting functions
      • DISPLAYTOAST
      • EXPORT
      • LAYOUT
      • SETCFRULE
      • SETFILTER
      • SETFILTERBYINDEX
      • SETVISIBILITY
      • SHOWBETWEENPERIOD
      • SHOWCLOSEDFORECAST
      • TOPN
      • DISPLAY SETTINGS
        • SETBLANKLABEL
        • SETSUPPRESSZEROS
        • SETRAGGEDHIERARCHY
        • SEPARATOR
        • SETCOMBINECOLUMNHEADER
        • SEMANTICFORMAT
        • SHOWNULLAS
        • SHOWZEROAS
        • SINGLECHILD
    • Miscellaneous functions
      • FETCH
      • LOOKUP
    • Measure/Column selection functions
      • GETCOLBETWEENPERIODS
      • GETMEASURE
  • Advanced topics
    • Audit log
    • Backup & restore report config
    • Enterprise themes
    • PowerPoint integration
    • Drill down and roll up in performance mode
  • Infobridge
    • 1. Create bridge
    • 2. Add source to bridge
    • 3. Bridge Interface
    • 4. Manage queries
      • Query transformations
        • Append
        • Join
        • Duplicate
    • 4. Manage sources
    • 5. Insert rows from bridge
    • 6. Insert measure from bridge
    • 7. Manage Integration of visuals
    • 8. Manage Bridges
    • 9. Data transformations
      • Pivot table
      • Group by
      • Add Column
      • Pivot column
      • Rename column
      • Find and Replace
      • Remove measure
      • Filter rows
      • Sort
      • Text functions
      • Unnest
      • Round
      • Extract Comments
      • Import and export
    • 10. Integrating forecasts
    • 11. Collaborative adjustments
  • Accessibility shortcut keys
  • Inforiver Reporting Matrix FAQs
  • Inforiver Writeback Matrix FAQs
  • Video tutorials
  • Resources
  • Release Notes
    • Inforiver Writeback Matrix May 2025 - v4.4.3
    • Inforiver Writeback Matrix April 2025 - v4.4.2
    • Inforiver Writeback Matrix April 2025 - v4.4.
    • Inforiver Writeback Matrix March 2025 - v4.3 - Time series formulae
    • Inforiver Writeback Matrix - March 2025 - v4.2
    • Inforiver Writeback Matrix March 2025 - v4.1
    • Inforiver Reporting Matrix March 2025 - V3.3.3 -New formatting and export options
    • Inforiver Writeback Matrix Feb 2025 - v4.0 - User permissions, High-performance mode, Input rules
    • Inforiver Writeback Matrix January 2025 - v3.9 - Fabric support, upgraded variables interface
    • Inforiver Writeback Matrix December 2024- v3.8 - Improved Scheduler Performance & Other Enhancements
    • Inforiver Writeback Matrix December 2024 - v3.7 - Merge rows, new rounding functions & More
    • Inforiver Writeback Matrix November 2024 - v3.6.2 - Import from Google Sheets & More
    • Inforiver Writeback Matrix October 2024 - v3.6 - Approval Workflows & Other Enhancements
    • Inforiver Writeback Matrix October 2024 - v3.5 - Lookup visuals & more
    • Inforiver Reporting Matrix Nov 2024 - v3.3 - Variables
Powered by GitBook
On this page
  • 1. Interface
  • 2. Creating and customizing cells
  • 3. Inserting dates/symbols/page numbers/measure values
  • 4. Presets
  • 4.1. Header preset
  • 4.2. Footer preset
  • 5. Cell and container customizations
  • 5.1. Cell
  • 5.2. Container

Was this helpful?

  1. Working with Inforiver
  2. 8. Paginated reporting

Header & footer

PreviousPaginationNextText

Last updated 9 months ago

Was this helpful?

The header and footer in business reports provide a consistent way to identify the content, promote the company's brand, and ensure that important information is easily accessible. Inforiver offers powerful header & footer customization capabilities and can be used to show charts, KPIs, images, and text.

Below is a sample report created using Inforiver. You can see a header with a KPI card, report title, and a donut chart. The footer contains the company logo and page number.

The header & footer module is organized as follows:

1. Interface

Let's first take a look at the header/footer interface.

STEP 1: Click on Header & Footer in the Design tab. Alternatively, hover over the header and select Edit from the hamburger menu.

STEP 2: The Header & Footer ribbon is enabled. You can see there is a default header that shows the fields added and the scaling.

Hiding the header

Select the Hide Header option from the context menu if you do not wish to display the header. You can display it again at any time by selecting the Show Header option from the context menu.

Resetting the header

You can remove customizations and restore the default header by selecting the Reset option from the header context menu.

2. Creating and customizing cells

The header/footer containers can be split into cells and customized further. Let's first look at creating and managing cells.

STEP 1: Go to the edit mode by clicking the Edit in the context menu. You can also edit the header by clicking the Header & Footer button in the Design ribbon.

In this section, we have used the example of headers but all of these properties apply to footers as well.

STEP 2: Notice that there are two controls - one on the side and one at the top of the container.

Clicking on the control on the side will give options to split the container vertically. To split the container horizontally, click on the control at the bottom.

On selecting the Split panel to the right option, notice that a new cell is inserted to the right of the existing content.

STEP 3: The container height can be adjusted by hovering on the bottom border and dragging the handle. The width can be adjusted by dragging the handle that is enabled on hovering over the cell border.

STEP 4: Click the plus icon to insert elements like Text, Image, Chart, and KPI which are covered in subsequent sections.

STEP 5: When you click on the + icon, you will be prompted to either replace the contents of the current container or insert a new container.

If you choose the Replace the selected Container option, the chosen element (chart, text, KPI, images) will be inserted into that container.

You can also choose to insert a new container to the right/left/top/bottom of the existing container. In the second image, notice how the chart is inserted in a new container below the currently selected container.

STEP 6: After inserting an element, you can use the container controls to copy/paste the contents of a cell. You can also reset or delete a cell.

3. Inserting dates/symbols/page numbers/measure values

Use the Insert dropdown menu to add the predefined text elements listed below:

  • Page Numbers: Supported formats 'Page X of Y', 'Page X/Y', 'Page X'. You can use the page numbers in the header to traverse the report.

  • Date: Select from the different supported formats

  • Symbols: Insert symbols denoting trademark or copyright or choose an emoji.

  • Data Field: Select any dimension or measure. The dimension values and measure totals are displayed in the header.

The image below shows various predefined text elements inserted in the header.

4. Presets

Before looking at creating header/footer elements from scratch, let's see how to leverage presets to insert header/footer in a single click.

4.1. Header preset

STEP 1: In the Header & Footer tab, expand the Type dropdown menu and select Presets > Header. A side panel opens up as shown below. Choose any of the presets and click 'Proceed' in the warning message.

STEP 2: You can see that the header has been updated. These can be further customized but for now, let's go ahead with the preset. Click on Close editor to apply the preset.

4.2. Footer preset

Inforiver also offers a number of footer presets with page numbers, report titles, logos, etc.

STEP 1: To display the footer, select Show Footer from the header context menu. The default footer displays the current date.

STEP 2: You can open footer presets either from the footer context menu or navigate to the Header & Footer ribbon > Expand the Type dropdown > Select Footer from the Presets section. A side panel opens with a list of the available presets. Select a preset and click Proceed in the warning pop-up. Click Close Editor to apply the changes.

STEP 3: The footer displays the page number by default. You can disable the Inforiver pagination using the Pagination toggle from the context menu.

Hiding the footer

To hide the footer, select the Hide Footer option from the context menu.

5. Cell and container customizations

All cells regardless of the type (Text, Image, etc.) can be formatted using the Cell and Margin sections of the Header & Footer toolbar. The header/footer containers can be formatted using the Container section.

Multiple cells can be selected using Ctrl + Click and formatting can be done in one shot. In the Basic customization section, we have used the example of headers but all of these properties apply to footers as well.

5.1. Cell

Using the options in this section, you can align the contents, apply fill, border or shadows, and more.

a) Horizontal/Vertical align - Contents in a cell can be aligned horizontally and vertically as shown below.

b) In addition to using the handles, you also have an option in the toolbar to split the container or cells.

c) On selecting two cells, you can swap them by using the 'Swap container' option.

d) Fill - Fill color can be applied to one or more cells by using the color picker.

e) Shadows can be applied to cells as shown below.

f) Borders - Borders can be applied for cells, you can set the weight, corner radius and choose a color.

5.2. Container

The following options are available for the header/footer containers - Appearance and Margin.

a) Styles: You can apply a border to the container by selecting the Appearance>Styles option. You can specify the border color and thickness from the Header Appearance dialog box.

b) Container inner controls: The container controls are removed if this option is enabled.

d) Ruler: You can see rulers on the top and left of the container. It shows the x and y coordinates for any point within the container.

e) Position: You can change the position of the header and place it on the right or left side.

f) Margin: Top, bottom, right, and left margins can be applied to cells as shown in the below image.

- Overview of the toolbar, header & footer sections, presets, basic interactions, and basic customization options

- Adding formatted text and using presets like page number, data fields

- Adding images from local files and organizational workspace

- Types of charts and customization options

- KPI presets and customization options

The blue box is called the container. Currently, there is only one cell in the container with the default fields and scaling. Containers can be split into many cells and used to create elements like , , , and . We'll be covering container customizations in later sections.

If you choose a KPI preset, any selections made in the will be reflected in the header as well.

In the next section, we'll be covering adding formatted in the header/footer.

Text
Images
Charts
KPI cards
Text
Image
Chart
KPI
KPI explorer
text
Introduction
Customized header and footer
Header and footer option
Header and footer ribbon
Hide header option
Editing the header
Controls to split the container
Split vertically
Split horizontally
New cell inserted
Adjusting the container height
Insert element
Replace selected container
Chart inserted into the chosen container
Insert new container option
New container insrted below selected container
Additional options
Types of elements
Inserting pre-defined text elements in the header
Page numbers/ dates/ symbols and data fields inserted
Header presets
Applying a header preset
KPI explorer selection reflected in presets
Footer enabled
Footer presets
Inforiver pagination and footer pagination
Cell customization options
Alignment options
Split cell/container
Swap cells
Fill color for cells
Shadow for cells
Custom borders
Appearance and margin
Header border
Border applied to header
Container controls
Ruler