×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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

Jobs

Modifying Existing Check Printing Report

Modifying Existing Check Printing Report

Modifying Existing Check Printing Report

(OP)
Hi, All:

Our Accounting department uses Crystal Reports to print checks to vendors on 8.5 x 11 paper where the check is already pre-printed on the bottom third of the page. On the top third of the page, the current CR prints some page header info (CR page header section) along with a varying number of invoices and amounts (in the CR Details section) related to what the check is for. The middle third is currently blank. The CR page footer section is used to print what relevant info goes on the check. The report is grouped by check number, and the total amount of the check (the sum of the invoices) displays in the group footer. A second page is also printed that repeats the information from the first page.

I have been asked to modify the report to repeat in the middle third of the page the same invoice/amounts info as in the top third (minus the header info), with one more trick: If the number of invoices in the top third exceeds allowable space, only repeat in the middle third what fits in the top third. The remaining records would then need to print on the second page (in the top third) and be repeated in the middle third as well.

For example, let’s say up to 5 invoices are all that will fit in the top third when printed:

Here’s an example if the total # of invoices easily fits in the top 1/3rd (The same information would then also print on the second page):
----------------------------------------------------------
Top 1/3 of both pages 1 & 2:
<some check header info here>
Date Invoice # Amount
7/1/18 Invoice1 $750.00
7/1/18 Invoice2 $100.00
7/1/18 Invoice3 $250.00
----------------------------------------------------------
Middle 1/3 both pages 1 & 2:
Date Invoice # Amount
7/1/18 Invoice1 $750.00
7/1/18 Invoice2 $100.00
7/1/18 Invoice3 $250.00
----------------------------------------------------------
Bottom 1/3 both pages 1 & 2:
Pre-printed check (voided on p. 2)


Here’s an example if the # of invoices exceeds what fits in the top 1/3rd on the first page. What fits (the first 5 invoices) is repeated in the middle section of the first page. On the second page, the remaining invoices would print in the top and middle thirds:
----------------------------------------------------------
Top 1/3 of page 1
<some check header info here>
Date Invoice # Amount
7/1/18 Invoice1 $750.00
7/1/18 Invoice2 $100.00
7/1/18 Invoice3 $250.00
7/1/18 Invoice4 $300.00
7/1/18 Invoice5 $150.00
----------------------------------------------------------
Middle 1/3 of page 1
Date Invoice # Amount
7/1/18 Invoice1 $750.00
7/1/18 Invoice2 $100.00
7/1/18 Invoice3 $250.00
7/1/18 Invoice4 $300.00
7/1/18 Invoice5 $150.00
----------------------------------------------------------
Bottom 1/3 of page 1
Pre-printed check

On the 2nd page, the remaining invoices would print as follows:
----------------------------------------------------------
Top 1/3 of page 2
<some check header info here>
Date Invoice # Amount
7/1/18 Invoice6 $800.00
7/1/18 Invoice7 $400.00
7/1/18 Invoice8 $200.00
----------------------------------------------------------
Middle 1/3 of page 2
Date Invoice # Amount
7/1/18 Invoice6 $800.00
7/1/18 Invoice7 $400.00
7/1/18 Invoice8 $200.00
----------------------------------------------------------
Bottom 1/3 of page
Pre-printed check (voided)


Hopefully, I explained this challenge clearly. I am fairly experienced in using CR, but I'm a bit stumped wrapping my head around this one. Thanks for any ideas anyone has!

RE: Modifying Existing Check Printing Report

I think you would need to use subreports, one in each of four group header sections. In each subreport, insert a running total {#cnt} that counts each record. In the first two subs, suppress the detail section with a formula: {#cnt}>5 and in the second two, use {#cnt}<5. Size the group header sections so that only two fit on a page, with the page footer sized for the check.

It is unclear to me how you allow for the group footer if each page is divided into thirds. Perhaps you have a third group header on each page, and on page one you have allow it reserve space, while you show the total in the group footer on page 2.

I’m guessing that you might have situations where you exceed 10 invoices, and therefore might require more than two pages, which makes it more complex. Let me know if that’s the case.

I didn’t test this (famous last words), but I think it should work.

-LB

RE: Modifying Existing Check Printing Report

PS. You would also have to conditionally suppress the group header sections using a formula. Set the page numbers to reset on change of group first. Then conditionally suppress GH_a and GH_b with pagenumber>1 and GH_c and GH_d with pagenumber=1.

-LB

RE: Modifying Existing Check Printing Report

(OP)
LB,
Thanks a ton for the ideas. I'll continue working on this and see what kinds of results I can produce. Much appreciated!

SC

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