BI Publisher 12c - Interactive View - Adding a Local Time (current timezone)

Maraprik

Hey Gurus,

Can anyone tell me a way to add the local time with the timestamp on the page header any other place.

I am using interactive view and am not able to add any function ?

If i add it in the query, how should i add it to the interactive view. it requres a data table ?

Please let me know

BIP - 12.2.1.1.0 , Oracle DB 11g.

Regards

ts001

Hi,

You don't need it in SQL, BIP gave us options to add them directly.

Here are the steps:

1. Insert Text Item

2. Double click inside the text item

3. On top you will have Date & Time option. Add both of them and save it

Next time when you run the report you should see you report run time.

Maraprik

thanks, i am new to BIP. just learnng