Skip to Main Content
IBM Power Ideas Portal

This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.

Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Status Delivered
Workspace IBM i
Categories Db2 Web Query
Created by Guest
Created on Jun 11, 2020

Enable Excel Table functions In Db2 Web Query and ability to specify Freeze Headings, Rows or Columns

Db2 Web Query V2.2.1 currently allows you to specify Excel as Output type for a report or for a document. In the case of a document, you can create multiple reports inside the document. When run, the document generates tabs for each report. So far, so good.

The WQ options for Excel output type lack the ability to specify that the header area be frozen to allow heading rows to be visible when data area is scrolled. Please enable Freeze Heading in WQ to generate Excel sheets with scrolling data under fixed headings.

Excel has the ability to specify a report area as a TABLE, which adds sort/filter arrows to each column. Please enable a the Table option in WQ for Excel output to provide the Excel Table feature on delivery of the generated sheets within a Workbook.

Use Case:

Client wishes to create a Web Query document to be emailed by WQ Standard Edition report broker to Sales Representatives at End of Month.

Such document may contain multiple reports on tabs with views of business data related to the Sales Rep. Reports on each tab of the workbook need to have frozen headings to enable scrolling by the recipient as well as table areas to facilitate sorting and selection or filtering.

The Excel TABLE function provides this but WQ currently does not support generating an Excel xlsx with the features enabled.

WQ Active reports provide some of this function, but in a compound document setting Active reports do not provide subtotals and totals .

Idea priority Medium
  • Guest
    Jan 17, 2023
    IBM believes this functionality has been delivered in the new Web Query 2.4.0 release. For more information, please visit our wiki page at

    - IBM Power Systems Development
  • Guest
    Jun 15, 2021

    IBM agrees with the request and a solution appears to be desirable and feasible. IBM intends to provide a solution. However, BM's plans may change and no commitment is made that a solution will be provided.