How do you get records from one dataset to display at 4 corners of a landscape page? [SSRS]

Question

I am using Microsoft SQL Server Reporting Services 2005

I have a report that when printing I want to display a record in each of the 4 corners of the landscape page.

I use one dataset that returns 1 in many records.

How to do this with a table or matrix?

For example, if I had 6 records in my data set:

Page 1

|---------------------| | record 1 | record 2 | |---------------------| | record 3 | record 4 | |---------------------| 

Page 2

 |---------------------| | record 5 | record 6 | |---------------------| | [empty] | [empty] | |---------------------| 

Answer 1

So, I found a successful way to do this (using the cdonner clause), have 2 identical table templates and display all the odd records, and the other show all the even records.

Here's what the design mode looks like:

 |-------------------| | table 1 | table 2 | |-------------------| 

Then, what I did was on each tab of each table, adding expressions to the Visibility> Hidden value of tablerow property :

For even lines:

 =RowNumber(Nothing) Mod 2 = 0 

For even lines:

 =RowNumber(Nothing) Mod 2 = 1 

Answer 2

The only way I can think of is to use subscriptions, one of which shows all the even lines and the other all all the odd lines.

Answer 3

To add groups to Jon's answer, put tables 1 and 2 in the parent table that performs the grouping:

 table-parent group-row-header // header text..? group-row-footer // group name is important for below rectangle table-child-1 | table-child-2 | etc // =RowNumber("my-group-name") 

Note. The row of RowNumber must be based on the group so that it is reset with each cycle.