Report Page Number and Time

sahilp
New Contributor II

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?

1 ACCEPTED SOLUTION

Hweeli
Moderator
Moderator

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

View solution in original post

2 REPLIES 2

Hweeli
Moderator
Moderator

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
New Contributor II

This worked perfectly, thank you!

Please sign in! sahilp