Skip to main content
Newcomer
February 28, 2023
Solved

Report Page Number and Time

  • February 28, 2023
  • 1 reply
  • 0 views

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?

Best answer by Hweeli

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

1 reply

HweeliOneStream EmployeeAnswer
OneStream Employee
March 3, 2023

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
Newcomer
March 3, 2023

This worked perfectly, thank you!