Headers Using List and Grouped Tablix

  • I have a "City" dataset with a cityname column and other detail columns. I also have a "State" dataset with both a statename and cityname columns and other detail columns. I have setup a List with the first row using an expression and Lookup function to put the statename in that column using cityname for lookup. For the second row I have inserted a tablix using the "City" dataset with a header row. I also have a group on the tablix using cityname and keep the grouping column to show all detail rows to single cityname row and delete the detail column.

    My problem arises when I save the report as a PDF and the "City" data exceeds a page length and continues on the next page. I cannot get the List first row to appear on the page and sometimes through a lot of trial and error I do get the tablix header to appear.

    I have tried so many combinations of "KeepTogether", "KeepWithGroup", and "RepeatOnNewPage" I can't remember them all. Additionally I have tried "RepeatRowHeaders" and "RepeatColumnHeaders" which are used for matrices even though I don't have a matrix.

    Any help would be greatly appreciated.

    Thanks,
    Rich

  • any chance you can combine the data in your data pull before you return it as a dataset? make it look the way you want, then retrieve it

    -------------------------------------------------------------------------------------------------------------------------------------
    Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

  • Already have sp's for datasets would prefer not to add third unless no other way is found.
    Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

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