Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

CIA report manager - page scaling

I'm using CIA report manager add on and have scripted 3 tables to be sent out to a pdf report.  I would like the report output to 'scale to fit to one page' as I would if I tried printing this from excel.  How can I do that in the script editor?  I'm failry new to this - is there any online help for this anywhere?

Thank you.

1 Reply
Not applicable
Author

# The following is code I used in CIA Report Manager. This is some basic script.

DEFINE DeptName AS STRING

WB.OPEN("Templates", "Template_Report.xlsx")

# Opens the template stored in a Templates directory

Use a WS = WB.Findsheet("Sheet 1")

# Selects the sheet in the workbook

SELECT = WS.SELECT(1,1,1,1)

# Sets the content at the position defined in pixels

SELECT.SETCONTENT(DeptName)

# Applies the exported content such as images, tables, text, etc.