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 want to display 'Price' from my customization page under each vendor name.
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?
I have to Develop it, how can I do it.
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.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156