Printing Checks Using SSRS 2005

[ousoonerjoe]

How would you go about creating an SSRS 2005 report to preview/review/and print checks? The check page is standard 8 1/2 x 11 paper with the top 1/3 for the check and bottom 2/3 for invoice items. Catch-- the invoice items may exceed the space allocated on the first page and need to role over to the 2nd page. The check area for each page after the first check would have to be marked as "VOID". I could work out how to do it on a "One Check At a Time" basis, but what about for batch? We may need to issue 500 checks in one day. Printing them singularly is not practical. We also need the batch of checks to be written to PDF for Accounting. The master application that will call the Server-Side report is in VB.Net 2005.

I'd like to be able to just attach the Stored Procedure to the report and call the report with arguments via the main application. The coding isn't so much the problem as it is the logic on the check forms.

How do you get the excessive line items to carry over to the next page and not print the check again?

How do you handle the page numbers to be of that check/invoice rather than the entire batch?

(NOTE: I will be printing the MICR/CheckNum/etc on the page, so no need to worry about that.)

If this needs to be moved to the VB.Net forum, just let me know. Any thoughts, ideas, comments and random bits of insanity are welcome.

Thank you.

"If I were to wake up with my head sewn to the carpet, I wouldn't be more surprised than I am right now.

 

[ousoonerjoe]

Update:

After many attempts of breaking through the brick wall with my head, I have finally found a way to get this to work:

On my blank report, I removed all headers and footers. Then I added 2 Groups with Group Headers. Create the check layout in Group1 Header. Insert a row below that and place your column headers for your summary information. In the third row of Group1, place your SUM totals for that check. In Group2 Header, merge all fields together and place a rectangle in it. In that rectangle, draw a table to place your itemized invoice information on. Set your page breaks and your off and running.

The check prints on the first page. If the invoice carries over to the next page (or more), the check is not reprinted. Only the invoice headers are reprinted at the top of each page.

I'm sure there's a cleaner and easier way to do it, but this is what I was able to come up with. Now i just need to get the secondary pages to not print in the check area so that "VOID" can be printed across it, OR figure out how to get the extra pages to be printed using normal paper in the other drawer of the printer.

"If I were to wake up with my head sewn to the carpet, I wouldn't be more surprised than I am right now.