SSRS Randomly Splitting Last Row onto New Page

%3CLINGO-SUB%20id%3D%22lingo-sub-829670%22%20slang%3D%22en-US%22%3ESSRS%20Randomly%20Splitting%20Last%20Row%20onto%20New%20Page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-829670%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20basic%20report%20with%20a%20Tablix%2C%201%20Group%20(2%20Group%20Header%2C%20Details%20(2)%2C%203%20Group%20Footers).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20run%20this%20report%20for%20random%20Transactions%20(in%20my%20case%20Purchase%20Orders)%2C%20some%20will%20print%20properly%20ie%20rows%20go%20to%20the%20bottom%20then%20continue%20on%20the%20next%20page%2C%20followed%20by%20the%20group%20footers%20(depending%20on%20line%20notes%20and%20text%20wrapping%20some%20print%2030%20items%20on%20page%201%2C%20some%2024%20etc.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20run%20the%20exact%20same%20report%20for%20another%20PO%20and%20it'll%20go%2017%20items%2C%20then%20%2318%20on%20second%20page%20followed%20by%20group%20footers%2C%20another%20PO%20will%20go%2023%20items%20then%20item%20%2324%20on%20page%202%20followed%20by%20group%20footers.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI've%20checked%20the%20data%20and%20there%20is%20nothing%20different%20between%20rows%20of%20data%20that%20split%20and%20those%20that%20do%20not.%26nbsp%3B%20It%20seems%20completely%20random.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20at%20a%20complete%20loss%20as%20running%20these%20types%20of%20reports%20in%20Crystal%20from%20the%20same%20data%20has%20zero%20issues.%26nbsp%3B%20I%20have%20nothing%20in%20the%20properties%20for%20page%20breaks%2C%20max%20records%20etc.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-829670%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EReporting%20Services%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-829678%22%20slang%3D%22en-US%22%3ERe%3A%20SSRS%20Randomly%20Splitting%20Last%20Row%20onto%20New%20Page%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-829678%22%20slang%3D%22en-US%22%3E%3CP%3EMore%20examples%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

I have a basic report with a Tablix, 1 Group (2 Group Header, Details (2), 3 Group Footers). 

 

If I run this report for random Transactions (in my case Purchase Orders), some will print properly ie rows go to the bottom then continue on the next page, followed by the group footers (depending on line notes and text wrapping some print 30 items on page 1, some 24 etc.  

 

I run the exact same report for another PO and it'll go 17 items, then #18 on second page followed by group footers, another PO will go 23 items then item #24 on page 2 followed by group footers.


I've checked the data and there is nothing different between rows of data that split and those that do not.  It seems completely random.  

 

I am at a complete loss as running these types of reports in Crystal from the same data has zero issues.  I have nothing in the properties for page breaks, max records etc.

1 Reply
Highlighted