IBM Sustainability Software - Ideas Portal
Hide about this portal


This portal is to open public enhancement requests against the products and services belonging to IBM Sustainability Software. 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 (https://ideas.ibm.com).


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 (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Add a new idea Subscribe
Status Planned for future release
Workspace IBM TRIRIGA Real Estate & Lease Accounting Management
Created by Guest
Created on May 20, 2019

RELATED IDEAS

Tririga BIRT report excel export - remove superfluous empty and merged columns

See this idea on ideas.ibm.com

In Tririga Lease Accounting product, ABB is using build in BIRT Disclosure reports for the lease accounting closing (monthly/quarterly/yearly).
After exporting the reports to excel, we need to be able to do further calculation steps in excel, e.g. using pivot tables.
Currently the excel export tables contain multiple superfluous empty columns, with the cells merged to the real data column cells.
With the large number of records in the reports, it takes > 10 min of manual deleting of these columns, before our users are able to reuse the excel tables.
In addition to the time it takes, this manual process is well very error-prone.
Suggestion is, to update the Tririga BIRT report template elements stored in the TRIRIGALibrary.rptlibrary in a way, that is does not create the superfluous columns in the excel report.

Idea priority Medium
  • Post comment
  • Guest
    Reply
    |     Feb 23, 2021

    Thank you for submitting your enhancement request. We think this is a good idea and will target this for inclusion in a future release.

  • Guest
    Reply
    |     Dec 3, 2019

    Thank you for submitting this request. It is currently under review.

  • Guest
    Reply
    |     Jun 7, 2019

    Also, the ccy / currency abbreviations could be taken out of the number report field so that calculations could be performed in excel.

  • Guest
    Reply
    |     May 20, 2019

    Attachment (Description): Sample excel export of BIRT report

    ABB sample - BI...
    ABB sample - BIRT report export.7z
     ABB sample - BIRT report export.7z
  • Guest
    Reply
    |     May 20, 2019

    Attachment (Description): How to export the BIRT report

    Excel export.PNG
    Excel export.PNG
  • Guest
    Reply
    |     May 20, 2019

    Attachment (Description): Sample Report Link in Tririga UI

    Disclosure Repo...
    Disclosure Report sample.PNG

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.