🚀 go-pugleaf

"Jason Ortner" <jortner@onramp113.org> wrote:

>I am lost!!  I am trying to write a report and I need to pass the
>limiting dates to the query.  I have found where you can, it says, use
>parameters for a query.  Exactly how you do this is less than clear in
>the OLH.  Below is the query statement in the report and the sql
>statement I attempted to get the query to accept the params.  Nothing
>works and the error msgs are to say the least cryptic.  Can anyone
>help?  I am posting this in the sql group also, I know that the same
>people read all the groups most of the time, I'm just hedgeing my
>bets.  I am frustrated.

First off, stop using the sql designer. Really. You're going to find
yourself getting stuck. Second ... it's much easier than you're
trying. I assume you are getting the dates from a form (user input),
correct?  If so, create a single datamodule. 

Place an instance of the datamodule on your form. Set the SHARED
property to ALL.

Place an instance of the datamodule on your report. Set the SHARED
property to ALL.

In the form, set your filter using either the rowset's filter
property, or the beginFilter()/applyFilter() methods. Call the report
from the form. Doing this will cause the _report_ to be generated
using the filter set in the form ...

Ken
---
Ken Mayer [TeamB]
Golden Stag Productions
http://www.mindspring.com/~hirschv/homepage.htm
http://www.mindspring.com/~hirschv/dbase/dbase.htm

Please respond in the newsgroup unless explictly asked otherwise