This is a custom pro-forma invoice, basically. The ship-to address fields are in a parent group-header of the data. Naturally, many fields are often blank, like Contact or Address2. I set them all to CanShrink. OK so far. [image] When I do this, the report crunches the address, but not the row (t…

Stick it in a single field together.

[image] JasonMcD: I can never seem to select the row; it always selects Rectangle2 instead. After selecting any control in the row, select the row “grip” to the left of the tablix [image] Also, there was a recent thread on replacing those individual boxes with single textbox that combines …

[image] JasonMcD: So what do others do? Well, Epicor does the “shrink” in the RDD and just passes a string with the blanks removed. It also formats the address based on the entities address-format or the default country format. So you can do it there. Or… You could create a report function …

Regarding the “CanShrink” … Here’s a quick test of a SSRS report with various nested controls and settings. [image] And the result: [image] Fun Fact: Those Datamatrix Barcodes were generated with VB code in the Report. No DLL or additions to the server required! Potentially useful for SaaS…

I never use CanShrink. I always make a single textbox with CanGrow. For address fields, I write a longer expression that splits the address by tilde an if there is a value for a line, then show it (think “cascading IIF”).

I think you all said the same basic thing, but I gave Clint “the solution” for brevity. I do appreciate everyone’s more elaborate responses, too. I was hoping there was something easy I was missing, but all signs pointed to the same thing. Basically, it seems that the standard ways of making a repo…

Looks like this discussion. [image] Resizing Address Tablix Box ERP 10 I have modified the purchase order report. I would like to shorten the tablix that holds the information. However I can’t seem to adjust the height. I have an inch of free space. Any ideas anyone? …

SSRS - Shrink the Ship-to row

Off Topic

Michael_Ramsey (Michael Ramsey) October 20, 2020, 12:25pm 8

Looks like this discussion.

Topic		Replies	Views
Resizing Address Tablix Box Epicor ERP 10 ssrs	19	3010	October 6, 2020
SSRS: can grow / can shrink Epicor ERP 10 ssrs	18	9482	April 9, 2019
SSRS help: field printing intermittently on Quote form Epicor ERP 10 ssrs	4	889	January 7, 2019
Can you dynamically resize the header in SSRS? Epicor ERP 10	4	4934	October 9, 2017
Keeping Purchase Order Together on Fewer Pages Kinetic ERP e10 , ssrs , reports	11	1304	March 6, 2023

SSRS - Shrink the Ship-to row

Related topics