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.