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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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