Variable Address Line Items

Stimulsoft Reports.NET discussion
Post Reply
PBron
Posts: 2
Joined: Tue Oct 18, 2016 5:51 pm

Variable Address Line Items

Post by PBron »

I want to print addresses in a form. Some addresses have two address lines but most only one address line. I want Stimulsoft to not create a blank line if address field 2 is null but instead to print City, State and Zip (these three are all different fields), then on the next line if address 2 is null I want Stimulsoft not to print City, State and Zip. I do great using the IIF for just one field (column) item but I seem unable to get it to work for the three required fields. I have tried a number of functions but the issue seems to be the need to have City, State and Zip print together on one line. This is such a simple thing in other programs of this type... what am I missing with Stimulsoft?
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Variable Address Line Items

Post by HighAley »

Hello.

Please, send us your report template with sample data that reproduces the issue and we will suggest a solution.

Thank you.
PBron
Posts: 2
Joined: Tue Oct 18, 2016 5:51 pm

Re: Variable Address Line Items

Post by PBron »

I cannot send you data and the form but here is what I am looking to do: I am printing payroll checks. Each check needs to be addressed to the employee:

Employee 1 address is
Addr1: 111 Enterprise Road
Addr2: (blank)
City: Tyler
State: Texas
Zip: 75745

Employee 2:
Addr1: 1234 Maple Dr.
Addr2: PO Box 555
City: Tyler
State: Texas
Zip: 75745

On the checks I want the address for the first person to print out looking like this:

111 Enterprise Road
Tyler, Texas 75745

On the second check in the sequence I want the address to print out looking like this:
1234 Maple Dr.
PO Box 555
Tyler, Texas 75745
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Variable Address Line Items

Post by HighAley »

Hello.

Please, look at the attached report template.
You should set the Can Shrink properties of the text components and data band to True.
Also you should set the Shift Mode of the text components to Increasing Size, Decreasing Size.

Thank you.
Attachments
Book1.csv
(113 Bytes) Downloaded 167 times
report.mrt
(6.82 KiB) Downloaded 244 times
Post Reply