Is it possible to display one dataset in 2 tablix??

  • I have a report that displays different objects in first 2 pages. I need to set a fixed height for my first tablix on my first page and then display the rest of the records on the second page for my 2nd tablix. The reason I need to create 2 talbix is because I need to put some text under the first tablix in my first page.

    I cannot put it in my footer because the space occupied by my text is not shrinking so I have big space on my footer all throughout the report. Also making a single tablix will just kick my text towards the end of my report.

    Thanks in advance for your help and opinion.

  • Hi,

    An idea... Can you add a rownumber to the data set being returned by the query? If you could then you could put a filter on the first tablix of say rownumber <= 10 to display the first 10 records. And then a filter on the second tablix saying rownumber > 10 to display the rest of the records. This means you could restrict the first tablix to the number of records defined by you and therfore controlling it's size.

    I hope this helps.

    Regards

    Daniel

  • Thanks Daniel. This works. Just need a little workaround with the design .

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

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