New at this looking for solution

Stimulsoft Ultimate discussion
calvinisc
Posts: 13
Joined: Fri Oct 02, 2020 8:53 pm

New at this looking for solution

Post by calvinisc »

This is being used by another software to create reports for us.
I have tweaked the template to match what we need with one exception.
I need to know how to create basically an if/then option.
I have a field that if a product has a serial number, it creates a barcode & lists the serial number.
That is perfect, unless an item has no serial number. For that I want the barcode created to read the part number
since there is no serial for that item. Is this possible?
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: New at this looking for solution

Post by Lech Kulikowski »

Hello,

You can use the IIF() function from the Dictionary.

Thank you.
calvinisc
Posts: 13
Joined: Fri Oct 02, 2020 8:53 pm

Re: New at this looking for solution

Post by calvinisc »

I thought that may be it. I just do not know the commands well enough & the help file ...well doesnt help.
What I am trying to do is for it to check if there is a serial number. If there is a serial number, then print the number & unse that info to create a barcode.
(this part already works finr). Then If there is no serial number (trackby) then I want it to print the part number and use the part number to create the barcode.
calvinisc
Posts: 13
Joined: Fri Oct 02, 2020 8:53 pm

Re: New at this looking for solution

Post by calvinisc »

Let me see if I can simplify my request.
On a Packlist report, we use a barcode to show the serial number on units that have a serial number.
What I want to be able to do on items that do not have serial numbers, is use the part number instead to create the barcode.
This way, when the customer scans in the receiver, it will either give a serial number or part number.
Hopefully this is more clear.
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: New at this looking for solution

Post by Lech Kulikowski »

Hello,

You can use {IIF(serialNumber == "", partNumber, serialNumber)}

Thank you.
calvinisc
Posts: 13
Joined: Fri Oct 02, 2020 8:53 pm

Re: New at this looking for solution

Post by calvinisc »

Lech, Thank you. I will try this as soon as I get a chance. Hopefully this is it & one more thing off my list. You have been a great help.
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: New at this looking for solution

Post by Lech Kulikowski »

Hello

We are always glad to help you!

Thank you.
calvinisc
Posts: 13
Joined: Fri Oct 02, 2020 8:53 pm

Re: New at this looking for solution

Post by calvinisc »

Something still is not right.
It does return the serial number (TrackBy) if there is one.
I just cannot get it to read the Part number (item number) It just returns a blank as the barcode.


And after a few tweaks, I got it to read & return the part(item) number but not the serial (trackby).
I need it to either show serial(trackby) if there is one, OR part(item) number.
Lech Kulikowski
Posts: 6198
Joined: Tue Mar 20, 2018 5:34 am

Re: New at this looking for solution

Post by Lech Kulikowski »

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.
calvinisc
Posts: 13
Joined: Fri Oct 02, 2020 8:53 pm

Re: New at this looking for solution

Post by calvinisc »

Im attaching a report. The left column needs to be either part number or serial number. Once I have the right statement, I can apply it to the barcode.
Attachments
Packing Slip (29).pdf
(165.13 KiB) Downloaded 177 times
Post Reply