Report Page Number and Time

[sahilp]

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?

[Hweeli · Accepted solution]

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]

This worked perfectly, thank you!