| Author |
Topic |
|
Debo
Starting Member
6 Posts |
 Posted - 2011-08-04 : 00:20:42
|
I need help real fast due to several deadlines at work. I am using Microsoft Reporting Services 2008, and I have a problem with a feature in the tablix property 'Keep together on one page if possible'. I have selected this option but yet the data in this table seperates between pages. Is this a bug or do I need to do somthing else in order to keep the tablix data from splitting on different pages? Please help for I have run out of ideas.Thanks for your help in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-04 : 09:15:25
|
| you've not given any more info. have you applied some grouping? have you checked put a page break property for thr group? whats the typical number of rows report returning? is it happening in report viewer as well or only when exporting to pdf,excel etc?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Debo
Starting Member
6 Posts |
Posted - 2011-08-04 : 11:14:00
|
| Specs for the tablix:- I grouped the tablix by order number. The data has nine rows of data normally, however, I have a subreport in the tablix that can include from one to three rows of data. The max of rows including the sub report would be 11 rows.- I did check the properties for the tablix to 'Keep together on one page if possible' and 'Add a page break before'. I do have another table above this tablix but it prints on the first page as it should ---- no problems.- When I generate this report and put it in the 'Print Layout", it splits the data on different pages. It does the same when I export it to pdf.Hope you can help me out.Thanks, Deborah |
|
|
|
Debo
Starting Member
6 Posts |
Posted - 2011-08-04 : 11:15:47
|
[quote]Originally posted by visakh16
you've not given any more info. have you applied some grouping? have you checked put a page break property for thr group? whats the typical number of rows report returning? is it happening in report viewer as well or only when exporting to pdf,excel etc?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/Specs for the tablix:- I grouped the tablix by order number. The data has nine rows of data normally, however, I have a subreport in the tablix that can include from one to three rows of data. The max of rows including the sub report would be 11 rows.- I did check the properties for the tablix to 'Keep together on one page if possible' and 'Add a page break before'. I do have another table above this tablix but it prints on the first page as it should ---- no problems.- When I generate this report and put it in the 'Print Layout", it splits the data on different pages. It does the same when I export it to pdf.Hope you can help me out.Thanks, Deborah |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-04 : 13:12:22
|
| is the report data itself spanning for over a page when compared to pdf dimensions?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Debo
Starting Member
6 Posts |
Posted - 2011-08-04 : 17:19:58
|
[quote]Originally posted by visakh16
is the report data itself spanning for over a page when compared to pdf dimensions?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/The pdf is the same as the Print Layout. It is splitting the tablix data between pages and we would like to keep the data in the tablix on one page. An example is that we could have four orders (tablix per order) on one page, but we do not want the last tablix data to split between pages. Even if the page is cut short it does not matter as long as each tablix data is on one page. I sure hope you can figure this one out for me. I did not have this problem in MRS 2005.Thanks again, Deborah |
|
|
|
Debo
Starting Member
6 Posts |
Posted - 2011-08-09 : 16:50:59
|
quote:
Originally posted by Debo
[quote]Originally posted by visakh16
is the report data itself spanning for over a page when compared to pdf dimensions?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/The pdf is the same as the Print Layout. It is splitting the tablix data between pages and we would like to keep the data in the tablix on one page. An example is that we could have four orders (tablix per order) on one page, but we do not want the last tablix data to split between pages. Even if the page is cut short it does not matter as long as each tablix data is on one page. I sure hope you can figure this one out for me. I did not have this problem in MRS 2005.Thanks again, Deborah
|
|
|
|
Debo
Starting Member
6 Posts |
Posted - 2011-08-09 : 16:53:00
|
 OK, I found a solution and it is not a bug.This is not a bug but in fact a design oversight. The report is not fully configured to prevent the split among rows. There are still a few settings that must be selected to make the report act the way you expect / want it.The tablix was set properly However, the RECTANGLE also needs to be set. You can do this by clicking in the white space of a cell and select rectangle properties. This will prevent the cell from splitting. Finally an answer!! Debo |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-10 : 07:58:24
|
| oh. I never specified that tablix is inside a rectangle and you also didnt specify. Anyways glad that finally you got on top of it and got it sorted------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
rayabharapusuman
Starting Member
1 Post |
Posted - 2011-08-26 : 09:06:26
|
| Hi all,I have tablix in my reports(sub reports) and i have set keep Together on one page if possible to true, this works well on PDF/Report viewer but not on Word export which is causing problems of extra unnecessary space in word document 2007 2010. i am using VS 2010 Microsoft Reporting and Local mode.Please let me know if you have any solution for this issues. |
|
|
|
|
'Keeping together on one page if possible' option