OpenRPT

 

Syndicate content
jeff_bangquil's picture

Username in Sales Invoice

Posted Fri, 01/13/2012 - 23:05 by jeff_bangquil

I have been editing Sales Invoice and wanted to put User Name who printed the Invoice on the Form.
I could not see columns for userid or user name in invchead. Is there other tables where I could get username for the Invoice Printing?

Or is there a way I could get current user accessing a certain record?

vikinglief's picture

OpenRPT integration / API help

Posted Mon, 01/09/2012 - 18:46 by vikinglief

So I'm working for a small start-up and we want to add reporting functionality to our product. I'm looking at OpenRPT, and so far I like what I'm seeing. I like the feature set for the reports themselves, the stand-alone editor seems to have good functionality, the XML report generation is a plus, and the fact that is it built using Qt4 & PostgreSQL is nice because that is what our product is using as well. Add to all of that is the fact that OpenRPT is licensed under the Lesser GPL, and it sounds like a match made in heaven. Read more »

garcut's picture

Alignment problem

Posted Mon, 12/05/2011 - 10:57 by garcut

When printing a financial report, The first column containing the GL numbers and descriptions randomly prints each line with anything from a middle alignment to a bottom alignment seemly randomly. All of the other columns print fine with a bottom alignment only. If anyone has any ideas on what might cause this I would appreciate the help.

dgirardi's picture

Unexpected behavior of group sectioning with UNION queries

Posted Tue, 11/22/2011 - 12:56 by dgirardi

If I use a query of this type:

(SELECT col1 AS id_item, col2 AS id_group FROM table1)
UNION
(SELECT col1 AS id_item, col2 AS id_group FROM table2)

defining a group based on id_group makes openrpt render only the first group. When the value in id_group changes, instead of generating a new group footer and group header section, the report just ends.

If, in the database, I create a new view using the exact same query as above, I can use that view and grouping works as expected, with header/footer generated every time the value in id_group changes. Read more »

localizame's picture

Half Letter Sized Report

Posted Thu, 11/17/2011 - 17:25 by localizame

Hi. I'm trying to design an Invoice report to print on a half letter sized paper. When I change Document->Page Setup->Paper Size to Custom and Width 8.50 and Height 5.50 the UI displays the paper size fine. If I do a print preview everything is messed up. I get a little paper box and all my labels and fields display outside. Please see attached pictures.

I need help printing half size letter reports. Please help!!

idiallo's picture

Improvement of section handling for items

Posted Fri, 10/21/2011 - 10:39 by idiallo

Hello,

As is it, the handling of the sections of the document editor is fine as long as all the items are positionned in the area representing the section. But, if some items are outside their section (after moving them with the Shift modifier), or are touching the border of a section, it's very difficult to assess wich section the items belongs to, and it can be tricky to put items in the correct section. For some complex documents, it can be a real pain.

I've created issue #16022 with the following improvements: Read more »

idiallo's picture

Empty sections

Posted Tue, 09/27/2011 - 08:24 by idiallo

Hello,

When a section is empty (i.e. its source query does not find any record), its header/footer is still printed, and one instance of the detail section is also printed. For documents containing only one section that behavior is not really a problem, as the section should not be empty anyway, but when the document contains several sections, some may be empty, and then you'll get empty space and irrevelant informations printed.
It's easy to fix if it's classified as a bug, but i'm wondering if the current behavior could be useful in some cases ...?

ppmuetze's picture

Printing W/O Traveler

Posted Fri, 08/12/2011 - 13:13 by ppmuetze

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

Posted Thu, 07/14/2011 - 10:35 by jmwork

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

Thanks

idiallo's picture

2D barcodes

Posted Tue, 07/05/2011 - 05:48 by idiallo

Hello,

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 ?