Trying to get form variable value to filter a report

[twwtc]

Still stuck, I'll try asking another way.

While viewing a record in a form, I would like to put a button on the form that when pushed, the value in the field "wtc_num" would be stored in a variable called "num".

Then I would like to be able to close the form and print a report that was filtered with the use of the variable "num"


Thanks
Tony

[Keith Hubert]

Re: Trying to get form variable value to filter a report

Hi Tony,

To save a long explanation that could be rather confusing, have a look at the Invoice form in AlphaSports.

Also, dont consider closing the form before the report is printed.

[twwtc]

Re: Trying to get form variable value to filter a report

Thanks Keith
I'll take a look tonight!

[Clunes]

Re: Trying to get form variable value to filter a report

Simple action script. Look for setting variable based on field on a form

[omagarc]

Re: Trying to get form variable value to filter a report

You can also run a query on the form and base the report on currently selected records.

[twwtc]

Re: Trying to get form variable value to filter a report

"Simple action script. Look for setting variable based on field on a form"

and

"You can also run a query on the form and base the report on currently selected records"

Can these two methods still be done if the form is not open?

Thanks for the help

[Clunes]

Re: Trying to get form variable value to filter a report

No, but in the same area look at variables in action script. You will see a lot of options. One includes to set based on an external table

[Mike Wilson]

Re: Trying to get form variable value to filter a report

I'm not certain what the problem is here. This should be flawlessly easy to have the form button set the variable "num" scoped global, and the report filter use that global variable value in the report filter. I personally would select a more robust variable name like vg_wtc_num, but should work without a problem regardless.

[Keith Hubert]

Re: Trying to get form variable value to filter a report

Mike,

The problem I think is that our friend is closing the form first before running the report, as per his opening thread and message 6.

[Ted Giles]

Re: Trying to get form variable value to filter a report

Any reason to not have a Report Table with the list of items to be printed?
You could then have a tick to say that there had been a print, or if there had been a failure in the process. (Had to do this at Chase!)

[CALocklin]

Re: Trying to get form variable value to filter a report

Maybe I missed something but I don't see any example of how you are creating the filter. That might help us solve the problem.

As someone else pointed out, the variable needs to be global. (And a name like "num" really isn't a very good name for a variable - see this.)

Also, I suspect you need to use "var->" before your variable name in the filter definition but can't be sure unless you show us how you're defining the filter.

[twwtc]

Re: Trying to get form variable value to filter a report

Thanks for everyone's help. I used action scripting to write the following code and it is working.

'Get 'Value' property of 'Field1' in Form 'TracNew' .
DIM GLOBAL wtc_num AS n
wtc_num = parentform:Field1.value

'Save record in current form.
topparent.commit()

'

query.filter = ""
query.order = ""

to_param = a5_eval_expression("[email protected]",local_variables())
cc_param = a5_eval_expression("",local_variables())
bcc_param = a5_eval_expression("",local_variables())
subject_param = a5_eval_expression("Just Sold",local_variables())
message_param = a5_eval_expression("",local_variables())


:Report.Send("Just_Sold","TXT",query.filter,query.order,"default",to_param,subject_param,message_param,cc_param,bcc_param)

Now I am trying to format the text that is being sent.
Currently:

FRM:John Doe
SUBJ:Just Sold
MSG:See Attached report:
Just_Sold???(my calculated field)

Just_Sold is the name of the report I use.

Would like to get rid of "???" Is that possible?

Thanks Again!!!

[Tom Cone Jr]

Re: Trying to get form variable value to filter a report

Tony, the message board works better (as a knowledge base for others) if each thread of messages deals with a single question. Suggest you start a new thead for your next question since it has nothing to do with the first. Ok?