Hello,
I am modifying the ‘Print Cycle Count Sheet’ to both compress it and to get it to quit splitting the tablix box between two pages. It is confusing to the employees when the information is at the bottom of a page and the part you fill in is on the top of the next page.
We’ve had similar issues with the MQR report where it’s splitting tablix like that. I’m not sure what we did to get it working (mostly) but I’ll see if I can find any notes.
Try to select the entire group of fields in SSRS Report Builder. In the bottom in Row Groups, right-click and select Group Properties. If you add a group criteria, I think it should do that along with selecting Keep Together = TRUE on the right panel.
I’m sorry, I have no idea what you are telling me to do. In the grouping pane there are already 2 groups: Group1 and Details
Do I need to select the Details group properties and change something?
I don’t have a good understanding of how groups work in this.
Please be more specific if possible.
I appreciate all answers.
Anything you can dig up will be appreciated!
Select the tablix with the data in it, then at the bottom group “Row Groups” right click Group1 and go to Group Properties
In the Properties Sheet, the default Group by is by Sheet Num.
I believe if you group by “tag num” then that should do what you want.
I cannot confirm this will work as we don’t have our cycle count information set up yet, but I think that would be the most likely fix.
The only other option I can think of would be to select the Details in Row Groups instead of Group1 and do the same edits.
When I changed the group1 to group on TagNum, it put 1 tag per page.
When I added to the Details Group, it made no difference.
I made sure the KeepTogether Property was true for both groups.
Any other ideas?
One last idea, there’s another place that has a “keep together option”
Highlight the tablix and right-click on the border to select Tablix Properties
Choose “Keep together on one page, if possible” in the page break options.
Unfortunately, it didn’t seem to matter either.
Any other ideas?
I truly appreciate you helping me with this. If I can nail this down, I think it is happening on other reports I can fix then.
I’m watching required training videos while I’m helping out. I have the basics of SSRS down, but I’m trying to learn it a bit better. I think I may have figured something out. It’s a bit tedious, but I think it’ll work.
If you take the first row in the Tablix and make it larger, you can take highlight the data in each subsequent row and move it up to the first. After you get all of them done, you can delete or shrink the extra rows. I can’t seem to get the spacing quite right for how it was before, but it might just take a little bit of tweaking.
Just to make sure I understand, You are saying to move all the data to one row?
I might be able to make that work in this case but not in some other reports.
For instance, the ARForm report is way to tedious to attempt that.
I know… I’ve been delaying moving all of my custom reports from Crystal over to SSRS because it’s such a pain to work with. The simplicity far outweighs the benefits of switching, but that’s just my opinion.
This is what the final tablix looks like, but the spacing is ridiculous. I was able to get the blank space to go away by setting the Serial Number and Lot Number text box fields to “Allow height to decrease” but that’s even more tedious than moving the rows around. Going to see if I can find some way to apply that property to multiple fields at once.
I went ahead and did it also. Here is what mine looks like.
What I wound up doing was copying the row visibility that each field came from and setting the object visibility to match.
So if you select barcodes, it shows and if you don’t, it shrinks and hides them.
Below is en example of both.
It will work in this case but would really like to know how to do it properly (If it can be done properly that is).
If I find out anything, I will try and post it back here for future reference.
Please do. I can’t believe they make it so tedious for what should be a simple option.
Best of luck to you!
OK,
I worked with an official Epicor Consultant and he said combine it all in 1 row…
Guess my workaround is the best answer. Pretty sad if you want to redo the AR Invoice form.
Thanks again to everyone who has helped me with this, I really appreciate it.
Shawn
