Syndicate content
nclaytor's picture

Print PDF document stored in database?

I've used xTuple's "Documents" tab to store some PDFs in the database, and would like to print them. For instance, I have stored some drawings that contain production information, which I would like to print along with the Routing report.

How do I print a PDF image within OpenRPT? Using an image field and querying for url.url_stream, which seems (according to the pgAdmin display) to contain '%PDF-1.3' and then a bunch of octal characters, gives the error "Invalid image data."

RLilavois's picture

SQLite and MySQL connections

When using SQLite I get : The following error was encountered retrieving available schemas: Unable to execute statement no such table: pg_namespace

When using MySQL via ODBC I get : The following error was encountered retrieving available schemas: QODBC3: Unable to execute statement [MySQL][ODBC 5.1 Driver][mysqld-5.1.41-community]Table 'mysql.pg_namespace' doesn't exist

How can I get OpenRpt to work with other databases?

jhogan's picture

Can I make a dotted/dashed line in Open RPT


I was updating/modifying my reports over the weekend, and thought of using dashed or dotted lines in my reports.

I know that lines can be made. But, in the addition of a line, is there a way to change the line to a dashed or dotted line?



fromhill's picture



I am trying to create a report within OpenRPT and can connect to the database.
On saving the report to the database I get the attached error message : ERROR relation 'report' does not exist.

Could someone give me a hint on how to fix this.

Thank you for your help.


idiallo's picture

Images resolution in PDF documents - issue 10558


The fix for issue 10558 has resolved the problem of the size of the pdf files by reducing resolution from 1200 dpi to 72 dpi. As noted in the issue tracker, there's no differences in text output, but for some images 72 dpi is ok for screen display but too coarse for print. After some testing i've come to the conclusion that a resolution between 150 and 300 dpi is a better compromise for image quality vs file size. Anyone with me on this ?

joseprl89's picture

setNumCopies becomes useless in Qt4.7

In the latest release of Qt (4.7), the function used in the version 3.2.0 to set the number of copies passed by the run-time switch -numCopies= in the function print of the class renderWindow, becomes void, so setting a number of copies just prints one copy.

In the Qt Documentation I've founded the following lines:

void QPrinter::setNumCopies ( int numCopies )
Sets the number of copies to be printed to numCopies.
The printer driver reads this setting and prints the specified number of copies.
Use setCopyCount() instead.
See also numCopies().
joseprl89's picture

rptrender run-time switch to print without prompting any window.

My intention is to add to rptrender a new run-time switch in order to print a report automatically without prompting any window, so the user doesn't needs to specify a printer. Read more »

jwhite's picture

Not clause?

I am trying to create a custom report that will basically take a pick list and only display certain item class codes. I am able to run the report and pull one set of class codes, but every time I try to add another code into the WHERE clause, I get zero results. I initially tried to produce a where clause that said display all items where item_classcode_id did not equal X. I'm stuck now.

Any ideas?

modelalarm's picture

Problem in Quote print - show multiple charateristics


I have a problem with the default design of Quote report. I have multiple charateristics linked to a item, but in that report only one is showed, the last i've created. I need to show all the item charateristics with the related value, as in invoice report.