topic Re: Relative Positioning on Shapes Changing Based on Resolution in Report Server

Relative Positioning on Shapes Changing Based on Resolution

Anonymous — Wed, 15 Sep 2021 22:14:55 GMT

I'm trying to create a sort of dynamic PNL using the basic matrix visualization. The issue is that I want subtotals for each of the bolded catergories, and then a grand total (Net Income). I've created a matrix that functions properly, but there are extra lines of data that repeat catergory sums. In order to negate this issue, I placed grey shapes over the unwanted rows to hide them. The issue is that when I view the report on screens of different resolutions, the shapes move slightly. This movement will cause the shapes to be covering the wrong rows of data.

Is there any way to either A) lock the shapes in place relative to the matrix or B) insert custom subtotal rows in a matrix?

Attached is a screenshot of the first column of this matrix, with the shapes in place below "Total Utilities" and "Taxes & Insurance"

Re: Relative Positioning on Shapes Changing Based on Resolution

Icey — Mon, 20 Sep 2021 09:51:06 GMT

Hi Anonymous ,

How about hiding unused rows based on expression and Visibility section? And here is an example: How to Hide Unused Rows in a Tablix | Ask Garth.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Relative Positioning on Shapes Changing Based on Resolution

Icey — Tue, 28 Sep 2021 07:35:58 GMT

Hi Anonymous ,

Can this meet your requirements?

Best Regards,

Icey

Re: Relative Positioning on Shapes Changing Based on Resolution

Anonymous — Wed, 29 Sep 2021 15:20:18 GMT

The way it is currently organized, no. The problem is that the individual items are grouped into different categories as follows:

1. NOI

2.CNOI

1.EGI

2.Controllable Expenses

2. (Blank)

3. Non-Controllable Expenses

2.(Blank)

2. (Blank)

4. Non-operating Expenses

It is organized as such because of the specific subtotals that I need included. I want to get rid of all of the rows that say (blank) but still keep their place in the hierarchy.