Syndicate content
fongch's picture

How to Add Labels Paper Size

Labels use a Paper Size type of "Labels." The following pre-defined Label Types are supported:
Avery 5263
Avery 5264
Avery 8460
CILS ALPI-9200-1

Ho to add other Labels Paper Size ?
Example like Avery 9170

xikar's picture

Dynamicly load images from urls

Is it possible to dynamically load an image from a URL in a query?

OpenRPT can load images that are stored in the database with a query. I can also load "Static Images", but the image file data appears to be saved in the report's XML file which is ultimately stored in the database.

I would like avoid saving image data in my database do to the size of all my image files. Is there any way to have OpenRPT pull an image's data from a URL when the report prints? Maybe Postgres can pull the image data from the URL in the back end on the server? Read more »

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 »