Syndicate content
ppmuetze's picture

Printing W/O Traveler

Hello xTuple fans!!

I have no idea if I am posting in the correct spot or now so here it goes....

When you print a W/O traveler the default screen that "pops" up gives me options to Release W/O and 3 Documents: options, Print Pick List, Print Packing List & Print Work Order Label.

My problem is that I have to open the windows twice because I Print the Pick List to a regular printer & then I print the Work Order Label to a label printer. Read more »

jmwork's picture

OpenRPT for Linux

Where do I find the download for the Linux version of OpenRpt?


idiallo's picture

2D barcodes


I'll probably have to implement the printing of 2D (Datamatrix) barcodes in documents, or at least evaluate the amount of work necessary to implement it. Does anyone has the same need ?
After a quick search, i've found the libdmtx library, but it's complex and a big dependency. That kind of library could be integrated with a copy/paste (i.e. a fork) of the useful parts of its code, or as an external dependency. Any opinions on that ?

bclay's picture

OpenRpt doesn't seem to work using views and joins

I have been trying to build reports to get ready for our county fair and having lots of problems. I did finally get one basic report to work but when I try to simplify the process by using Views the same query resulted in the first row being repeated many times and no other data.

Also when I used a query with multiple joins I got the same results. I tested all queries in Postgresqls pgAdmin II application first with no problems.

county fair is approaching fast with very little chance of getting the reports done through OpenRpt on my own so any thoughts would be greatly appreciated. Read more »

waynefreeman's picture

How to Print Last Group Footer of Report

Hi, how do you force the last group footer of a report to print? I'm evaluating OpenRpt and have designed a simple report with detail, one group section and report footer. I have running totals defined for the group section and report footer. Read more »

sparrow's picture

Fix my RPTRender command line parameters

The following is my command line...

rptrender.exe -databaseURL=odbc:///mr_local -noAuth -param=fromdate:string='2011-03-01' -param=orgid:int='84' -param=todate:string='2011-03-31' -pdf -outpdf=sample2.pdf -close SSSummary.xml

I am using:

openrpt 3.2.2 odbc to mysql

My single Query Source in the report is:

call getSummary(<? value("orgid")?>,<? value("fromdate")?>,<? value("todate")?>); Read more »

windtalker's picture

Edits made (saved to DB) fail to alter report

I had altered 2 reports so far, the first being the exercise in the OpenRPT guide, and, armed with that, the second being a change to a query source (detail) in the "Items by Class Code" report, so that the listing would be ordered by Item Description. Works fine. I am telling this to establish that I know how to edit and save to DB.

But I struggled till 1:00am trying to so a similar change to the "Quantities on Hand by Class Code" report, and no change I made would alter the report. Read more »

idiallo's picture

Multi-columns lists


I need to implement an extension to the lists currently existing in OpenRPT.
The goal is to print multi-columns lists width a fixed height. The first column is drawned up to the height of the list, then the second column, and so on towards the right of the page.
For instance, if the list has a height of 100 and that each line has a height of 10, a list of 23 lines will be drawned with two columns of 10 lines and a rightmost column of 3 lines.
In our case, the content of the line could be a single database field. Read more »

danielle's picture

OpenRPT, Remote Training Class - Back by Popular Demand

Join us for  this first ever xTuple remote training event focused on OpenRPT, xTuple's powerful, open source SQL report writer. OpenRPT is embedded in the xTuple GUI client (PostBooks, Standard, and Manufacturing), and is also available as a free-standing open source project of its own.

Here's who should attend: Read more »

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