Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Report header items (dynamic) do not appear on subsequent pages using a list object.

Yanıt Report header items (dynamic) do not appear on subsequent pages using a list object.

  • Tuesday, February 05, 2013 11:42 PM
     
     
    Sign In to Vote
    0

    In my report I have a List with 3 textboxes being used to reference ReportItems from the dataset.

    When the data in the List carries forward to a second page, the ReportItems do not display data in the header.

    I understood that the List contains a rectangle and that the items inside were treated similarly to textboxes within a Tablix. When a tablix has data spanning multiple pages, the ReportItems reoccur with each page.

    This is causing a logistical nightmare trying to place the textboxes in a way that they can be used with all pages spawned by the List.

    Any suggestions?


     

All Replies

  • Thursday, February 07, 2013 6:02 AM
    Moderator
     
     Answered
    Sign In to Vote
    1

    Hi GaryT-SWRE,

    In Reporting Services, the list data region repeats with each group or row in the report dataset. If the referenced report item in the page header doesn’t display on the subsequent pages that a group expands to, it may occur if the report item you referenced doesn’t appear on the subsequent pages. For example, in the following screenshot, the textbox in the page header references the CalendarYear report item, however, when the tablix within in the list expands to multiple pages, the CalenarYear textbox within the list doesn’t repeat on subsquents pages. In this condition, the textbox in the page header won’t display either on the subsquents pages until a new instance of the SalesTerritoryGroup begins (the list groups on the SalesTerritoryGroup field too):

    Generally, when we reference the report items that are in a list, we also add page breaks to the row group of the list.

    Reference:
    Adding a List (Reporting Services)

    Hope this helps.

    Regards,

    Mike Yin
    TechNet Community Support

    • Marked As Answer by GaryT_Musicman Wednesday, April 10, 2013 8:01 PM
    •  
     
  • Thursday, February 07, 2013 3:15 PM
     
     
    Sign In to Vote
    0

    Mike,

    This defines my problem exactly.

    I have two Image objects  toggling visibility in the header based on textboxes (ReportItems) in the List, one inside a textbox at the top of the List, and one inside the tablix. This would work well if not for two additional tablixes that are also conditional (may or may not contain data). Beyond the first page of the report (a summary page)m the remaining tablixes could all be anywhere from zero to many pages in length.

    For that reason, I cannot use Globals!PageNumber to determine which header Image to make visible. I tried creating a seperate header Image for each of the tablixes, but cannot figure out the best way to determine how to handle visibility. It would be ideal if there were something similar to Visual Basic's setfocus that I could point to to determine which tablix is being displayed.

    Is there a property that I can set with an expression to accomplish this?

    Thanks!