Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Use of bind variables in Report Title, Subtitle, etc.

user564803Feb 19 2014

Is it possible to somehow make use of bind variables defined in a report in other sections of the report layout (Title, subtitle, etc.).

For example:

Title:  Processor Utilization for Host <:host_name_in>

Subtitle:  <:month_name_in> <:year_xxxx_in>

SQL:  select x, y, z,

             from processor_util_table

           where host = :hostname_in

              and month = :month_name_in

               and year = :year_xxx_in ;

Binds:

        hostname_in  (prompt, default val, tooltip)

        month_name_in (prompt, default val, tooltip)

        year_in (prompt, default val, tooltip)

So, essentially, the SQL/Binds behave as would be normally expected, but the value of the bind variables are also available to be used to alter other areas of the report (title, subtitle, etc.) to create customized/specific versions of a generic report.

If this is not possible, I would pose adding the capability as a feature/enhancement request.

Cheers,

Ed

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2014
Added on Feb 19 2014
0 comments
217 views