Small and medium business | Business Central, N...

Columns customization in Excel Report

(0) Share

Report

Posted on by Prathama

Hi Guys,

I want to make an excel report,

For e.g. I have two columns i.e Type and Vendor Name, if my Type is the same i.e. Item then I want to show each vendor name display in three different columns in excel report as per the below image.

Let me know if there are any ways to do this.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

AbhinavMehra 364 on at

Like (0)

Report

RE: Columns customization in Excel Report

Hi,

For this you need to contact your partner to build Report where he can use matrix concept for dynamic Vendor name and group by Type.

You need to provide more details to them like from which table to you want to get data also.

Was this reply helpful? Yes No
Prathama 94 on at

Like (0)

Report

RE: Columns customization in Excel Report

I have to Develop it, how can I do it.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

RE: Columns customization in Excel Report

What is the figure you want to display under each vendor name?

Was this reply helpful? Yes No
Hein Kruger 629 on at

Like (0)

Report

RE: Columns customization in Excel Report

Hi,

You can do this by creating a report as normal, Set ProcessingOnly =True.

Create a Header and Body Procedure:

add a "CreateExcelWorkbook" procedure:

add CreateExcelBook Procedure to OnPostReport Method.
Add MakeHeader() to OnPreReport()
Add MakeBody() to the OnAfterGetRecord of the DataItem that will be the repeater. (Like Sales line)

How it works:
The TempExcelBuffer Table is built first. After the report has run the Excel Worksheet is created and the TempExcelBuffer data is added to the Workbook.
You Should be able to get your result by playing around with the data items and adding more procedures.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,307 Super User 2025 Season 2 on at

Like (0)

Report

RE: Columns customization in Excel Report

Hi, After setting the required data in Dataitem, I think it should be possible to use Excel formulas.

Here is a simple example, hope this can give you some hints.

https://yzhums.com/23873/

Thanks.

ZHU

Was this reply helpful? Yes No
Prathama 94 on at

Like (0)

Report

RE: Columns customization in Excel Report

I want to display 'Price' from my customization page under each vendor name.

Was this reply helpful? Yes No