Hi, I am trying to use App Studio 8.2.0.1 to generate a report in the way Oracle PL/SQL does. I know that it is very easy to get this done using an Oracle PL/SQL procedure on database side. We have a justification to do this report with App Studio.

We have the following three separate SQL queries:

SQL query 1 will get a start date 04/01/2018
SQL query 2 will get an end date 07/31/2018
SQL query 3 will get credit days for each month from start date to end date

We want to generate the following report with App Studio.

Month Credit Days Projected End Date

April 5 07/26/2018 --(07/31/2018-5)
May 20 07/06/2018 --(07/26/2018-20)
June 20 06/16/2018 --(07/16/2018-20)
July 20 --(No need to list as no credit days after the projected end date)

This message has been edited. Last edited by: FP Mod Chuck,

I've never tried it but I think you'll need to use SQL Passthru for the first two. Please update when you find the technique. I'd like to see how you crack this.

https://webfocusinfocenter.inf...source/oracle378.htm

Hi CD

Welcome to Focal Point, it is a great place to get answers to your development questions.

This appears to be a report with multiple date ranges in the result set. If so this would be a iterative process based on how many time periods you want to report against. Maybe if you posted the existing SQL we could see how it is done today and recommend a way for WebFOCUS to simulate.