Jump to content
Changes to the Jaspersoft community edition download ×

OpenbravoERP Reports


abungas

Recommended Posts

Good Day,,

 

Any body can help me about OpenbravoERP reports on How to Edit?

I use OpenbravoERP 2.40 and i.report 2.02

I already know where and what to edit the problems is when i try to Ad the Query their is Always and Error....

(Error:SQL Problems:ERROR: Syntax error at near ",")

This Are the Query statement

SELECT
     C_ORDER."C_ORDER_ID",
     C_ORDER."DATEORDERED",
     C_ORDER."DOCUMENTNO",
     C_ORDER."DATEPROMISED",<----------------------------------this is i add the other are the original Query statement
     C_BPARTNER."NAME",
     C_BPARTNER_LOCATION."FAX",
     C_BPARTNER_LOCATION."PHONE",
     REPLACE(C_ORDER.DESCRIPTION,CHR(10),'')AS DESCRIPTION,
     REPLACE(C_ORDER.DELIVERYNOTES,CHR(10),'')AS DELIVERYNOTES,
     AD_CLIENT."DESCRIPTION" AS ENTITY,
     C_LOCATION_DESCRIPTION(AD_ORGINFO.C_LOCATION_ID)AS LOCATION,
     FREIGHTCOSTRULE.NAME AS DELIVERYEXPENSE,
     DELIVERYRULE.NAME AS DELIVERYTERM,
     C_CURRENCY."ISO_CODE",
     PAYMENTTERM.TERM AS PAYMENTTERM,
     VALUE,
     NAME
FROM
     "C_ORDER" C_ORDER INNER JOIN "C_ORDER" C_BPARTNER_LOCATION ON C_ORDER."BILLTO_ID" = C_BPARTNER_LOCATION."C_BPARTNER_ID",
     "C_BPARTNER" C_BPARTNER,
     "AD_ORGINFO" AD_ORGINFO,
     "AD_CLIENT" AD_CLIENT,
     "C_CURRENCY" C_CURRENCY,
     "(" (,
     "AD_REF_LIST_V" AD_REF_LIST_V
WHERE
     AD_REFERENCE_ID = 153
 AND AD_LANGUAGE = $P{LANGUAGE}

 

 

Pls Any one can help me on how to do it Correctly PLS HELP

Your Responds highly appreciated

 

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

abungas,

 

Your FROM clause doesn't look so good. Mixing one INNER JOIN clause with a bunch of unjoined tables will be hard to use even if you get it to work. Try converting the whole thing to use JOIN clauses linking the tables.

 

Start by testing it outside of iReport. Use a tool like SQuirreL. (Any SQL tool is fine, but SQuirreL is a great free tool for testing JDBC connections.)

 

After you confirm that the SQL is OK there, then put it back into the report and test in iReport.

 

Regards,
Matt

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...