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.
