Databases Reference
In-Depth Information
15.
Drag and drop
P210_PUBLIC_FLAG
in the Page Rendering tree so it's under
P210_STATUS_ID
, similar to Figure
8-44
. This is strictly for ease of reading and usability.
Figure 8-44.
Layout modification for easier usability
Now that you have a
PUBLIC_FLAG
column in your data model and the ability to control it through the Tickets form,
you can create the dynamic SQL report on page 1 to display tickets with a Public option for unauthenticated users:
1.
Edit
Page 1
in your application.
2.
Create a new region by clicking the
Create
button and selecting
Region on this page
, as
indicated in Figure
8-45
.
Figure 8-45.
Creating a region for the SQL to generate your report
3.
Select
Report
, and click
Next
.
4.
Select
Classic Report
, and click
Next
.
Enter
Current Open Issues
for
Title
, as shown in Figure
8-46
. Click
Next
.
5.