Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Run code in report form
Message
From
12/01/2009 11:23:36
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
12/01/2009 10:58:02
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01372806
Message ID:
01372825
Views:
14
>>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.

Doesn't matter why, but it cannot be done.

>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().

Hmmmm.... So my report title could be:
"My Report Title" + MySQLFunction()
And as long as the function only creates a cursor and doesn't return an actual value, it will work?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform