# 3 section check
**Category:** [Epicor ERP 9](https://www.epiusers.help/c/e9/7)
**Created:** 2016-10-05 15:38 UTC
**Views:** 5038
**Replies:** 25
**URL:** https://www.epiusers.help/t/3-section-check/35706
---
## Post #1 by @Alex
Hello guys I am working in a check to transfer the print form from Crystal to SSRS.
The problem is that the check in Crystal is a 3 part check which means
section 1 -> table with invoice number
section 2 -> Check
Section 3 -> table with same invoice numbers
In SSRS i cannot use sub-reports or Tables in the footer like in crystal. does anybody have an idea how to archive this form in SSRS?
PS: I already try referencing the table in the footer, but it didn't works, and if I reference a text field, it just return the last value of the list
---
## Post #2 by @bmgarver
Use rectangles to position the three-parts properly
Rectangle #1 - 1/3 height x width of check containing the Invoice Detail
Table
Rectangle #2 - 2/3 height x width of check containing text boxes with the
check details placed in the correct positions.
Rectangle #3 - Full height x width of the check containing a Copy/Paste of
the Detail Table and adding an additional row to the table above and
outside the highest group. The height of this row should be 2/3 height of
the check to position the table properly below the check detail.
All rectangles are located at 0, 0 in the body of the report, essentially
overlapping so they will not affect each others position. No Header, No
Footer required.
Thanks,
Brian M. Garver
Northern Concrete Pipe, Inc.
---
## Post #3 by @josecgomez
We have accomplished this before, however it is a royal PAIN. Generally we try to push customers towards the more standard 1 stub/ 1 check. 2 Stub checks are really not necessary any more and they create a storage nightmare.
If you are set on accomplishing this, look at using some dynamic code within SSRS to push the sizes of rectangles around based on how many lines you have in a check.
Also you might be better off doing 2 stubs and check at the bottom.
---
## Post #4 by @Alex
Could you please explain me what does the code have to perform in order to do this?
---
## Post #5 by @Alex
i tried that and it didnt works but thanks
---
## Post #6 by @josecgomez
Also alex I see you posted this in E9 section. are you in E9? If so I highly discourage you from converting stuff to SSRS in E9 with the hopes it will translate to E10... (it won't..)
---
## Post #7 by @Alex
I am sorry i am converting all crystal reports to SSRS because we are moving to 10.1
---
## Post #8 by @josecgomez
ok, but you are doing to conversion on your 10.1 SSRS DB NOT your E9 SSRS right?
---
## Post #9 by @Alex
exactly i am converting in 10.1
---
## Post #10 by @Alex
when i did that, i had a problem. When accounting print a batch of checks the check shows op starting in the last page for example the invoices in the table for 5 invoices show up from page 1 to 5 and the check from page 5 to 10 how can i make the check to show from page 1 to -5 with the table
---
## Post #11 by @bmgarver
Are you getting the (2) tables to display on the same page as wanted? If
so, try eliminating the second rectangle and placing the check detail
fields in the second table in the top row. Also, check your page breaks
for each group. I had to do quite a bit of trial and error to get the page
breaks and alignment right, after figuring out how to get the same table
twice on the same page.
Thanks,
Brian M. Garver
Northern Concrete Pipe, Inc.
---
## Post #12 by @Alex
i have no page brake i can make both table show but in the same way the check is showing like i explained before.
would you mind to send me your RDL file (with out any important information of course) so i can fill it out with my info
---
## Post #13 by @bmgarver
Ours is slightly different because it is check, table, table. So our check
detail is in the report header with duplicating tables in the body.
Hopefully this will help.
Thanks,
Brian M. Garver
Northern Concrete Pipe, Inc.
ChkPrint.rdl (127.5 KB)
---
## Post #14 by @Alex
I can still use it i figure it out how to put the check in the middle i just need to duplicate the table
---
## Post #15 by @Alex
thank you so much for sharing the file
---
## Post #16 by @Alex
thanks it is working i just have a concern what will happen when there is like 20 lines the lines will overlap?
---
## Post #17 by @bmgarver
You set the number of invoices you want per table in Bank Account Maintenance.
If the number of invoices exceeds this, it will automatically void the next check number and continue the detail on the following check.
---
## Post #18 by @Jim_Lutz
Please mark the solution if a user has solved the issue.
---
## Post #19 by @Alex
you can try but after work in the solution of BMgarver it wasnt a good option for my company
---
## Post #20 by @Jim_Lutz
Have you found a solution? Posting will help others if they have the same question. Otherwise, does anyone else have a possible solution?
---
## Post #21 by @Alex
not yet will keep using CR for now as soon as i found something i will post
---
## Post #22 by @jhecker
[quote="bmgarver, post:13, topic:35706, full:true"]
Ours is slightly different because it is check, table, table. So our check
detail is in the report header with duplicating tables in the body.
Hopefully this will help.
Thanks,
Brian M. Garver
Northern Concrete Pipe, Inc.
ChkPrint.rdl (127.5 KB)
[/quote]
@bmgarver - Thank you for sharing that RDL. I just started working on my 3 Section Check for SSRS, and I learned quickly that the SSRS 2016 Report Builder is quite lacking compared to Crystal Reports...I struggled for quite a few hours to get something like this working, and then I decided to start googling around. As it turns out, I should have googled first. Just a little bit of tweaking required of the formatting, and your RDL will work perfectly for us. Thank you again :slight_smile:
---
## Post #23 by @ale_arevalo
[quote="jhecker, post:22, topic:35706"]
have googled first. Just a little bit of tweaking required of the formatting, and your RDL will work perfectly for us. Thank you again :slight_smile:
[/quote]
I have a similar report but the problem comes when the details don't fit on 1 page, the customer wants to see the following pages with the continuation of the first section in the middle and the continuation of the 2nd section at the bottom. Has anyone been able to accomplish this? Thank you!
---
## Post #24 by @Paul_Mayevsky
I've had this same request for dual stub checks over the last few years. After much research and countless hours of effort I found that it is possible to do a stub, stub, check layout and have the paging work correctly. This report is quite difficult to work with and I've invested significant amount of time on this... more time than any return. Experience is a good thing though.
I'm hoping to put a video together soon to demonstrate how things are linked in the report to properly work. The key is to use subreports for the stub details and to use proper linking to prevent mixing up invoices to detail records.
---
## Post #25 by @Vinaykamboj
We have dual stub checks as stub, check, stub. It is in crystal reports. I think I posted it on the forum long ago. In case it is needed let me know. Never bothered to convert it to SSRS, not worth the effort. As a rule we do only EFT, with very few checks.
Vinay Kamboj
---
## Post #26 by @tpynepeak
Thank you @bmgarver, this is over 80% of what I need.
Just having the pay to at the top and the tables duplicated below makes a very difficult project manageable.
---
**Canonical:** https://www.epiusers.help/t/3-section-check/35706
**Original content:** https://www.epiusers.help/t/3-section-check/35706