Focal Point
[solved]Accessing parameter value when chaining from a calendar control

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3207039826

February 21, 2013, 02:16 PM
dcorp
[solved]Accessing parameter value when chaining from a calendar control
In HTML Composer I am attempting to filter a listbox from a chained calendar control parameter value. The calendar control date range is set to relative and the date format is MDYY. I am not using a procedure to create the calendar. The date within the listbox data file is format YYMD. So far I have been unsuccessful in accessing the calendar parameter value in the procedure used to generate the listbox. Can anyone tell me how to pass the calendar control date parameter value to a chained listbox? Thanks in advance.

This message has been edited. Last edited by: dcorp,


WebFOCUS 8.1.05/PMF 8.1.4,Tomcat,IIS,Windows/iseries,sql server 2008,Excel/ PDF/HTML
February 27, 2013, 01:55 PM
Kerry
Hi Tom,

From our technicals: What you can try is to set the calendar control to YMD format and set the listbox to YMD. IF that doesn’t help, please open a case with Customer Support Services for assistance. You may call 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
February 27, 2013, 02:16 PM
dcorp
I developed a process that I will label a workaround. It works well and I am happy with the solution. Step 1: I created a hidden list box containing calendar dates in A8 yymd format. Step 2: I chained this listbox to the listbox that I wanted to filter based on the user supplied calendar date. This listbox contains a list of vendors. I also have a listbox containing regions that is chained as well to the vendor listbox and I wanted both filters to apply. Step 3: I pick up the calendar entry via an event and use IbComposer_setCurrentSelection to select the corresponding calendar date in the hidden listbox. The chaining takes place and my vendor listbox is then refreshed with the filtered values from both listboxes applied. There may be another way, but like I said it works great for me. Thanks.


WebFOCUS 8.1.05/PMF 8.1.4,Tomcat,IIS,Windows/iseries,sql server 2008,Excel/ PDF/HTML