Check Box -List Box Parameter Default

[Ellenu]

I'm using the Script Genie to define an "on Push" event for a button.

The button prints a report, and I am using a Check Box - List Box to prompt for Parameters. The 'choices' come from a table. Is there anyway to have the default value be that all choices are checked (selected)?

I've tried entering .T. as the default value, but it doesn't work.

Thanks!

[Stan Mathews]

Re: Check Box -List Box Parameter Default

The check box represents a variable? The way to have all checked would be to populate the variable with all the possible choices, then display the check box.

[Ellenu]

Re: Check Box -List Box Parameter Default

The check box does not represent a variable (I'm unfortunately not that sophisticated). The check box lists the 5 field values (records) in a table called "Status" that serves as a table look-up for a field also called 'Status' in the main Table the report is based on.

Since I first posted, I discoverd that if I, in the Script Genie, typed in the name of 1 of the 5 possible field values in the 'Default' section, that choice shows up 'checked'. So it is not looking for .t. or .f., but the actual value of the field.

Is there an equation such as =date() that would include every possible value in the field?

[Stan Mathews]

Re: Check Box -List Box Parameter Default

Since I first posted, I discoverd that if I, in the Script Genie, typed in the name of 1 of the 5 possible field values in the 'Default' section, that choice shows up 'checked'.

So if you can get all five values in the default section they will all show up as checked.

[Davidk]

Re: Check Box -List Box Parameter Default

I tried that Stan, and it works. Putting all the values in the default has them checked in the dialog box.

Ellen, you said your Check list box is based on a table and that you're creating the dialog box in a script. How are you getting the choices into the dialog box from the table... there doesn't seem to be an option to read values from a table - are you typing them in?

[Davidk]

Re: Check Box -List Box Parameter Default

Here's an odd behaviour of the Check List Box dialog.

Build one, and, while you're building click the More Options button. You'll get a dialog with about 9 options... Height... etc. Finish entering the fields and click the next button, then click the back button. Now click the More Options button. I get a different list - just a couple of items - one being the Selection Style. Could someone confirm this?

[Ellenu]

Re: Check Box -List Box Parameter Default

Putting all the values in the default has them checked in the dialog box.

The way I'm getting at entering in the default values, if I list more than one value, either separated by a comma or just in a string, none of them are checked.

Ellen, you said your Check list box is based on a table and that you're creating the dialog box in a script. How are you getting the choices into the dialog box from the table... there doesn't seem to be an option to read values from a table - are you typing them in?

I'm in Code Editor for Menu:Button8:OnPush
Add New Action : Print a Layout
Script Genie opens up. Select my report, hit next
Prompt for Paramaters at Runtime:
Add Filter, Select Field = Status, Operator = is equal to, Option = Prompt at Runtime
Hit Customize Parameter button
Select "Check-box-list-box"
Define Choices, select Computed Automatically, and here is where I identify the table that I want to use for my choices.

I'm attaching what it looks like when converted to Inline Xbasic. The default values are highlighted in red. When I list more than one value, like shown in attached, none of the boxes are checked.

[Davidk]

Re: Check Box -List Box Parameter Default

Didn't know that... will try it when I get back to my office. There must be some way to preload the default choices. When I look at Xbasic code the the Check-List box the choices are laid out as

A
B
C

in the xdialog code. I would imagine it's the same for the report stuff - so it's a CRLF delimited list.