Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Prompt for user input when running a report.

Status
Not open for further replies.

dhutcheson

Technical User
Jul 21, 2000
4
US
I have a report which uses a query to filter a date range. I want to be able to run the report and have it prompt the user to enter the date range, rather than manually changing the query every time. I know there has to be a way to do this, but I haven't been able to figure it out. Thanks.
 
var
rpt Report
rptInfo reportPrintInfo
dd date
endVar
;typical code
rptInfo.name = ":MYALIAS:MYRPT.RSL"
rptInfo.masterTable = ":MYALIAS:MYQUERY.QBE"
;see help for the other reportPrintInfo parameters

dd = today()
dd.view() ; user can edit the value

; typical lines in query

|start date|\n
|~dd |\n

rpt.print(rptInfo)

HOPE THIS HELPS.
Padraig
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top