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

Yes. May return an actual value.

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
Reply
Map
View

Click here to load this message in the networking platform