How to Display Multiple Rows of Data Side-by-Side in Bold Reports
In Bold Report Designer, displaying rows of data side-by-side can enhance the readability and presentation of your reports. This guide will walk you through the steps to achieve this using expressions within the properties of each row.
Implementation Steps to Display Two Rows Side-by-Side:
1. Access the Tablix Row:
Navigate to the design view where you can see the tablix containing the rows you want to modify, then select the advanced property.
2. Set the Hidden Property Expression:
On selecting the advanced properties, this will select the first row that you want to display side-by-side with another row. In the properties panel, select the Visibility property, and then click the expression editor icon (a small square) to set the expression.
3. Set Expression for the First Table Row:
Enter the following expression:
=IIF((RowNumber(Nothing) Mod 2) = 1, False, True)
Note: This expression checks if the row number is odd, the row will be displayed (True). Otherwise, if the row number is even, the row will be hidden (False). This enables alternating row visibility in reports.
4. Apply Expression to Second Table Row:
Select the second row you want to display side-by-side with the first row. Follow the same steps as before to access its properties. Set the Hidden property using the following expression:
=IIF((RowNumber(Nothing) Mod 2) = 0, False, True)
Note: This expression evaluates whether the row number is odd and sets the hidden property accordingly. If the row number is even, the row will be displayed (True). Otherwise, if the row number is odd, the row will be hidden (False).
5. Save and Preview:
After applying these settings to both rows, preview your report to ensure the desired outcome.
By applying the above steps within the row properties, you can effectively display two rows of data side-by-side in Bold Report Designer.
Extending to More Than Two Rows Side-by-Side
Display Three Rows Side-by-Side:
To display three rows side-by-side, add a third Tablix to the right and use Mod 3 expressions:
- 1st row (shows when remainder = 1):
=IIF((RowNumber(Nothing) Mod 3) = 1, False, True)
- 2nd row (shows when remainder = 2):
=IIF((RowNumber(Nothing) Mod 3) = 2, False, True)
- 3rd row (shows when remainder = 0):
=IIF((RowNumber(Nothing) Mod 3) = 0, False, True)
Display Four Rows Side-by-Side:
To display four rows side-by-side, you’ll have to use Mod 4 expressions:
- 1st row (shows when remainder = 1):
=IIF((RowNumber(Nothing) Mod 4) = 1, False, True)
- 2nd row (shows when remainder = 2):
=IIF((RowNumber(Nothing) Mod 4) = 2, False, True)
- 3rd row (shows when remainder = 3):
=IIF((RowNumber(Nothing) Mod 4) = 3, False, True)
- 4th row (shows when remainder = 0):
=IIF((RowNumber(Nothing) Mod 4) = 0, False, True)
Display Five Rows Side-by-Side:
To display five rows side-by-side, use Mod 5 expressions:
- 1st row (shows when remainder = 1):
=IIF((RowNumber(Nothing) Mod 5) = 1, False, True)
- 2nd row (shows when remainder = 2):
=IIF((RowNumber(Nothing) Mod 5) = 2, False, True)
- 3rd row (shows when remainder = 3):
=IIF((RowNumber(Nothing) Mod 5) = 3, False, True)
- 4th row (shows when remainder = 0):
=IIF((RowNumber(Nothing) Mod 5) = 4, False, True)
- 5th row (shows when remainder = 0):
=IIF((RowNumber(Nothing) Mod 5) = 0, False, True)
This approach enhances the visual appeal and readability of your reports, providing a more user-friendly experience for your audience. Experiment with different layouts and formatting options to further customize your reports according to your specific requirements.
By using multiple Tablix items with visibility expressions, you can effectively display rows side-by-side in Bold Report Designer, enhancing report usability. lore
For your reference, you can download the sample report here.
