Skip to Main Content

Analytics Software

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!

Putting a CALCULATION into a report Title

57957Feb 1 2008 — edited Feb 21 2008
Ok, I have gone round and round with trying to encorporate the Database name into the title of a report. I have registered a function SYS owned in the database to return a database name and I have also created a custom folder that contians many different calls to SYS_CONTEXT. Either direction I have gone poses its own unique challenges but what I have determined is a calculation cannot be placed in the Title of a Discoverer Report unless it is turned into a parameter. Parameters can be placed in the title of a report and displayed. Am I going about this the correct way? Is there an easier way to do this. I had another developer look this information up and did not succeed with what he was told to get the SID into the report title. Love to hear some feed back. I am thinking to myself I can leverage the Folder I built and a parameter created in order to get this magic to happen but I am unsure yet if I can create a join between two folders without specifying a where clause.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2008
Added on Feb 1 2008
5 comments
798 views