print only current record

[lake trash]

I posted in the summer but then had to put things aside and never got to the problem or got it fixed. Please help if possible.
1 I have a letter that I send out to new clients which fills the fields of date, fullname, address, etc. - it used to work fine when I simply pressed a button.
2 My table and/or set became corrupted early in the year and has not worked properly since.
3 Now when I press the button to print the letter - it begins at the first record and continues to print thousands of records
4 When I go to design the button and try to filter it, there is nothing for "8 current record only" as there is under other letters, forms, and labels

So my question is - what do I need to put - and where do I need to place it - so that ONLY the record with that person's fullname prints that single letter?

[johnkoh]

Re: print only current record

Hi Art,

The Onchange event from button should be work. but not sure about your filter.
Can you show your filter?

[Al Buchholz]

Re: print only current record

current record only - only appears if the form and report are based on the same table/set.

Otherwise use a filter on a unique value for the report. If you know the record number of the parent table of the report that'll work.

[lake trash]

Re: print only current record

I have not set a filter that I know of as I don't know what it should be. Have it set so the "onpush" event prints the letter. I am not that sophisticated. I know it would work if I set it so that it would only print the letter for that "fullname" or for that record number but don't know how to write that filter. Any help would be appreciated.

[lake trash]

Re: print only current record

Thanks Al but I don't think I am using a report. The letter is based upon the form I am using which has focus to the "fullname" and/or record #. I just don't know how to say - when sending this to the printer - just use the info from the record that equals "fullname" or "record number" - and then where to place that info. I would assume as a filter but just do not have enough experience to write something like that.

[Al Buchholz]

Re: print only current record

A letter is a variation of a report with a couple of additional options.

Put the control panel in detail view and look at the form and letter to see that they are based on the same table/set.

If not can they be? That's the easy way out.

Otherwise post a sample and we'll fix it for you.

[lake trash]

Re: print only current record

Thanks again - the form is from "client.set" and the letter is from "master.dbf" which is a child of the client set. All fields on the letter are from master.dbf.

[Al Buchholz]

Re: print only current record

Thanks again - the form is from "client.set" and the letter is from "master.dbf" which is a child of the client set. All fields on the letter are from master.dbf.

Otherwise post a sample and we'll fix it for you.

[MoGrace]

Re: print only current record

Your screenshot shows you are using the older multi-state A-Z buttons where a filter or query is used to display the clients whose name matches the selected letter. What I don't see is a button that the user would click to print the letter(s). I also don't see a field that would indicate the status of the client as 'new' vs 'active'. So my guess is you are wanting to print one letter at a time for the current client displayed? If that is the case a field that contains a unique record ID (not the record number) for the client (master.dbf) would be helpful. Then your print button could grab that field value and use it in the filter that you use to print the letter.

Just one example for your button script if you display the client_id on the form:

dim get_rec as c = ""
dim vfilter as c = ""
dim vorder as c = ""
get_rec = client_id.value
vfilter = "client_id =" +quote(var->get_rec)
preview_letter("yourlettername",vfilter,vorder)

[MoGrace]

Re: print only current record

Hi Art
Your forum profile settings are not allowing email responses.

a unique field for the table is namenumber
the letter name is new intro

So using your info, the button script to print a letter for the current record would now be this:

dim get_rec as c = ""
dim vfilter as c = ""
dim vorder as c = ""

get_rec = namenumber.value
vfilter = "namenumber = " +quote(var->get_rec)
preview_letter("new_intro",vfilter,vorder)

Note that to set the variable get_rec this way using indirect form methods, your field namenumber must be displayed on the form. Otherwise you would need to get a pointer to the current record in the child table which is more trouble than you need right now. Also, it wouldn't hurt to have an index for this field in the child table if you don't already.

BTW, posting here is always free!

[Gene FitzPatrick]

Re: print only current record

For what it's worth, I find that printing from a set can be problematic. What I do is to create a table that I base the report on that has only the one record to be printed. I then zap that table then copy the appropriate record to that table. Then I print the report. There is only one record and no set to deal with. For repeat letters, I just repeat the process for each letter. Perhaps this is not the most efficient way to go, but it works.

[Al Buchholz]

Re: print only current record

For what it's worth, I find that printing from a set can be problematic. What I do is to create a table that I base the report on that has only the one record to be printed. I then zap that table then copy the appropriate record to that table. Then I print the report. There is only one record and no set to deal with. For repeat letters, I just repeat the process for each letter. Perhaps this is not the most efficient way to go, but it works.

I'm not sure what the problem is that you are having with reports and sets, but I use sets with reports almost exclusively rather than basing the report on a single table.

I often find I need more fields from another table and having a report set makes it very easy to add another table and get the data I need.

That works well in dbf land.

In SQL land, I'd use a view to get the data I want for a report. (which the SQL view and the DBF set are similar in nature)

[Gene FitzPatrick]

Re: print only current record

I hear you Al. This may be an approach I started when there was a need to do mass emailing, which I still do without using anything outside Alpha. There are many ways to get the job done.

As they say, everything is for someone but nothing is for everyone!