Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
LPARAMETERS in BeforeOpenTables Event?
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00459511
Message ID:
00459542
Views:
20
>Hello Everyone!!!
>
>I have a form that has two textboxes - Username, and password.
>I want to send the values to the BeforeOpenTables Event in my report.
>Can that be Done, or Do I need to come up with a better plan?

Create Private variables for username and password in the form method that calls the report, then use them in the BeforeOpenTables event.
e.g.,
** form.CallReport()
Private pcUserName, pcPassword
pcUserName = "Leroy"
pcPassword = "Password"

Report Form myreport Preview
What would the BeforeOpenTables event do with them? If it's for view parameters, as long as the variables exist, you wouldn't need to code anything in BeforeOpenTables.

>If it can, How could I do it with the report command?
>i.e.
> REPORT FORM (REPORTNAME) PREVIEW
>If I can't use this syntax, what should I use?

If REPORTNAME is a variable containg the name of the actual report, e.g.REPORTNAME = "myreport", this syntax works for calling a report.
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform