Any PrintFormat Jasper Report out there?

414 views
Skip to first unread message

redhuan d. oon

unread,
Apr 17, 2015, 3:44:52 AM4/17/15
to idem...@googlegroups.com
Besides http://wiki.idempiere.org/en/Plugin:_JasperReports, where there is a specific Customer/Vendor statement jasper report, are there others, that can replace standard document type print format such as Sales Order and Invoice? I have found how to guides but not a finished Sales Order for example.

HansAnton Riess

unread,
Apr 17, 2015, 1:12:23 PM4/17/15
to idem...@googlegroups.com
Hi Red1,

Part of our Implementation was the creation of reports/labels for the following business processes, here are some examples:

- purchase order
- nonbinding offer (with BOM)
- customer invoice (original/duplicate)
- price list
- bank statement
- material receipt label
- payment reconsiliation
- credit memo
- price historie with graphic
- ...

They worked with Adempiere 370, at the moment they will be migrated to Idempiere 2.1

Unfortunately they are all in german language, so I think they cannot be used for generic purposes.

Like themes, different Report Layouts from the community could provide ideas for own reports.

Another example would be the integration of 2D barcodes or graphic images from db fields...

Regards

Hans



Carlos Antonio Ruiz Gomez

unread,
Apr 17, 2015, 1:33:03 PM4/17/15
to idem...@googlegroups.com
@Hans, there is an easy way to make jasper reports multi-language, I
posted an english/spanish example here:
https://groups.google.com/d/msg/idempiere/x_cVoInY_ec/ONjFDNeAjfAJ
So maybe if you share the jasper reports you mention somebody can make
them multi-language

@Redhuan, I saw some formats at
https://idempiere.atlassian.net/browse/IDEMPIERE-302

Regards,

Carlos Ruiz

redhuan d. oon

unread,
Apr 17, 2015, 1:57:42 PM4/17/15
to idem...@googlegroups.com
Hans,
In general, such renditions are still priceless such as this one done by our leading member in Thailand http://www.adempiere.com/Using_Jasper_Report_Form_in_place_of_Standard_Forms.
So please share what you can as I am exactly working with German speaking community supporter here in Austria and he appreciates help with any samples.

redhuan d. oon

unread,
Apr 17, 2015, 2:05:51 PM4/17/15
to idem...@googlegroups.com
Thanks Carlos, for repeating the links i missed. Multi lingual standard jaspers is the way i am looking at too.

HansAnton Riess

unread,
Apr 18, 2015, 6:56:15 AM4/18/15
to idem...@googlegroups.com
I try to add them to the german wiki page, if you like ...

redhuan d. oon

unread,
Apr 18, 2015, 10:14:15 AM4/18/15
to idem...@googlegroups.com
Gut idea! :)

HansAnton Riess

unread,
Apr 19, 2015, 1:38:26 PM4/19/15
to idem...@googlegroups.com
Pleaese try the following link: 

redhuan d. oon

unread,
Apr 19, 2015, 3:51:03 PM4/19/15
to idem...@googlegroups.com

Danke!
Meanwhile i solved and found out some vital rules to make a PrintFormat > JasperReport to work:
1. $P{BASE_PATH} has to be used to pass to SubReport which will be $P{BASE_PATH}+"SubReport"
Will document a guide once i get Carlos Ruiz's multi lingual feature to work on this.

redhuan d. oon

unread,
Apr 19, 2015, 5:30:47 PM4/19/15
to idem...@googlegroups.com

Where is the guy who complained that this ERP is not sexy? Jasper Report can do alot such as graphs and pulling online pics.

Carlos, before i try your multi lingual template, I noticed that code could be injected into the JRXML:
+ org.compiere.util.Msg.getAmtInWords(org.compiere.util.Language.getLoginLanguage(), java.lang.String.format("%-3.2f", [$F{grandtotal}] as Object[]))
+ ")"]]></textFieldExpression>

Would this mean it can also do this: msg.translate("words") ?

redhuan d. oon

unread,
Apr 19, 2015, 5:55:19 PM4/19/15
to idem...@googlegroups.com

Carlos Ruiz, this is more than sexy. It is a quantum leap in global localization!
Message has been deleted

Hiep Lq

unread,
Apr 19, 2015, 9:53:42 PM4/19/15
to idem...@googlegroups.com
Hi Mr Red1.
some my idea.
+ what's BASE_PATH? you also use SUBREPORT_DIR
SUBREPORT_DIR = [reportPath] + File.separator

+ org.compiere.util.Language.getLoginLanguage()
you can use CURRENT_LANG or REPORT_LOCALE

+ msg.translate("words"). yes, you can use it.

+ when you call adempiere function. maybe hard to test in jasper design.
i use a fake project to mock up idempiere function.

redhuan d. oon

unread,
Apr 20, 2015, 4:14:42 AM4/20/15
to idem...@googlegroups.com
But Hiep, this one has almost no effort: http://wiki.idempiere.org/en/Multi-Lingual_Jasper

Hiep Lq

unread,
Apr 20, 2015, 5:01:17 AM4/20/15
to Mohemmed Bilal Ilyas
Hi Red. 
what i mean about mock up if you use msg.translate.
use "properties" file is ok but it's for static text.



--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
 To view this discussion on the web visit https://groups.google.com/d/msgid/idempiere/ca04f4d6-19d9-4d10-b058-302c648611f0%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



--
Lê Quý Hiệp
Email: hie...@hasuvimex.vn
Skype: admin.hasuvimex
Mobile: 0915277401

Company: Thanh Hoa Fishery Import - Export J.s.c  (Hasuvimex) DL 47
Add: Lot E, Le Mon Industrial Zone, Thanh Hoa, Vietnam
Reply all
Reply to author
Forward
0 new messages