Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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