Hi,
I have several documents with an Excel output, resulting in a report on each tab. I can get each tab to be named accordingly if I change the TITLETEXT='WhateverIwant' in the report itself. The problem is every time I open the report in InfoAssist and save it changes the TITLETEXT back to TITLETEXT=&WF_TITLE.QUOTEDSTRING. I also tried changing the -DEFAULTH &WF_TITLE='WhateverIwant' but that doesn't seem to have any effect. It gets frustrating because every time I make a change to the report I have to remember to go edit the text to update the title. Any ideas on how to accomplish this?

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

And doing instead at the top of the fex

-SET &WF_TITLE='WhateverIwant';

Does it work ?

If I use -SET &WF_TITLE = 'WhateverIwant';
I can run the report from the text editor and it works but if I go to save it I get a parsing error for the line below wherever I place the -SET. "By saving you will not be able to open this report with its original tool". I fiddled with placing it throughout the report (im not great with focus code) but couldn't find a spot it was happy with. Below is one of the reports. Any ideas on where I can place the -SET that wont break infoassist?

 
-SET &WF_TITLE = 'WhateverIwant';
-*COMPONENT=Join_J001
JOIN TELETRACKING_VTRANSFERS.TELETRACKING_VTRANSFERS.ENTRYTIME_YEAR_D WITH TELETRACKING_VTRANSFERS.TELETRACKING_VTRANSFERS.ACCEPTINGPHYSICIAN IN FINANCE/TELETRACKING_VTRANSFERS
TO UNIQUE CALENDAR.CALENDAR.CALDT IN expanse/calendar TAG J001 AS J001
END
-INCLUDE IBFS:/WFC/Repository/Operations/Transfer_Center_Reports/WHERES_TRANSFERS.fex
-*COMPONENT=Define_TELETRACKING_VTRANSFERS
DEFINE FILE FINANCE/TELETRACKING_VTRANSFERS
 DISPOSITION_REASON_ACC/A20=IF TELETRACKING_VTRANSFERS.TELETRACKING_VTRANSFERS.DISPOSITIONREASON IS MISSING THEN 'Accepted' ELSE TELETRACKING_VTRANSFERS.TELETRACKING_VTRANSFERS.DISPOSITIONREASON ;
 OTHER/A100=DECODE TELETRACKING_VTRANSFERS.TELETRACKING_VTRANSFERS.TRANSFERRINGFACILITY ( 'Baptist Hospital (Jax)' 'Others' 'Direct Admit' 'Others' 'Halifax Health Medical Center' 'Others' 'Jackson Memorial Hospital' 'Others' 'Mayo Clinic' 'Others' 'Memorial Hospital Jacksonville' 'Others' 'Nemours Childrens Hospital' 'Others' 'Orange Park Medical Center' 'Others' 'Other (Florida)' 'Others' 'Other (Outside Florida)' 'Others' 'Oviedo ER' 'Others' 'Putnam' 'Others' 'Select Specialty' 'Others' 'Shands/Gainesville' 'Others' 'Shands/Jacksonville' 'Others' 'Shands/Live Oak' 'Others' 'South Seminole' 'Others' 'St. Vincent''s Medical Center' 'Others' 'Tampa General Hospital' 'Others' 'Wolfson''s (Nemours) Jax' 'Others' 'Orlando Regional Med Ctr' 'Others' 'Arnold Palmer' 'Others' 'Advent Health Oceanside' 'Others' 'Florida Hospital South' 'Others'  ELSE 'Default');
OTHER = IF OTHER EQ 'Default' THEN TELETRACKING_VTRANSFERS.TELETRACKING_VTRANSFERS.TRANSFERRINGFACILITY ELSE OTHER;
END
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET SQUEEZE=ON
-DEFAULTH &WF_HTMLENCODE=ON;
SET HTMLENCODE=&WF_HTMLENCODE

SET HTMLCSS=ON
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT

-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
-DEFAULTH &WF_EMPTYREPORT = ON;

TABLE FILE FINANCE/TELETRACKING_VTRANSFERS
SUM CNT.TELETRACKING_VTRANSFERS.TELETRACKING_VTRANSFERS.TRANSFERID/I5C
BY TELETRACKING_VTRANSFERS.TELETRACKING_VTRANSFERS.SERVICEGROUP
ACROSS OTHER AS 'Transferring Facility'
WHERE TELETRACKING_VTRANSFERS.TELETRACKING_VTRANSFERS.TRANSFERRINGFACILITY NE 'Direct Admit';
WHERE TELETRACKING_VTRANSFERS.TELETRACKING_VTRANSFERS.EMCSTATUS NE 'Rehab';
ON TABLE PCHOLD FORMAT XLSX
ON TABLE ROW-TOTAL 
ON TABLE RECOMPUTE 
ON TABLE SET CACHELINES 100
ON TABLE SET GRWIDTH 1
ON TABLE SET AUTOFIT OFF
ON TABLE SET STYLE *
INCLUDE=IBFS:/WFC/Repository/Common/Branding/np_gphc_theme.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, $
ENDSTYLE
END

-RUN