Skip to Main Content
IBM Power 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:

Post your ideas

Start by posting ideas and requests to this portal to enhance a Power product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas and add comments to ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The Power teams will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

Specific link you will want to bookmark for future use

IBM Unified Ideas Portal - - Use this site to create or search for existing Ideas across all IBM products that are outside of Power, and track all of your personal interactions with all Ideas.

Status Planned for future release
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
    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.