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
July 02, 2009, 09:01 AM
GamP
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
July 02, 2009, 04:52 PM
T.Peters
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
July 02, 2009, 06:14 PM
Darin Lee
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
July 03, 2009, 03:45 AM
GamP
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
July 03, 2009, 12:56 PM
Doug
quote:
after I run the report
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.