PDF export of Report not splitting data

Rohan Hazarika shared this question 2 months ago
Answered

I have a created a report. When i am trying to export the report as PDF, i am observing the following:

1. When my date range is ~15 days, it fits the whole report into a single page (correct and desired behaviour)

2. When my date range is ~3-4months, its splitting the data across multiple pages (correct and desired behaviour)

3. When my data set is ~1month, the whole data does not fit into the first page (because of title and other header images), YF PDF export is creating a PDF with my first page just having the title and header images, and the whole data in the second page. So basically in my PDF export of the report, the first page just contains the title and header image, and the rest is blank. And then my second page contains the data. (Not desired behaviour)


How can i make YF split the data similar to situation 2.

Comments (10)

photo
1

Hi Rohan,


Thanks for your question.


Are you able to send through your /info.jsp page? PDF Exports in version 9 now depend on which version of Java you are using, so you may be able to get better functionality by changing your version of Java so that it includes Java FX.


Kind regards,

Simon

photo
1

Hey Simon

Yellowfin is embedded into our product and as such info.jsp comes up with nothing. Attaching a few screenshots with some system properties. Let me know if that helps or if you'd want some more details.

/e8626f161ab47fc273678427bd7980db


/2330b5d980efbeaec083454db6d872de

photo
1

Also, is it recommended to have JAVA FX installed?

photo
1

Hi Rohan,


Thanks for sending that through to me. It seems as if you are using Java FX based on the jdk I can see in your screenshot, however, there are additional environmental variables that should appear a little lower that I can't see. If you Ctrl + F and look for "javafx" and something shows up on that System Information page then you should be using Java FX. You can also confirm this by attempting to Export a Dashboard as a PDF.


There have been some additional options that have been added as part of the PDF Export process in 9.5 and 9.6, where I would suggest adding Java FX to your environment if you haven't already. Using Java FX allowed our Developers more flexibility with the PDF Export functionality, where the previous iteration that is used when Java FX isn't installed is limited. The options that may help in your case are specifying where the page breaks occur, after Report Sections and/or after Co-Displayed Reports.


Essentially if Java FX is not installed, you are using the V1 Exporter, and if it is installed you are using the V2 Exporter.


/fae31e8212f2952db52d582bce70ecf1


Let me know if you have any further questions.


Kind regards,

Simon

photo
1

Hi Rohan,


I hope you're doing well.


I just wanted to check in to see how you are traveling with this issue, and if you require further assistance. Please feel free to respond here if you have any further questions or information and I will get back to you shortly.


Otherwise, I will shortly go ahead and mark this ticket as closed.


Kind regards,

Simon

photo
1

Hi Rohan,


I hope you're well.


I'm just messaging to let you know that I will be marking this question as closed.


Feel free to re-open this ticket if you have any further queries.


Kind regards,

Simon

photo
1

Hi Simon

The JAVA didnt really give us any additional options for the PDF export. And we are still facing the same issue. Let me reiterate my issue again and maybe you can help me find a solution for it.

Consider that i have a report with some header title and images at the top, which is taking up 1/4 of the page. Now i have a table below it with my data. When opening up the report in YF, it looks good. However, when im exporting the report as a PDF, my first page only contains the header and title, and the table is in the second page.

I am guessing this is because YF figures that it cant fit the whole table in the first page and can fit it in the second page. Is there a way where i can force YF to split the table across 2 pages. As you can imagine, the PDF report does not look very professional with only the header/title in the first page (with 3/4 of it being blank) and then having the table in the second page.

photo
1

Hi Rohan,


  • Which version of Java are you using? (You can find this in the /info.jsp page)
  • Which version of Yellowfin are you on?
  • Are you able to send me a screenshot of your PDF export options?


Kind regards,

Simon

photo
1

Hi Rohan,


I hope you're well.


I just wanted to check in with you, to understand in your most recent example which versions of Yellowfin and Java you were using. If you could also send through your PDF Export options that would be appreciated.


I'm a little unclear if you have changed your Java version since your initial messages and if you've tried changing the page break settings.


Otherwise, let me know if this is no longer an issue and I will go ahead and mark this as closed.


Kind regards,

Simon

photo
1

Hi Rohan,


I'm just messaging to let you know that I will be marking this as closed for the moment, due to inactivity.


Feel free to re-open this ticket at a later date if you have any further questions or information.


Kind regards,

Simon