Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
is there is a way to dynamically change the resolution of a report based on the detected monitor
Try,
Document>> View>> Fit Zoom To Window..
Are you asking about Reports or Graphs?
graphs and reports.
As the resolution change, graphs will change or reports too,
i need to keep it constant
Hi,
You need to have buttons to "fit to screen" as well as "default view"
Then in the macro have the following VB Script code.
To Zoom
start of code
ActiveDocument.ActiveSheet.FitZoomToWindow
ActiveDocument.GetApplication.WaitforIdle
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets
end of code
To unzoom
start of code
set mysheet=ActiveDocument.ActiveSheet
set x=mysheet.GetProperties
x.zoomFactor=1
mysheet.setProperties x
ActiveDocument.GetApplication.WaitforIdle
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets
end of code
thanks,
Rajesh Vaswani
Reports are for printing, I´m assuming you´re writing about Tables (Straight and Pivot Tables).
Rajesh Vaswani gave a nice solution assuming you´re using Developer or Internet Explorer plugin.
For use into webview, search for a document extension (there´s one) that change sizes of objects to fit into the screen