Formatting a report with charts

JonT shared this problem 2 months ago
Defect Logged

I have a report that yields about 21,600 lines and 6 charts for an entire month's worth of data. In the report, there is data for CPU, memory, HDD percents and network bandwidth utilization. I have done a LOT of testing to get this to work correctly, to the point that I limited the data to 3 days and added each chart one at a time. I get to about 4 and the table data and reports start to overlap. There doesn't seem to be a place where the table data gets pushed to the next page after the last chart, it just overlaps. The only thing I have found that works is to set the canvas area for the charts to be around 6,000 (about 2,000 pixels(?) larger than the actual needed space for the charts).

Looking for guidance on where to make changes or things that can be done that will either automatically move the table data to the next page or simply just format it as expected. I have tried with A0-A5 and all the other page formats and portrait/landscape orientation.


These are the settings we have for export, but I have tried to adjust these to get a different outcome.

/fa1de1941651433e6c55602f5aa713d6

We are on version 7.4 and are limited to application updates based on the current vendor's integration to the product. If anyone has any suggestions as to how to best format a report with charts to prevent this from happening, that would be appreciated.

Comments (6)

photo
1

Hi Jon,


Thanks for your question.


My first question is what is the desired output of this multi-chart Report? Is it to be used as a standalone Report, or are you intending to use it on a Dashboard? Would you be able to provide some screenshots of what you mean by overlapping, as well as a screenshot of the current workaround with the expanded canvas size. If there is any sensitive information, please let me know and I can move this to a private ticket.


If you could also send through your /info.jsp page, this will be informative as to which version and build that you are currently using so that I can make an attempt to replicate this behaviour.


Kind regards,

Simon

photo
1

Hi Simon,

The purpose of the report will be emailed to users at the end of the month providing charts for the data represented in the table (rows of performance data). The version information is in an attachment in this thread.

Here is a screenshot of the issue. I deleted the sensitive info, but the issue with the graph is effectively seen in the screenshot.

/b6f411bbee2ee7771e2e420087f62f76

You can see that the last graph (in this instance) is pushed well below the second to last graph.


The settings for the canvas that yield this result is below.

/0f16226c0c383e3ec82fc2e2a3e44b71


I had to adjust the canvas to these settings to push the table data below the report. The additional 2400 pixels was simply to push the table data down far enough. The first page of the report is the report header and the first chart does not show until the second page with 6 charts. With 1-2 charts, the charts will show on the first page and I believe it does not overlap the table data until the 4th chart.

/f15ff630446c70146f7fc661740155b0


This is the screenshot of the settings that "work".

/6975115d8d918a322f40d6eaf7892029

photo
1

Hi Jon,


I've just done a lot of testing myself and have been replicate this issue. I can see that there is an existing defect that has been raised, in relation to the library used to export to PDFs. Unfortunately, there doesn't seem to be an easy solution to this as I'm sure you've found. One workaround might be to Export the Report Chart and Table separately, in two separate Reports, where you could potentially link them as co-displayed Reports, although I understand that this may be a little inconvenient to implement and maintain.


One thing that may help down the line is that the ability to export Dashboards as PDFs is coming in the next release of version 9. I doubt this will be coming in version 7 and 8 due to the complications with back porting, however, I believe this would definitely provide a solution to your use case.


I've added you to the defect, so I will reach out when I hear more information on whether this will be resolved, however, as version 7 is nearing end of life, unfortunately, I do not anticipate this will be the case.


Let me know if you have any further questions.


Kind regards,

Simon

photo
1

Hi Jon,


I just wanted to check in with you regarding this ticket, to see if you had any lingering questions. If not, I will shortly go ahead and mark this ticket as Defect Logged, which means that I will get back in contact with you later down the track when there have been updates made to the Developer Task.


Kind regards,

Simon

photo
1

Sorry Simon, I meant to get to this Friday and did not have time to get to it.


We work through the vendor for updates, so I will see what version we are migrating to in the next release. Hopefully we will move beyond 7 and to 9.


Thank you for looking into this and confirming the defect. Again, I apologize for my late response.


Thanks again!

photo
1

Hi Jon,


That's fine, I understand and I will get back to you when I hear more updates on the fix version.


Please don't hesitate to reach out here again if you have any follow up questions.


Kind regards,

Simon