Skip to main content
Feb 28, 2023 3:20 PM UTC
Solved

Report Page Number and Time

Hi everyone, do you know if the report run time and page number that is in the cube view report footer can be moved into the report header? I was thinking perhaps via a cube view inline formula?

HweeliAnswer
OneStream Employee
Mar 3, 2023 2:25 AM UTC

Yes can be move to header using Cube View Extender Business Rules:

Dim uiItem As CVExtenderReportUIItem = args.Report.CurrentUIItem
If uiItem.UIItemType = XFReportUIItemType.PageHeaderPageNumber Then
uiItem.Visible = True
uiItem.SetPageNumberDisplayInfo(True,"Page {0} of {1}")
End If

Dim myTimeZone As TimeZone = TimeZone.CurrentTimeZone
Dim local As DateTime = myTimeZone.ToLocalTime(DateTime.Now)
If uiItem.UIItemType = XFReportUIItemType.PageHeaderLabelRight4 Then
uiItem.Text = local
End If

If uiItem.UIItemType = XFReportUIItemType.PageFooterPageNumber Then
uiItem.Visible = False
Else If uiItem.UIItemType = XFReportUIItemType.PageFooterDate Then
uiItem.Visible = False
End If

2 replies

HweeliOneStream EmployeeAnswer
OneStream Employee
Mar 3, 2023 2:25 AM UTC

Yes can be move to header using Cube View Extender Business Rules:

Dim uiItem As CVExtenderReportUIItem = args.Report.CurrentUIItem
If uiItem.UIItemType = XFReportUIItemType.PageHeaderPageNumber Then
uiItem.Visible = True
uiItem.SetPageNumberDisplayInfo(True,"Page {0} of {1}")
End If

Dim myTimeZone As TimeZone = TimeZone.CurrentTimeZone
Dim local As DateTime = myTimeZone.ToLocalTime(DateTime.Now)
If uiItem.UIItemType = XFReportUIItemType.PageHeaderLabelRight4 Then
uiItem.Text = local
End If

If uiItem.UIItemType = XFReportUIItemType.PageFooterPageNumber Then
uiItem.Visible = False
Else If uiItem.UIItemType = XFReportUIItemType.PageFooterDate Then
uiItem.Visible = False
End If

sahilpAuthor
Mar 3, 2023 11:04 AM UTC

This worked perfectly, thank you!