Forum Discussion

sahilp's avatar
sahilp
New Contributor II
3 years ago
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?
Reports
  • Hweeli's avatar
    Hweeli
    3 years ago

    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

Hweeli's avatar
Hweeli
Icon for OneStream Employee rankOneStream Employee
3 years ago

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

  • sahilp's avatar
    sahilp
    New Contributor II
    3 years ago

    This worked perfectly, thank you!