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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Criteria listed in Report

Status
Not open for further replies.

MMTELLUS

Technical User
Nov 9, 2002
1
US
For this report multiple questions (criteria) are answered by the user. Each answer or blank response helps define the query. Is there a way to have the responses listed at the top of the report so the person reviewing the report understands how the results,conclusion or data are arrived at?
 
MMTELLUS,

This is possible, though it takes a bit of setup to pull off. Here's the general process:

1. In the report (or page) header, add calculated fields that pull in the values of environment variables. For example:
Code:
readEnvironmentString( "RPTTITLE" )

2. If you're using code to print your report, you'll need to modify that the set the environment string to the value you want printed on the report. If you're not using code, try something along these lines:

Code:
var
	rpt  Report
endVar

	writeEnvironmentString( "RPTTITLE", "My header text" )
	rpt.open( "customer" )
	rpt.wait()
	try
		rpt.close()
	onFail
		; do nothing; it's already closed
	endTry

Hope this helps...

-- Lance

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top