OpenRPT

 

Syndicate content
jwhite's picture

Dynamic queries

Posted Wed, 05/02/2012 - 12:05 by jwhite

I am trying to modify our pick list report to show quantity on hand for certain item types. I am able to get QOH to show for everything on the report however, I don't want to see QOH for manufactured items (item_type='M'). So the following query is supposed to suppress QOH until item_type='P'.

Is this type of query possible?

SELECT item_number,
uom_name,
item_descrip1,
item_descrip2,
item_type,
womatl_notes,
formatQty(womatl_qtyreq) AS qtyreq,
formatQty(womatl_qtyiss) AS qtyiss,
formatQty(noNeg(womatl_qtyper)) AS qtyper, Read more »

georgestowe's picture

Project Profit Report gone in 3.7.4?

Posted Mon, 04/09/2012 - 15:08 by georgestowe

Once in a while I printed a report from the Order Activity by Project dialog. The report was a profit statement by project.

It appears to be gone. Was it replaced by something else?

Thanks,
George

fanning's picture

OpenRPT and tablespaces

Posted Mon, 03/12/2012 - 01:07 by fanning

We are testing OpenRPT for use as an ad hoc report tool using PostrgreSQL 9.0 and several different databases. Most of the databases are in the pg_default tablespace but one is in its' own tablespace. I have tried including the tablespace name in the query definition for the report but each attempt to generate a report gets "the detail section unnamed is invalid because no query is specified".

The query is simply "select * from tablespace.table;"

Works fine in a test instance where the same table is in the pg_default tablespace. Read more »

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 ...?