The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

nidhi's avatar
nidhi
New Contributor II
2 years ago

How to adjust report margins using Cube view extender rule.

Hello, We are having this below requirement, where we trying to achieve this using Cube View extender rules. Rule should vary margin depending if it's landscape or portrait. If Landscape, the...
Cube View
Reports
JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years ago

You might need to experiment a bit, to find the right threshold for you, but this approach might work:

 

Case Is = CVExtenderFunctionType.GetReportOptions

	Dim reportOptions As New CVExtenderReportOptions()
	If args.Report.PageWidthMinusMargins > 1600 Then  	'Landscape
		' set whichever option
		reportOptions.ReportMarginTop = -1.0
	Else	                                                ' portrait
		' set whichever option
		reportOptions.ReportMarginTop = 1
	End If
	Return reportOptions