Subject Re: PRINTING From Mustansir Ghor <mustan31@hotmail.com> Date Thu, 23 Mar 2017 14:08:33 -0400 Newsgroups dbase.getting-started Dear Mervyn Thank you. That is very useful information. Regards Mustansir Mervyn Bick Wrote: > On 2017-03-22 8:06 PM, Mustansir Ghor wrote: > > Dear Mervyn > > > > can we link memory variables to text object that we place on  the streamframe > > > > I'm not sure what you want to do.  With a bit more detail the answer can > be more specific. :-) > > You can assign values from a variable in a program or form to the text > property of a text object before the report is rendered.  To do this you > need to load the report into memory and create an instance of the report. > >    set procedure to myreport.rep //load the report >    form.oRep = new myreportreport() //create an instance > > This is usually done in the form's onOpen event handler so that it nly > gets done once. > > To launch the report, usually in a pushbutton's onClick event handler > >       form.oRep.pagetemplate1.text1.text = 'Sales Department' >       form.oRep.pagetemplate1.text2.text = 'February Monthly Report' >       form.oRep.query1.params['startdate'] = '2017/02/01' >       form.oRep.query1.params['enddate'] = '2017/02/28' >       form.oRep.query1.requery() >       form.oRep.render() > > Instead of the literal values assigned you could assign values from > entryfields or comboboxes (or whatever) > > >       form.oRep.pagetemplate1.text1.text = form.combobox1.value >       form.oRep.pagetemplate1.text2.text = form.combobox2.value >       form.oRep.query1.params['startdate'] = form.entryfield1.value >       form.oRep.query1.params['enddate'] = form.entryfield2.value >       form.oRep.query1.requery() >       form.oRep.render() > > > > Once the report has been launched you can change the value in the report > itself but any change in the form or program is not reflected in the > report. > > Mervyn. >