Variable Address Line Items
Variable Address Line Items
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?
Re: Variable Address Line Items
Hello.
Please, send us your report template with sample data that reproduces the issue and we will suggest a solution.
Thank you.
Please, send us your report template with sample data that reproduces the issue and we will suggest a solution.
Thank you.
Re: Variable Address Line Items
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
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
Re: Variable Address Line Items
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.
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