topic Re: Modify report margins in macro in QlikView

Modify report margins in macro

Thu, 29 Sep 2011 09:20:39 GMT

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

Tue, 04 Jun 2013 12:20:09 GMT

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 — Tue, 04 Jun 2013 13:25:01 GMT

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