Forum Discussion
Sizing rows on Report Builder
So I have a report that works appropriately I just cant figure out if there is a way to set the size of the image when some of the rows have 2 "managers".
Ideally I actually want the row size to be the size when there are two managers but if I set it that size then the rows where there are two managers becomes twice as big. I just want the images to be the same size down the entire column regardless of how many managers there are.
Any ideas?
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"), ", ")
4 Replies
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
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"), ", ")
