Putting a CALCULATION into a report Title
57957Feb 1 2008 — edited Feb 21 2008Ok, 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.