>Hi All
>Have a Labels Shell Form that prints sheet labels using a free table in the DE. Want to avoid wasting labels when we don't have a full sheet.
>
>Am looking at Cathy Pountney's book "The Visual FoxPro Report Writer: Pushing it to the Limit and Beyond" and on page 254 there is a good solution. It suggests that you put a spinner on the form to get the number of missing labels on the first sheet. Then you add n blank records to the beginning of the table.
>Is there a way to remove the blank records at the end of the print label job without doing a "mass delete"?
>All help appreciated.
>Bill Wright
Even without such a requirement, I SELECT all data for any one of my reports into a cursor. I think this is simpler than setting filter and relations. Also, some reports require additional data preparation (such as the one you mention).
After the report is run, the cursor is closed (usually, by closing the form that controls the report, if the form has a private DE). This will destroy the cursor. The original data, of course, is left untouched.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)