Very Computer

by **Dennis Wats** » Fri, 30 May 1997 04:00:00

I have a Paradox 5 form with a button that runs a report. That works
OK, but I'd like the form to ask me to first enter a filter value and
then use that value when it runs the report. The value I'm interested
in is the Date (I hope to default with the current date, too).

I've been pouring through the manuals and help files, but I haven't
been able to figure this one out. Any help you offer will be very
much appreciated.

Dennis Watson

by **Kasey Cha** » Fri, 30 May 1997 04:00:00

Quote:>I have a Paradox 5 form with a button that runs a report. That works
>OK, but I'd like the form to ask me to first enter a filter value and
>then use that value when it runs the report. The value I'm interested
>in is the Date (I hope to default with the current date, too).
>I've been pouring through the manuals and help files, but I haven't
>been able to figure this one out. Any help you offer will be very
>much appreciated.

Use the QUERYSTRING parameter and specify a query that will filter the data
for you.

==========================================================

----------------------------------------------------------
Paradox for Windows HTML/web design PC Star Trek other
----------------------------------------------------------
Star Trek Nexus http://users.aol.com/ksc1/startrek.htm
USA TODAY Hotsite Winmag Hotspot Project Cool Sighting
"[The] ultimate guide to all things Trek on the Net"-Lycos
"Probably the best starting point for Trekkies"--Looksmart

by **Daniel A. Morga** » Fri, 30 May 1997 04:00:00

Quote:> I have a Paradox 5 form with a button that runs a report. That works
> OK, but I'd like the form to ask me to first enter a filter value and
> then use that value when it runs the report. The value I'm interested
> in is the Date (I hope to default with the current date, too).

> I've been pouring through the manuals and help files, but I haven't
> been able to figure this one out. Any help you offer will be very
> much appreciated.

If you weren't a newbie I'd suggest you create a custom dialog box. As
it is, look at the view() function and you want use the today() function
to load it with the current default date. Convert the value returned by
view() to a string variable in you query preceded by a tilde.

Daniel A. Morgan

Very Computer

Newbie question, PDOX5, Set Report Filter from Form?

Newbie question, PDOX5, Set Report Filter from Form?

Newbie question, PDOX5, Set Report Filter from Form?

Newbie question, PDOX5, Set Report Filter from Form?