Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Report Caster and Report Size

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Report Caster and Report Size
 Login/Join
 
Arif
Guru
posted
I have a report job running this report is PDF formate, Letter size with 17 columns when I run this report using dashboard of dev studio report shows results for allcolumns on one page. Squeze is ON. However, when I run it using report caster, report bring last two columns on the 2nd page. I am not sure if it can be controlled using some settings. Have you ever seen this problem before?

Arif


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
Tony A
Expert
posted Hide Post
Use the WIDTH and WRAP stylesheet syntax to control the column widths such that the output is controlled rather than letting WebFOCUS or RC just "do it's thing".

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Arif
Guru
posted Hide Post
Its a PDF Report so WIDTH wont work. However, I tried WRAP my report runs just fine If I run using run option from dev studio. But I am having a problem when I schedule it in Report caster. So, what I am asking here is if there is a way i can tell report caster to run as is. I think something is changing while running the caster job?

Arif


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
Arif
Guru
posted Hide Post
 -PDF
 TABLE FILE WKRVAGG6
 SUM           AMTF/fmt AS ''
             &SORT
             BY UNIT1    NOPRINT
             BY UNIT2    NOPRINT
			 ON UNIT2    SUBHEAD
             "&UNIT1_TITLE <UNIT1 &DISPBURST"
			 "&UNIT2_TITLE <UNIT2"
         ACROSS
         HIGHEST CP_DESC  AS ''
         ACROSS COLENT   NOPRINT
         ACROSS COLTITLE AS ''
             BY LITMORD NOPRINT
             BY HIGHEST LITM1  NOPRINT
			 BY HIGHEST LITM1D AS ''
			 BY L2      NOPRINT
             BY LITM2D  AS ''
             BY LITM3D  NOPRINT
			 BY LITM3   AS ''
             BY LITM2   NOPRINT
WHERE FLAG EQ 0;
WHERE COLCONCAT NE '          W';
HEADING
"Weekly Revenue & Enrollment Report"
FOOTING
"<TABPAGENO of <TABLASTPAGE"
"<+0> Run Date: &DATEMDYY"

 ON UNIT2 PAGE-BREAK
   ON TABLE SET LINES 99
   ON TABLE SET HTMLCSS ON
   ON TABLE SET PAGE NOLEAD
   ON TABLE SET ACROSSLINE OFF
   ON TABLE PCHOLD FORMAT &WFFMT
  
    ON TABLE SET SQUEEZE ON
   ON TABLE SET STYLE *
     INCLUDE=BLUEGRAY,$
	 UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.00000,
     RIGHTMARGIN=0.000000,
     TOPMARGIN=0.050000,
     BOTTOMMARGIN=0.050000,
	 RIGHTGAP=0.0,
     LEFTGAP=0.0,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     FONT='ARIAL',
     SIZE=5,
     COLOR='BLACK',
     STYLE=NORMAL,
     RIGHTGAP=0.0,
     LEFTGAP=0.0,

$
TYPE=DATA,
     SIZE=5,
$
     TYPE=TITLE, SIZE=5, COLOR=RGB(140 140 140),$
     TYPE=ACROSSVALUE, JUSTIFY=CENTER, BACKCOLOR=RGB(230 230 240),$
	 TYPE=ACROSSVALUE, ACROSS=1,JUSTIFY=CENTER,$
     TYPE=DATA, WHEN=LITM3 EQ ' ', STYLE=BOLD,$
	 TYPE=SUBTOTAL,$
     TYPE=DATA, WHEN=LITM2 EQ ' ', BACKCOLOR=RGB(200 200 200),
	      BORDER-TOP=LIGHT, BORDER-TOP-COLOR=RGB(90 90 90),
	      BORDER-BOTTOM=LIGHT, BORDER-BOTTOM-COLOR=RGB(90 90 90),$
     TYPE=SUBTOTAL,BACKCOLOR=RGB(200 200 200),
	      BORDER-TOP=LIGHT, BORDER-TOP-COLOR=RGB(90 90 90),
	      BORDER-BOTTOM=LIGHT, BORDER-BOTTOM-COLOR=RGB(90 90 90),$


     ENDSTYLE
 END
-RUN
-THEEND


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Report Caster and Report Size

Copyright © 1996-2020 Information Builders