SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


ssrs 2008 tablix should be invisible


ssrs 2008 tablix should be invisible

Author
Message
wendy elizabeth
wendy elizabeth
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3662 Visits: 824
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?
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: General Forum Members
Points: 62023 Visits: 13297
I think the work around is to put the textbox in a tablix and set the visibility of the tablix.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search