Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] TITLETEXT=&WF_TITLE.QUOTEDSTRING Overwritten by InfoAssist
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] TITLETEXT=&WF_TITLE.QUOTEDSTRING Overwritten by InfoAssist
 Login/Join
 
Member
posted
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,


WebFOCUS 8.2, Server 2008 R2, SQL 2014 data warehouse
 
Posts: 18 | Location: Daytona Beach | Registered: November 19, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
And doing instead at the top of the fex
-SET &WF_TITLE='WhateverIwant';

Does it work ?


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2223 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Member
posted Hide Post
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

 


WebFOCUS 8.2, Server 2008 R2, SQL 2014 data warehouse
 
Posts: 18 | Location: Daytona Beach | Registered: November 19, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] TITLETEXT=&WF_TITLE.QUOTEDSTRING Overwritten by InfoAssist

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.