Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Help with creating a report

Help with creating a report

Help with creating a report

I'm new to this forum. I am looking for someone who can help me create a report in Paradox.

Here is the situation. I need to create covers for different jobs. An example would be books of invoices. The invoices may be numbered from 1 to 500 in books of 50 invoices per book. So the cover for book one would be labeled "1 to 50", book two would be "51 to 100", book three would be "101 to 150" etc. I may need to put logos on some of the covers but that is a separate issue.

The fields I have in my report are:
-Page size (5.5 x 8.5, 8.5 x 11, 8.5 x 14, etc)
-Orientation (landscape, portrait) these two fields are used to choose the report to use, whether it is one-up, two-up etc.
-Numbers per book (or page - 20, 25, 50, etc)
-Beginning number (this will be the starting number on first page - next pages will need to be calculated)
-Ending number (this minus beginning number divided by numbers per book gives total number of covers needed)

So I will need to create a report with the calculated number of pages (which is one thing I will need instructions on or will try to figure out) that will have the range of numbers printed on the bottom of each page ("1 to 50" on first page, "51 to 100" on second page, etc.) I think I will need to use page numbers to calculate this but how do I use the page number in a formula. I just need an example (such as [page #] + 1) and I can figure it out from there.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close