Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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
Highlighted
Not applicable

Re: CIA report manager - page scaling

# 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.