Post reply

Table Visibility Option

  • November 18, 2010 at 2:47 pm

    #231417

    Hello,

    I have three tables that display three different sets of campaign data. I have an "ALL" then Campaign1 and Campaign2 parameters.

    I would like to set the visibility to HIDDEN on every other table based on the parameter. The default parameter is ALL, so initially when the report loads, it displays all three tables with breaks under each table (3 tabs).

    I have a conditional statement that looks like this set on every table:

    =IIF(Parameters!Campaign.Value = Campaign1, True, False)

    This works, but unfortunately the "place holder" for the table remains displayed without a table and just a blank page. So my final report always has a blank page which i want to remove with the table that is not being displayed. Is this possible or the visibility property renders and just hides it and that is the reason the blank page always displays even though there is no data being displayed.

    Thanks

    R.

  • November 22, 2010 at 11:06 am

    #1253904

    Hi Renzo,

    As per my knowledge, in SSRS the table visibility and page break wont work together...

    One option is what you have tried, but as you saw it will give you blank page. Another option is you can give visibility to the table's header,detail and footer section (I mean separately for each row), but in this case it will work fine in the preview but when you export to excel, it will give you a blank page.!!!

    So one option you can give a try is, keep a text box between the tables (keep its size as small as possible), then give page break on that object.

    Let me know how you go with this.

    Thanks & Regards,
    MC

  • November 22, 2010 at 11:16 pm

    #1254187

    Sorry ,

    One small correct, use any object which has got page break property(text box doesn't have this), use can use rectangle or matrix

    Thanks & Regards,
    MC

  • November 23, 2010 at 5:53 am

    #1254376

    Have you tried putting the table within a rectangle?

  • November 23, 2010 at 10:05 am

    #1254569

    Tried both options and they still show weird blank pages at the beginning of the second parameter visibility option. Doesn't seem to be working no matter what I do.

  • November 23, 2010 at 10:10 am

    #1254579

    hi

    Could you please make sure that you have done it as below:

    1) Place a rectangle between the tables.

    2) Put Page break to the rectangle.

    3) Made the size of the rectangle as small as possible.

    4) Applied visibility condition on tables.

    5) Make sure no page break to the table , should give only to the rectangle.

    For me this option is working....

    Thanks & Regards,
    MC

  • November 23, 2010 at 10:38 am

    #1254598

    I followed step by step what you suggested and seems to be working great when the parameters are picked but I also have an "ALL" parameter which should show ALL tables but for some reason the two tables are showing on the first page when published without the page break for some reason. Any ideas why?

    Thanks so much!

    R.

  • November 23, 2010 at 8:02 pm

    #1254865

    Hi,

    I don't see any other reason, because as you followed the steps now the page break is with rectangle which you placed between the tables, so it is irrespective of the paramater value...

    Please make sure that there is no page break on the tables also cross check the visibility conditions.

    Thanks & Regards,
    MC

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply