|
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" )
Also there is one column in the report where I need to do some data manipulations(it is not simple display of view-entity filed).
Thank you for the help in advance.
Su-
|