Sage 100

Crystal Reports XI, Sales Order Invoices (Sage 100 4.50) The customer sells serialized inventory and the serial numbers are sequential by item. The default form prints each serial number shipped (which can make an invoice many pages long). I created a formula to print just the first and last serial numbers i.e., Minimum(Serial) & Maximum(Serial) and placed it in a subreport in section Details M, linked by invoice number and header sequence. The first and last serial number prints correctly, but repeats for the quantity shipped (so you'll see six lines of the same info if you shipped qty 6). I've moved the formula in the subreport around from a details, group and footer section and still get this repeating range. Setting the ""suppress duplicates"" suppresses all and then nothing prints. Any ideas?

Did you have it in the lot/serial details section? I would delete (or suppress) that section then insert your subreport in a new details section. I don't have the form in front of me but shouldn't you also be linking the line to subreport somehow? Also, format the section to suppress blank section.

Thanks @ThereseLogeais I actually have moved it to it's own details section as a test too, but I'll try it again with the format for the section to suppress blanks. When I link the subreport to a line (line seq for example) it repeats not just for qty but also repeats the section that many times too, so if you ship 6 you'll get 6 lines repeated six times.

@MoiraGoggin - We just upgraded a client from v3.7 1 to v4.5. We modified all of applicable forms to print the SN's horizontally, 7 SN's to a line. Let me know if this might help you.

Thanks @JeffSchwenk, are your referring to, using the multi column feature of the details section? That would work if the shipments were in qty of 100 or less, but this client ships in the 1,000 and 10,000s so that's why I wanted just the first and last serial number in the range. If that's not what you meant, then it would be great to have a new idea! @ThereseLogeais tried your suggetions, and I'm still getting a line of the starting and ending serial numbers equal to the qty being shipped. I also tried using the running total summary by min and then by max and dropping the subreport. Still get the repeats equal to the number being shipped. It's just weird, why do serials repeat but the item detail section doesn't print the item six times if you ship six!

Not sure what the multi column feature is. Maybe you have something new for me!

Maybe - here's what I learned, the details section (not a sub-details section) can be formatted to print multi-cloumn. From the section expert for the details section, select the ""multi cloumn"" checkbox. A new tab displays to allow you to set column widths and gaps. This allows the lot/serial numbers for example to be printed left to right or top to bottom in columns. Handy for printing labels and also if you want columns of lot/serial numbers.

Try this with your min/max thought Moira - insert a group for item code then insert your min/max subreport or actual summaries in that group footer. (Suppress the lot/serial detail section.) Hide the group header as well.

Do you have the min/max printing in the Details section of the SUBREPORT? If so, move to Report Footer in the SUBREPORT

Thanks to @ThereseLogeais and @BethBowers the combination of your suggestions worked beautifully ladies! So, created two groups in the main report, by item and also by line no. to keep lines in order. Then created a subreport with a formula minimum(lotserialno) & "" to "" & maximum(lotserialno) and added to the Report Footer of the subreport, supressing all other sections. Linked the subreport by invoice no., header seq, and line number. Inserted the subreport in the plneno report group footer of the main report.

@JeffSchwenk, your post is only from 3.5 years ago, but do you recall how you got the serial #'s to print horizontally? Thanks.

I just need to print the first serial number and the last serial number, not all the other in between. The first and last printed horizontal, as recall. Did you try what I listed above your post?

@BrettZimmerman How about formatting a sub report with multi-columns?

@DanBurleson hit it on the head. Attached is the report that was used.

Thanks, all. I was close. Yesterday I had tried using the 'Format with multiple columns' setting, but I think i neglected to set the detail size and gap. Got it working now.

When printing the serial #'s horizontally via a Subreport, the space where you'd expect the first serial # to print is blank/empty. Is there a way to prevent this initial blank space?

Attached, per my prior post. Is there a way to prevent the initial blank spaces (highlighted)

Did you add {SO_InvoiceWrk.LotSerialNo} <> """" to the record selection formula on the subreport?

Perfect, @MichaelNottoli!! Thx! That didn't even occur to me for some reason.