Need SSRS Report row height fixed irrespective of child entity grouping data

(0) Share

Report

Posted on by DDaniels

I have a SSRS report. It is running on the parent entity and also displays data from the child entity(Parent:Child:1:N).

I have a matrix in my report.

The matrix is grouping based on a field called Version in the child entity. The other column in the matrix is quantity. Based on the version, quantity is decided. For example, if I have child data like this:

Record -1: Version:1.0; Quantity - 5

R-2: Version 1.1: Quantity - 3

R-3: Version 1.1: Quantity - 2

R-4: Version 1.0: Quantity - 7

R-5: Version 1.0: Quantity - 10

R-6: Version 1.0: Quantity - 4

Right now, for the above data my matrix looks like this:

Version	Quantity
1.0	26



1.1	5

Basically, the row height is getting determined based on the number of rows of data used to group in that version. (The empty rows in the table is basically blank space. The row height is different for 1.0 and 1.1). I need the row height to be fixed. It needs to look like this:

Version	Quantity
1.0	26
1.1	5

Please help.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Nya 29,060 on at

Like (0)

Report

RE: Need SSRS Report row height fixed irrespective of child entity grouping data

Hi,

Here is an documentation about how to change row height:

Change Row Height or Column Width (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Docs

If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

Best Regards,

Nya

Was this reply helpful? Yes No