Sage 100

 View Only
  • 1.  Crystal 2011 and printing the Work Ticket Form (a/

    Posted 06-18-2015 13:45
    Crystal 2011 and printing the Work Ticket Form (a/k/a ""router"") - If you are familiar with Work Order you can relate Work Order to my problem. The client breaks up a total quantity to produce of an item based on the number of completed items that will fit in a bin. For example, they want to make 2400 in total of an item, but they break the run out into 4 runs of 600 each because 600 fit in a bin. They don't want to make 4 work tickets of 600 each - they just want to be able to produce 4 copies of one Work Ticket, and they want the number of copies to print be dynamically calculated based on the total number of runs (in this example 4 copies). They also want to have the copy number to print on the hardcopy - like 1 of 4, 2 of 4, 3 of 4, 4 of 4. I already have the formula in the form to calculate and round up to the next whole integer. Is there a ""number of copies"" command as well as a way to print the ""x of y"" copy # and number of runs on the copies? I've googled and researched everything I could think of and I really didn't come up with anything. The closest thing was to related to label printing and everything regarding that had to do with the form data all being in the Details section, which is not possible with


  • 2.  RE: Crystal 2011 and printing the Work Ticket Form (a/

    Posted 06-18-2015 14:44
    There is a ""Page n of m"" in the Special Formulas section of Crystal.


  • 3.  RE: Crystal 2011 and printing the Work Ticket Form (a/

    Posted 06-18-2015 15:46
    When not use Dispatch sheet printing?


  • 4.  RE: Crystal 2011 and printing the Work Ticket Form (a/

    Posted 06-18-2015 15:57
    @MoiraGoggin what is Dispatch Sheet printing?


  • 5.  RE: Crystal 2011 and printing the Work Ticket Form (a/

    Posted 06-18-2015 16:33
    Two options below Traveler is dispatch sheets. These provide a status column for steps completion percentage/status and may be another way to present the information for a large order in smaller portions.


  • 6.  RE: Crystal 2011 and printing the Work Ticket Form (a/

    Posted 06-19-2015 04:29
    I have something similar working with JobOps Work Tickets, for a client. Using a UDF Repeater table that just lists numbers from 1 to 100 and the field in the Work Ticket (Qty Ordered) tells us how many copies to print. Their is a repeat formula that repeats as many times as necessary to match the number of copies to print. Since your Number of copies would be a formula, I don't think you can link tables with a formula... I do have a document that explains how this can work but since our Qty to Print was in our data, I did not use this document. Let me email you my notes on how you might be able to make this work. Thanks @NicoleRonchetti


  • 7.  RE: Crystal 2011 and printing the Work Ticket Form (a/

    Posted 06-19-2015 05:45
    Could you use two running totals based on the formula


  • 8.  RE: Crystal 2011 and printing the Work Ticket Form (a/

    Posted 06-19-2015 05:48
    I know that the challenge is that the number of copies I need is based on a calculation at run time of the Crystal form, so therefore that number is not a stored field that I could link to a UDTable. I'm looking over that document you sent @MadelineStefanou


  • 9.  RE: Crystal 2011 and printing the Work Ticket Form (a/

    Posted 06-19-2015 05:49
    The first running total breaks on the formula (1,2,3,4) and the second breaks on the work order (4). Then use a text box with RT1 +"" of "" + RT2.


  • 10.  RE: Crystal 2011 and printing the Work Ticket Form (a/

    Posted 06-19-2015 06:31
    Just a thought, Can you use a UDI Work Ticket UDF field to store the number of work ticket copies you want to print? The user would have to do the math to calculate ""4"" using your example above. Then the repeater UDT would work.