Problem with Report that includes Chart

Support
,
#1

Hi,

I am trying to create an Excel report that contains a table and a chart. Should this be possible?

I took the Library sample project and enhanced the Book Availability report to include a chart. The report generates successfully but the data ranges in the chart are not updated like the table data is.

Does anyone have a sample project with a report having a chart I can look at?

Thanks.

Actual Report
Actual Report

Expected Report
Expected Report

Template Screenshot
Template Screenshot

Template File
BookAvailabilityWithChartTemplate.xlsx (9.2 KB)

#3

Hello Keith,

We’ve taken a look at your template. The problem was the following: to include a chart in a report, you need to 1) create an empty band in the report structure for this chart, 2) create a named region in the template file with the same name as this empty band, 3) create the chart within this named region.
chart-in-report

Here’s the report you can check:
Book availability in department.zip (16.1 KB)

Maybe this sample project will also be useful for you.

We’ll update the Reporting documentation to make this use case more clear.

#4

Hi Olga,

Thank you very much. So I needed an extra band and region for the chart. I don’t understand it yet (technically) but I’m happy it works. Thanks again.

1 Like