So I am experimenting with the Document Designer tool in InfoAssist. I notice that when I go to insert an existing report from the BI repository, it will not see the reports that I created directly with FOCUS code. It only sees the reports created within IA. I would like to be able to insert some reports that I created directly with FOCUS. Does anyone have any ideas about this?

This message has been edited. Last edited by: FP Mod Chuck,

I’m pretty sure there’s no way around that requirement. I don’t even think you can insert a report you created in App Studio.

Thanks BabakNYC for your reply.

Yeah looks like you can't. However, if I created the document in AppStudio, I can obviously see the reports I created directly in the code.

So I am trying to created specifically a PPTX document with AppStudio with those those reports I created directly in the code. So I get the following errors below after inserting and running. I changed the output format for it to a PDF and have removed the HEADALIGN=BODY but still same results.

0 NUMBER OF RECORDS IN TABLE= 10 LINES= 1
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 1
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 2
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 3
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 4
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 5
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 6
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 7
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 8
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 9
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 10
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 11
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 12
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 13
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 14
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 15
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 16
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 17
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 18
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 19
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 20
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 21
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 22
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 23
(FOC3210) COLUMN TRUNCATED BECAUSE WIDTH EXCEEDS MARGINS; COLUMN: 24
(FOC3395) Paneling is not supported in a compound report component.
1
0 NUMBER OF RECORDS IN TABLE= 2106 LINES= 1
(FOC3296) Error found in Coordinated Compound Report: At Component report1
Compound Report is TERMINATING.....

Any suggestions on this?

Start debugging by removing all but one report column.

Try setting Squeeze:

SET SQUEEZE=ON

quote:

The SQUEEZE parameter ... determines the column width in report output. The column width is based on the size of the data value or column title, or on the field format defined in the Master File.

The syntax is:

SET SQUEEZE = {ON|OFF|n}

where:

ON - Assigns column widths based on the widest data value or widest column title, whichever is longer.

OFF - Assigns column widths based on the field format specified in the Master File. This value pads the column width to the length of the column title or field format descriptions, whichever is greater. OFF is the default value.

n - Represents a specific numeric value, based on the UNITS parameter setting, to which the column width can be set (valid only in PDF and PS).

Also, look into WRAP:

TYPE=REPORT, COLUMN=column, WRAP=n,
 $

Thanks Francis for your reply. However, I am already using SET SQUEEZE=ON and WRAP in the styling. The report runs fine standalone. However, it's when I run it within the document I'm trying to test as a PPTX output in Document Composer in AppStudio is when I get the errors I posted earlier.

Make sure you've allowed enough space in your compound document element for your report. If your report is say 10 inches, and you've only allowed 8 inches, your element won't auto grow. it will just throw an error like what you see.

Thanks Eric. Where specifically should I set the spacing within the Document Composer for that?

AMC

I think Eric is saying to make each container spaced appropriately within the document.