How to freeze the first three columns in a list report when scrolling to the right?
For a list report, what’s the technique to freeze certain columns when scrolling to the right? If a list contains 20 columns, it would be nice to have the ability to freeze the left most three columns when scrolling to the right.
Solution:
This can be achieved by creating 2 lists and arrange the layout so that they appear to be one list, then enable horizontal scroll bar for the second list.
Steps:
1. Create a blank report in Report Studio; put a table with 2 columns and 1 row to the report page
2. Put a Block object to each of the two table cells, and put a List to each of the blocks
3. Drag 3 query items to the first column (preferably one of those columns can be used to uniquely identify the row, to ensure the rows on both lists match)
4. Drag that unique column to the second list, and then add the other desired columns.
5. To enable scroll bar for the second list
a. Select the block and in the properties pane, select "Size and Overflow".
b. In the "Size and Overflow" window, set the desired dimensions of the block.
c. Select the "Always use scrollbars" radio button.
6. The Challenge now is to arrange the layout of those two table cells, blocks and lists so their rows are parallel. ie. Unlock the column header and modify the Size & Overflow properties
7. Final step, if necessary, the unique column can be now removed from the second list report (ie. use Box type: NONE property), but ensure that the rows still match.
Solution:
This can be achieved by creating 2 lists and arrange the layout so that they appear to be one list, then enable horizontal scroll bar for the second list.
Steps:
1. Create a blank report in Report Studio; put a table with 2 columns and 1 row to the report page
2. Put a Block object to each of the two table cells, and put a List to each of the blocks
3. Drag 3 query items to the first column (preferably one of those columns can be used to uniquely identify the row, to ensure the rows on both lists match)
4. Drag that unique column to the second list, and then add the other desired columns.
5. To enable scroll bar for the second list
a. Select the block and in the properties pane, select "Size and Overflow".
b. In the "Size and Overflow" window, set the desired dimensions of the block.
c. Select the "Always use scrollbars" radio button.
6. The Challenge now is to arrange the layout of those two table cells, blocks and lists so their rows are parallel. ie. Unlock the column header and modify the Size & Overflow properties
7. Final step, if necessary, the unique column can be now removed from the second list report (ie. use Box type: NONE property), but ensure that the rows still match.
Comments
Post a Comment