Sage 100

How to do a Crystal Report formula to print Item labels for the Quantity on hand. I know there is a way with ""For...While...Do..."" loops to have a crystal report create additional detail lines for an item based on a number, such as quantity on hand. i.e. printing item labels. I want to do something similar to that to print out a line for each serial number value in a UDF field, separated by commas. But I'm not familiar with how to do the loop formulas, and none of the examples i see on google show me what I need. Anyone out there have an example of using a crystal loop formula that might help me? Thanks,

Send you an email with a sample @DanBurleson sent to me once

Thanks @BethBoswers for the sample report from @DanBurleson. Ufrotunately, that doesn't address the ""For... While.. Do..."" loop logic I'm looking for. There might be up to 500 serial numbers on one S/O Invoice line UDF. So I need logic that can automatically print additional detail lines based on a qty number value.

Actually, it does do that. You point it to a file that will always have more records than you need, and you suppress once it's higher than the number you want to print.

Since Crystal output is triggered by detail lines I don't know how a simple For While Do loop would help unless you had a detail section for all possible 500 labels. Here's another explanation about how to do this using Excel instead of a MAS table. http://sagecity.na.sage.com/support_communities/sage100_erp/f/94/p/34867/119377.aspx#119377

I found this one . it is for V8 but still should work fine.

I did this once (about 10 years ago) with an additional table from an Excel spreadsheet that had 1000 lines with one field numbered 1 to 1000 and used a less than join on Qty on Hand to create a record for each line. No looping required. We used it to print out mfg bar codes for our inventory.

Actually it was less than or equal to join, but you get the picture. :) Let me know if you need help with the specifics.

Thanks @BarbaraOlson, I'm currently trying a similar approach with simply adding 100 detail sections and doing conditional suppression. So far this is working.

My method requires just 1 detail section with no conditional suppression and will make the report manageable in the future for upgrades, field changes, etc. Was throwing together a quick mock report to attach.

Here's an example just using a text file that can be dropped in the C:\ directory. If you use it on ABC some TotalQtyOnHand values exceed 1000 which is the max I did in Qty.txt, however if you refresh and run it and go to the last record and start scrolling back you'll see what's happening.

@BarbaraOlson Such simplicity is just beautiful!

Thanks @DanBurleson :)

OMG, that's amazing @BarbaraOlson !!!

Thank you @ThereseLogeais

@BarbaraOlson, you ROCK! I didn't think I could use your ""little work around"" since I have to use a split formula to parse out serial numbers stored in a line UDF. The split function requires you which interval in the array you want to split out. Then I realized that the number in the text file works to identify which interval to split. I made the selection criteria that the external file record number <= the formula for number of serial numbers in the UDF (using an instring type of logic to count the number commas separating the serial numbers) NOW I DON'T HAVE TO CREATE 1,000 DETAIL SECTIONS WITH INDIVIDUAL FORMULAS! - THANK YOU VERY MUCH :) I live in a neighborhood full of Swedes, so they will be happy to know my help came from an Olson that ends in ""on"" :)

@ClarkWalliser You are very welcome! Glad you were able to use it, since lots of detail lines would have been painful. It seems everyone up here in Grand Forks is Scandinavian or Polish descent. In our case my husband is Swedish and Norwegian, the ""on"" coming from the Norse side. My daughter's name is Kirsten though, Swedish pronunciation. Probably more than you needed to know :D

Being a resident alien (I'm German descent) in my neighborhood, I come across the Norwegian (what's with the compound names?) and Danish mixtures in the area. They like to complain about each other, until I make some Scandinavian comment :)

Not sure what you mean by compound names, we don't see too many around here. And yes I hear a lot of mocking based on ethnicity around here ""Swedish stubbornness"" or ""bull-headed Norwegian"", especially at large gatherings of older generations. It all boils down to the same thing. It's kind of funny. I'm a transplant myself and don't really get it.