This content has been marked as final. Show 6 replies
That all sounded promising until we were reading the comments and it says:
@Kasbanby Anton Schefferon March 23, 2011
No, there's no user manual, it's very easy to use it. Just create a new region, based on this plugin, enter a query for the region source. Done. And regarding your question about a printout of a total interactive report: I have no idea. (And it can't be done with this plugin)
We have also tried the Reports 2 PDF plugin without success.
From our understanding, it looks like we would have to create another report for each of our existing Interactive Reports, which would be a JasperReport or something.
We know there is something with the XSL-FO templates, is that what iReports can do for us? Really this is a new world for me, so I do fear that I might be asking my question wrong.
Like I said maybe we are missing something. We were able to get the FOP to work, but the problem with that is all of the columns are evenly distributed widths. On some reports, which have many columns, there could be a name column that needs to display 50 characters, but then the next field only has 5 characters. It appears that without creating an additional report or report layout for each report we cannot print the results of the interactive report.
Maybe I am completely missing something in all of this, but I find it hard to believe that we have to create multiple versions of a report just to be able to print it. If we had just wanted to create a static report, then I would have continued using Oracle Reports, like we have for the last 20yrs.
If you want to use FOP with Interactive reports, you are pretty much stuck with the default layout. What I would suggest involves developing new layouts to support PDF generation with most reports in APEX. At this time, interactive reports are not open enough to allow you to format the FOP based layouts very well..
What I have done is using 3rd party reporting tools with APEX (BI Publisher, FOP with an XSL-Style sheet editor, Crystal Reports) is define the layout and add a button the report to print to PDF...
The issue with is is, if a user has a custom version of the report (custom columns added or columns removed) the external layout will not see this..
That has been my fear, our users all want to be able to see different sets of columns, this is why the Interactive Reports were so attractive to us.
We could be happy with the HTML download option, if it was possible to have headers because we have to label the reports to say they have sensitive data.
I guess at this point unless we want to re-develop all of the reports in another tool, then we will just need to live with the CSV and HTML download options.
Thanks for your help.
I guess the outstanding question now would be is there some way to get headers to download with the HTML download option from Interactive reports?