Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help With W2 Form

Status
Not open for further replies.

goduke

IS-IT--Management
Feb 13, 2006
65
US
I have created a report to replicate the W2 form that you get every year for your taxes and I have a quick question. Because the IRS requires you to submit 2 copies, plus another copy for your own records, I have to create the template 3 times, each one with the same fields etc. Is there any way that i can just create the template once, then have it print 2 copies? The report wont take so much time to run and this will speed up our process since everyone is out on our intranet trying to generate their W2 at the same times. Any help would be great! Thanks.
 
Quickest way I know to do this and get it right is to copy your main report, bring it in as a subreport in the report footer, and then one more time in another report footer section below that.

There are some database tricks, such as joining your other information to a table that has some number of records with a numbered field, and then limiting it to those records.

That is pretty kludgy and especially bad if someone else slips some extra records into the table.


 
An alternative is to create 2 more detail sections (Detail b & c). Select & Copy everything from Detail a to Detail b & c.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top