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.
Without coding in WebFocus, does anyone know a way to configure Report Painter, HTML Layout, or anything to allow the user to resize form elements at run-time? I am running IBM DB2 Webquery and there's nothing in the Redbook about how to do this, but I'm pretty sure I saw some demos at Summit where people could do this in their reports.This message has been edited. Last edited by: Kerry,
WebFOCUS: 7702 O/S : Windows Data Migrator: 7702
Posts: 127 | Location: San Antonio | Registered: May 29, 2009
I'm not quite sure about what it is that you are looking for. Do you want your users to be able to enlarge the size of one or all of the input fields?
If so, there is nothing in WebFOCUS that will allow you to do that, but there are javascripts available on the web that will do just that. I found one that can be modified to your needs (if I'm assuming correctly) on this site.
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007
I should have specified a little better, I want to be able to resize the output report columns that WebFocus builds.
quote:
SUM AC_CONTACT_NAME AC_ACCOUNT_ADDR_1 AC_ACCOUNT_ADDR_2 AC_ACCOUNT_CITY AC_ACCOUNT_STATE AC_ACCOUNT_ZIP BY AC_ACCOUNT_NAME WHERE (AC_PROC_STATUS NE 'C')AND (AC_EXCESS_FLOOD EQ 'N')AND (J001.MTG_FMS018.MP_TREATY_NO EQ 19 OR 48)
I want to be able to drag the column width of AC_ACCOUNT_ZIP after I run the report.
WebFOCUS: 7702 O/S : Windows Data Migrator: 7702
Posts: 127 | Location: San Antonio | Registered: May 29, 2009
None of the WebFOCUS tools allow for this type of functionality. The only way you'll get that functionality is to output to EXL2K or do some serious javascripting. There are Flex reports that use grid elements which give you a lot of additional functionality, but other than that I don't know what it could be that you might have seen.
You can specify the column width a number of different ways (SQUEEZE=, WIDTH=, etc.) before running the report, but not after.
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
Darin seems to have hit the nail on the head with his remark about Flex reports. That tool indeed has the functionality to make columns wider or less wide. But it will not extend beyond the limits of the resulting window. So flex reporting is the answer for you.
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007
Darin and Gamp are correct (no surpirse there). Also, consider that the report is outside of WebFOCUS "after I run the report". So, it's up to the destination format to do what you desire.
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005