Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Welcome to my blog. I work as Database lead at Synaptic Digital. Hope you find some interesting stuff here.
Browse by Tags · View All
BRH 17
SQL Server 15
#SQL Server 11
#BI 10
#TSQL 8
TSQL 8
BI 7
SSRS 6
#SQLServer 6
SSRS 2008R2 5

Archive · View All
January 2011 6
December 2010 5
September 2012 4
May 2012 4
March 2011 4
November 2012 2
October 2012 2
January 2012 2
February 2011 2
November 2010 2

KeepTogether Tablix Property

Nov 30 2010 7:07AM by Chintak Chhapia   

KeepTogether Tablix Property Setting should be used with care. This can cause whole report to load in single page and your report builder or web application (Reportviewer Control) can become very very slow in rendering.

This property can be set as shown in below image:

As per MSDN link, Indicates the entire tablix (all repeated sections) should be kept together on one page if possible.

If you are rendering report in HTML, InteractiveHeight property controls soft page break and in case we are getting large number of records, this causes soft page break. By default this is set to 11 inch.

But, when we set KeepTogether on Tablix then InteraciveHeight property is ignored and SSRS renders all the records in single page. This can cause the application to become irresponsive over period of time till the rendering for all the records gets completed.

KeepTogether property also exists at group level, but it in almost every causes this will not cause harm as if we are implanting grouping, the data will be restricted. KeetTogather group property can be accessible as shown in below image:

Recently this thread has been posted on MSDN forums and this is inspiration for this post. 

In SSRS 2008 engine, enhancement was done for execution of report. Execution only happens for the requested page. By this setting, we are not able to get this benefit as we are rendering in a single page and in case of very big report, this can also impact other report's execution

Tags: BRH, TSQL, SQL Server, #SQLServer, BI, #BI, SSRS,


Chintak Chhapia
40 · 5% · 1457
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

4  Comments  

  • This property can be set as shown in below image:

    but I can't see any images?!

    commented on Dec 25 2010 10:54PM
    Jason Yousef
    152 · 1% · 319
  • Hi,

    I am able to view the image. Can you please recheck this?

    -Chintak

    commented on Dec 26 2010 10:03AM
    Chintak Chhapia
    40 · 5% · 1457
  • I have tablix in my reports and i have set keep Together on on page if possible, this works well on PDF/Report viewer but not on Word export which is causing problems of extra unnecessary space. Please let me know if you have any solution for this issues. I am not sure why this issue is coming up, all the margins are also correctly set.

    commented on Aug 26 2011 7:46AM
    rayabharapusuman
    2903 · 0% · 2
  • Hi Rayabharapusuman,

    This is the last option you should try. You should remove the un necessary whitespace from reports. To comment more on this issue, I will need to look at report defination. Also word renderer has some issues...

    Regards, Chintak.

    commented on Aug 26 2011 8:03AM
    Chintak Chhapia
    40 · 5% · 1457

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]