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
Community Manager
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