Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Modify report margins in macro

Hi all

Is there a way to set the report margins to a specific value using macros?

I tried this :

ActiveDocument.GetProperties.PrintSheetSettings.MarginHeader = 1

or this :

'get report ID

int i = ActiveDocument.GetDocReportInfo.Count

set rep_ID = ActiveDocument.GetDocReportInfo.Item(i).Id

'change printing properties

set printS = rep_ID.GetProperties.PrintSettings

printS.MarginBottom = 2

None work...

Any idea?

Thank you in advance

Hubert

2 Replies
Not applicable
Author

Hi friend any one can help me

how to change the sheet size i.e10%,20%,30%.......100%

by taking that in list box or using button

Anonymous
Not applicable
Author

Does this zooming functionalty help, taken from the API refernce manual ?

set mysheet=ActiveDocument.ActiveSheet

set sp=mysheet.GetProperties

sp.ZoomFactor = 0.9

mysheet.SetProperties sp

I realise it is for the window and not a report, but perhaps the report is influenced by the sheet size.

Jonathan