94
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.
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.
Thanks.
ZHU
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.
What is the figure you want to display under each vendor name?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (