Skip to main content

Allocation report (XLSX)

Overview

This is a template you can use to build customized allocation reports in XLSX format. Import the sample in the jsreport UI. Once it is imported, you can generate the report from FA Back (for more information, see Generate reports for portfolios in FA User Guide).

Allocation_Excel_Report_Screenshot.png

Notice

The report requires the shared folders to function correctly (see Sample reports).

Highlights

The sample report includes the following:

  • an externally created XLSX asset file that acts as the layout for the report

  • a jsreport template that modifies the asset file to produce the complete report

  • a GraphQL query to fetch portfolio allocation by selected grouping and security

Files

Sample allocation report (XLSX):

sample-allocationReportXLSX.jsrexport

Shared folders containing translations:

sample-sharedFolders.jsrexport