🚀 go-pugleaf

IT Manager wrote in message <01bd9441$14353ba0$c7a09384@russo1>...
>Ken,
>I am having the same problem as Jason. I think I understand the
solution,
>but am having trouble with the syntax of setting the filter in the
OnClick
>routine of the form.
>Any help would be appreciated.
>Thanks
>Ron Russo


Ron,

This solution worked great for me.  I have two forms that use two
different dmds and do two different reports.  Below is the way I set
the range and the filters for both.  If you need more info.  just ask.

1.
form.datamodref1.ref.tlog1.rowset.setrange(_app.bd,_app.ed)
   form.datamodref1.ref.tlog1.rowset.filter = [op_id = '];
   +_app.id+[']

You may have to play with the syntax for the filter, depending on what
you are using.  I really don't understand why this one has to be so
complicated, but that is what worked.

2.
form.datamodref1.ref.log1.rowset.setrange(_app.bd,_app.ed)
   form.datamodref1.ref.log1.rowset.filter = [op_id = '];
   +_app.id+[']

The set range vars. are just gotten from user input off the form.  If
you don't make them global(at least for me) you run into loss of scope
when you page your form.  The reason they are both the same is I
changed one the match the other when I started having problems in one
of my reports.  Now as far as I know, all works well.  Good luck.

Jason Ortner         jortnerxxppmm@onramp113.org