Categories
- All Categories
- 127 Oracle Analytics News
- 23 Oracle Analytics Videos
- 14.5K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
Date with time data changes after exporting to Excel from BI publisher report - using NON RTF method

Summary
Time data changes after exporting to Excel from BI publisher report - not used rtf template
Content
Hello everyone,
i have date data format in the database as 07-OCT-19 12.22.29.994000000 PM. (oracle database).
created datamodel and report based on above date field. properties set like
formating mask: MM/dd/yyyy hh:mm:ss tt
formatting style: Microsoft
ignore user timezone: True.
once i set above properties, in the report editor the date value displaying correctly as 10/07/2019 12:22:29 PM
Whereas once i generate the report and view in the excel output its displaying time as 10/07/2019 06:22:29 PM
why this time is changing? how to avoid this issue? please help me on this really appreciate it.
P.S. i am not using rtf template method design. in 11g getting properly values wheras in 12c getting issue.
Regards,
Joe
Answers
-
please any help on this? any workaround for temporary?
Regards,
Joe
0 -
Hi All, Any help on this request? thanks in advance.
0 -
Hi Srekan.
Looks like you didn't get any reply on this.
It is a RTF template you are working with?
Have a look at the following options.
Cheers
Fernando
0 -
Hi,
I am not using RTF method. BI publisher interactive mode.
Regards,
0 -
Hello All,
i have created BI publisher report, when i am looking report in interactive mode, it is displaying only 10 records initially, if i need more records to navigate, i have to click right side scrolling button. is there any way where i can display more than 10 records default in interactive mode.
Regards,
Joe
0 -
Hi Srekan.
Yes, there is.
Navigate to your Report Template, click on the table that contains your data and on the Table tab options change the value on "Rows to Display" (see image).
If you are using a PivotTable, I don't think that is possible.
Cheers
Fernando
0