Hi Martin,

I'm alergic to public vars - don't use 'em if I can avoid it.

Dataenvironment - BeforeopenTables

* cBatchNo would be the parameter
* I also would have liked to get the result in a variable instead of a cursor
* but that has so far eluded me

Local  nResult AS Integer, cSql AS String 

Text To cSql Noshow   
  Select Sum(Amount) AS Amount from dbo.CreditorInvoices 
     Where BatchNo = ?cBatchNo Group By BatchNo
EndText
	
nResult = SQLExec(lnSql,cSql,'TempAmount')

>Hi Peter,
>
>What parameter? Parameter pro SQL view or filter?
>
>Each local variable from caller procedure is visible in report. Or you can use PRIVATE or PUBLIC variables.
>
>MartinJ
>
>>Can it be done?
>>
>>If so, where and how?
>>
>>
>>BR & TIA
>>
>>Peter