paradox - printing

[skkeswani]

i use paradox to keep track of my client information (name, address, phone #, etc.)

I previously have used paradox 3.5 n used that to print my envolopes to my clients directly, but i am unable to figure out how to get the paradox 9 to do the same.
can somebody pls. help me

thank you

 

[footpad]

skkeswani,

Are you printing directly to the envelopes or printing address labels to be placed on the envelopes?

In either case, you need to create a report that matches the size of the item you're printing to. If you'll print directly on the envelope, for example, you need to make sure your report size matches the envelope size and that its set to a landscape orientation.

Use File | Page Setup from a report's design window to do this.

Next, you'll need to set up the report so it prints an appropriate number of records for each "page" (envelope or sheet of labels). If you're printing to labels, you should place a multi-record object (MRO) on your report and then set the Rows and Columns to match the number of labels on each sheet.

If you are printing labels, you'll notice the Record Layout tab on the MRO's property sheet contains two settings called "Separation." This controls the spacing between each label. For best results, set this to 0.0 for both settings. This lets you fine-tune the width and height of each label directly and I've personally found this easier to refine when there's no additional space in each label.

When yo change the separation to 0.0, you'll notice a bit of extra space along the top and left sides of the MRO. Select the outer handle and drag it down and to the right to remove this extra white space.

Next, select the MRO's Record object, right-click it, choose Properties and then select the Run Time tab. Remove the check marks in Fit Width and Fit height. This ensures each label prints in the the same amount of space. Once you've done this, adjust the size of the record size to match the size of each label on your label sheet.

If you're printing directly to envelopes, you'll want to size the Record band to match the full size of your envelope.

Now that you've sized things appropriately, drop field objects and bind them to your data tables. Test your object placements by printing a few pages and see how well they match your output. You'll probably need to experiment to get this right.

At this point, the process generally turns into one of tweaking and refinement.

To print selected addresses, use a query to grab the addresses to be printed and then use the querys Answer table as the report's master table. (See

http://www.techtricks.com/paradox/printone.php

and

http://www.techtricks.com/paradox/btntutor.php

for ObjectPAL based examples.)

In any event, the "trick" here is to design a report that fits results in the appropriate amount of space.

Hope this helps...

-- Lance

 

[skkeswani]

thank you ,
but how do i drop the fields and bind them into the tabl, and then how do i test the print?

thank you

 

[footpad]

skkeswani,

When you open your report in the Design window, you're given a toolbar containing design objects. Move the mouse pointer over these until the tooltip says "Field object."

That's what you'll need to drop on your report.

To bind a field object, select it, right-click it, choose Define Field. This shows your data model; select the target table and then choose the target field from the drop down list.

To add tables to the data model, choose Format | Data Model from the design window's main menu.

To test your design, simply run the report by choosing the Run Report button from the toolbar.

You may wish to review Lesson 6 of the Paradox tutorial, which is available from the Help menu of the main menu.

Hope this helps...

-- Lance

 

[skkeswani]

thanks for your help,

but i am still completely lost...
can someone contact me by email possibly or in here
with something that i can uderstand bec.
i got a bit confused wit the directions..
thank you

skkeswani@aol.com