We want to integrate BIRT reports more closely with OFBiz. Our BIRT design templates use standard SQL to generate the reports. We would like to use the OFBiz entity engine to generate the SQL so we can leverage our existing OFBiz application code.
For example, we would like to use a class similar to the GenericDelegator but instead of retrieving the data from a table the class would generate the SQL for the report. We would pass in entity names and conditions as we do with the Delegator and this new class would generate the SQL for us. I can see some helper classes like SQLProcessor or GenericDAO that we could use to help generate the SQL but wanted to know if anyone else has done this before. Thanks in advance for your help. Brett
