Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 ssrs 2008 tablix show be invisible
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

52 Posts

Posted - 05/05/2014 :  18:05:46  Show Profile  Reply with Quote
In an SSRS 2008 r2 report, I have an existing report that if the grade level is from 01 to 03, one tablix is displayed. If the grade level > 03, the other tablix is displayed.

Now in the tablix for grade levels 01 through 03, I have placed several rectangles onto the tablix for better control of some new textboxes. I have set the property of some of the new textboxes so can not grow and can not shrink. I have not yet placed rectangles onto the tablix for grade levels > 03.

Currently when I run the report for grade level 04, the tablix for grade levels 01 to 03 does not display. However there is a blank space on the SSRS report where grade levels 01 to 03 would display.

The tablix for grade level 04 does display.

Thus can you tell me what what to check on so the blank space for where tablix for grades 01 to 03 does not display when I want to generate the report for grade 04?

Flowing Fount of Yak Knowledge

2780 Posts

Posted - 05/06/2014 :  08:02:44  Show Profile  Reply with Quote
You can't. The space occupied by rectangles is left in the report, even if the rectangle is set to invisible.
Go to Top of Page

Constraint Violating Yak Guru

332 Posts

Posted - 05/06/2014 :  12:27:52  Show Profile  Reply with Quote
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000