You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by su2 <sh...@pexsupply.com> on 2009/09/24 22:09:12 UTC
Best Method to create Report
Hello Friends,
I am trying to create a Tax report by county. Which has a FormDate and
ToDate.
I created 2 view-entites(View-Entity A and View-Entity B) which has all my
required fields for display as well as for the WHERE conditions.
I am confuse which is the best method to approach for this report. Since my
SQL query is little complex.
SELECT A.*, B.* FROM tableA A, tableB OUTER JOIN B ON A.FieldAId =
B.FieldBId WHERE A.FieldType = "SHIPPING_LOCATION" AND (A.FieldStatus =
"ORDER_COMPLETED" OR A.FieldStatus = "ORDER_APPROVED" )
Thank you for the help in advance.
Su-
--
View this message in context: http://www.nabble.com/Best-Method-to-create-Report-tp25583580p25583580.html
Sent from the OFBiz - User mailing list archive at Nabble.com.