Here's how I do it
CREATE TEMP TABLE tCustPick ( +
CustID INTEGER, +
CustName TEXT (40), +
CustPick TEXT (1) )
I then base a scrolling region on the form, using a check box for
CustPick so that the region lines come out sort of like this
[ ] Ambulance Chasers Attorneys
[ ] Smith's Insurance
[ ] Johnson's Mortgage Brokers
I also provide two buttons
[Select All] and [Select None]
for user convenience.
[Select All] uses this eep
UPDATE tCustPick SET CustPick = "T" WHERE CustID IS NOT NULL
PROPERTY TABLE tCustPick "REFRESH"
RETURN
The where clause to print the report then includes this
WHERE CustID IN (SELECT CustID FROM tCustPick WHERE CustPick = "T")
Albert
Jim Belisle wrote:
I want to get into an area I have not entered before so I will need
some guidance.
My goal is to have a form with multiple choices (either will check
boxes or type in fields) that will print a report based on those choices.\
I assume I will need a series of Switch/endswitch codes.
I foresee my question being, “How do you eliminate the NULLs in the
choices and combine all the choices into a WHERE or SELECT clause.
I looked at the example SelfDesigningReports in RRBYW14 but that is
not what I want.
Jim
