Best Method to create Report

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
su2
Reply | Threaded
Open this post in threaded view
|

Best Method to create Report

su2
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-