Generating Report using Multiple Data Sources in Spreadsheet Document Leave feedback
NoteIn this article, we will use GroupDocs.Assembly to generate a report. This report will fetch data from multiple data sources.
NoteThe code uses some of the objects defined in The Business Layer.
- Add a bullet list at the place where you want it to display clients’ names.
- Insert a table with two columns, that will show managers’ and their contact prices.
- Save your Document
As a report developer, you are required to generate a report that fetches data from two different data sources (e:g custom object, excel data table). Report must show following information:
- Bulleted list of clients
- A table showing managers’ along with their contract prices and sum of contract prices
In-cell list
We provide support for the following clients:
<<foreach [in getClients()]>>
- <<[getName()]>><</foreach>>
Multiple-cell list
We provide support for the following clients:
<<foreach [in getClients()]>>
- <<[getName()]>>
| Total Contract Prices by Managers | |
|---|---|
| «foreach [group in contracts .groupBy(c => c.Manager) .orderBy(g => g.key)]» «[group.key]» | «[group.sum( c => c.Contract_Price)]» «/foreach» |
Get the template from here.
Was this page helpful?
Any additional feedback you'd like to share with us?
Please tell us how we can improve this page.
Thank you for your feedback!
We value your opinion. Your feedback will help us improve our documentation.
