02-28-2023 10:20 AM - last edited on 05-24-2023 12:22 PM by JackLacava
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?
Solved! Go to Solution.
03-02-2023 09:25 PM
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
03-02-2023 09:25 PM
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
03-03-2023 06:04 AM
This worked perfectly, thank you!