NewApexCoder wrote:Report regions can use a PL/SQL function block to return the SQL SELECT statement used as the region source, enabling reports with dynamic data sources/projections/predicates to be created.
Is it possible to generate a report region using a pl/sql block?
As I am writing/testing out my pl/sql, my select statements aren't producing any columns on the page to be displayed.What does this mean? What are you trying to do?
NewApexCoder wrote:Yes, that would be the recommended approach. Note that it's very important when discussing "reports" to explicitly state whether you're using standard or interactive reports. I'm assuming a standard report as they offer more possibilities for formatting and customisation.
I have a table called SCHEDULE. This a a parent table and its two child tables are TASKS and STATUS. A schedule can have many tasks and many statuses. There can also be a scenario where schedule A has many or one task and/or many or one status and schedule B can have the same. I need to pull the information for each schedule in a report.
I may be able to accomplish this with a few joins and some grouping clauses as opposed to a pl/sql block. On the report I want the information to be separated (page break'ed) to distinguish from schedules. I'm still learning APEX and I recall functionailty to put a break in between rows/records to separate information
Does this seem feasable?