Project

General

Profile

Forums » Open discussion »

Exporting issues to PDF in portrait mode

Added by Domhnall Currie 5 months ago

Gentlemen,
For several years now, off and on as I've had time, I've tried to modify my Redmine installation to export my issues list to a PDF file in LETTER size portrait mode. The only thing I need on there is the issue Subject field. I also need the indentations of the sub-task structure observed and not everything left justified as with the current output so I can tell what task I'm looking at. I've tried modifying .rb files, .erb files, .yml files, you name it and the only way I can make it change from A4 landscape mode is taking away some of the calculated settings and sticking actual values in there. This of course mangles the output and does not produce the desired result. :) I'm not a programmer, but if I at least knew where to look or given a starting point, I could figure out what to change to make it work. I guess I can either change the actual code, or I can learn how to write a plugin to produce the desired results.

The other method I'm considering is to just use SQL to produce a report from the production database, or export to .CSV and produce the report offline. The two methods I've seen mentioned online to handle parent child relationships is a recursive CTE or somehow using a foreign key. The problem I have there is I'm not a SQL programmer either, so folks mention these things that are simple to someone familiar with the process, but not enough details for an ignorant person such as myself to wrap my head around it yet.

I managed to get OpenProject modified for the desired results, but they don't use RBPDF and I could not reproduce those efforts in Redmine. If I've got to learn SQL, Ruby, Python or whatever to get it done, that's what I'll do, but it's hard to just say I'm going to learn a programming language, open a book and figure out what to change to modify a Redmine report. :) A single issue exported to a PDF file produces portrait output, but it's still in A4 which my printer can't handle, so maybe that's where I'll look next to see if I can make the settings of the issues list export more closely match up with a single issue export.

Attached are files showing current issues list output and output I desire. I just modified the PDF file in LO Draw, so..... :) If someone could just point me in the right direction, I would very much appreciate it. Thanks!

Pat

Download all files
current-issue-list.pdf (31.9 KB) current-issue-list.pdf Current issues list pdf output
desired-issues-list.pdf (33.8 KB) desired-issues-list.pdf Issues list pdf output I would like to see
single issue.pdf (154 KB) single issue.pdf Output of single issue

Replies (1)

RE: Exporting issues to PDF in portrait mode - Added by Domhnall Currie 5 months ago

Also.....
I've tried modifying my report to make it as narrow as possible not to jump over the maximum report width to trigger landscape mode. I think the subject field is 255 characters, so I made a report with just status_id which is only 11 characters wide, but it does the same thing. It spreads the ID field and the other field out to the maximum width of the page, but leaves it at A4 landscape mode. :( Nothing I do gets it to properly output the report in portrait mode, but looking at the code makes me think it's written so as to change back and forth between P and L based on the width of the report output.

    (1-1/1)