Forum Discussion
Sizing rows on Report Builder
I just decided to combine the managers into one row and then set the size of the box to how big i wanted it.
=JOIN(LOOKUPSET(Fields!Name.Value, Fields!Name.Value, Fields!Manager.Value, "DataSet1"), ", ")
BDolphin isn't each manager has a separate row? It should show an image of each row with the same size, sorry it is not clear what you are trying to achieve.
parry2k Technically yes each manager has a separate row but i have them grouped on FullName since I dont need to see the FullName twice if there are two managers. The pictures correspond to the FullName. It is possible for a person (fullname) to have two managers or have just one. I want the image to not be twice the size if the person has two managers.
I think you need to set the CanGrow property of the text box to False. Please see this link - https://docs.microsoft.com/en-us/sql/reporting-services/report-design/change-row-height-or-column-width-report-builder-and-ssrs?view=sql-server-ver15.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
