Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Run code in report form
Message
From
12/01/2009 11:31:08
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
12/01/2009 11:26:29
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01372806
Message ID:
01372831
Views:
16
>>>I want to be able to run a block of code in the report form when it first starts. How can I do that? The reason is that for this particular report, I want to run SQL against the current alias and create a generic cursor (Fld001, Fld001, etc.). This cannot be done in code priort to the REPORT FORM statement in the calling code.
>>
>>Why "This cannot be done in code priort to the REPORT FORM statement in the calling code."? Report have some private datasession? If so you can run the code in report DE.OpenTables.
>>
>>Or an easy alternative would be a call to a user defined function from within report. ie: add a field in report title with a call to UDF().
>>Cetin
>
>Also, see the stupid reply I made to myself: "Will any references I make to a variable or the cursor created in the function be available for all groupings and detail field in the report?"
>
>I really wish UT would warn you when you reply to yourself.

I don't understand:) As for the varables you can think o it as all the variables accessible by the routine that called the report command. You wouldn't have access to variables created in UDF.

PS: I really don't understand why it cannot be done before report (and I would bet you can).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform