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.
To start off, I have 4 Webfocus environments all on 7.6.8. Two of my four environments displays gif's in a PDF report and two do not. Both my Dev and Test environments work fine, but my QA and Prod environments do not work and I am at a loss here trying to figure out what the issue is.
The environments are all the same and standalone. I have compared the CGIVARS file on each and for the most part they are configured the same. The Gif's do exist in all the environments as they work with HTML and Excel outputs.
Here is the sample CAR fex
DEFINE FILE CAR
DETERMINATE/A1 WITH DEALER_COST= IF DEALER_COST LT 5000 THEN 'R' ELSE IF
DEALER_COST GT 9999 THEN 'G' ELSE 'Y';
DISPLAYCOLOR/A100 = DECODE DETERMINATE('R' 'dot_red.gif'
'G' 'dot_grn.gif'
'Y' 'dot_yel.gif');
END
TABLE FILE CAR
PRINT DEALER_COST
COMPUTE DDOOTT/A100 = DISPLAYCOLOR;
BY BODYTYPE ACROSS SEATS
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=DATA, ACROSSCOLUMN=DDOOTT, IMAGE=(DDOOTT), SIZE=(.08 .08), $
ENDSTYLE
END
END
Any suggestions?
ThanksThis message has been edited. Last edited by: MattC,
Where are the files for dot_red, dot_grn, and dot_yel? They must be in the app path of the server - which could be configured differently on each environment. I don't think they're there by default as your code doesn't work for me either.
BTW: That's pretty cool that you're licensed to run four separate and standalone installations of WF. Wish we could all afford that - would make testing and QA a lot easier.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007
That's it!!! The gif's are in the /vis directory on the client itself on all 4 environments but were not on the Report Server for the QA and Prod environments. This is why they showed up in the HTML/Excel format in all environments and not the PDF in the two. As soon as I copied over the gifs into an APP folder that's in the path it worked. I guess you need it on the Reporting Server for PDF
It's nice to have 4 environments, but at the same point this is the type of trouble that you can get into. I scoured all 4 environments for the last 4 days trying to figure this out.