Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Passing parameters to reports?
Message
 
To
04/07/2006 07:52:39
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01133560
Message ID:
01133565
Views:
16
Use Private vars then (I hate PUBLIC too). There where you call this report you could put:
cBatchNo =[Someting]
REPORT FORM ....
>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform