cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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".

OffenderList.JPG

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper I
Helper I

Re: 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"), ", ")

 

View solution in original post

4 REPLIES 4
Highlighted
Super User IV
Super User IV

Re: Sizing rows on Report Builder

@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.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Helper I
Helper I

Re: Sizing rows on Report Builder

@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. 

Highlighted
Community Champion
Community Champion

Re: Sizing rows on Report Builder

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-wi....

 

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Highlighted
Helper I
Helper I

Re: 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"), ", ")

 

View solution in original post

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors