7/15 I have created sql in the workbench to extract project task details from several projects inside of a large program. The extract is based on a custom user field in the task record that identifies it as a task or milestone of Program significance (it is the associated Program ID). This flag is set based on Program Management direction as significant due to inter-project dependencies, critical path\\task status or high Earned Value precedence. I now want to be able to simply display the selected tasks based on simple field parameter filters like: Program Number (from the custom field), Task Start Date, Task Status, CPI, SPI, EV. Im unfamiliar with creating a portlet using sql (can't figure out how to start it). It would work great as a portlet, I just don't see any access to project tasks (should be a standard portlet anyway), or adding a button to a portlet that would execute the sql. I am investigating web services, special commands, and modules, but don't see a clear path. Any help greatly appreciated. Program Management functions very weak for outsourced, complicated and highly interfaced programs. We really need a new type of Task for "Deliverables Status Reporting". Thanks. 7/21 OK, I built the Data Source, have accessed all the data, built the Portlet and now need to know how to format the date (timestamped with seconds) and dollar values (displayed x 10000, no decimail points). I went to bookstore to get sql reference, and now can't figure out which brand of sql is this application set using. I can't find where it is identified in any of the HP Documents? Any help greatly appreciated. Everything I read says formatting should be handled by the application, not the sql, so what am I missing in the Portlet definition, as I don't see any formatting properties.'