Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bslaast
  • Content: Threads
  • Order by date
  1. bslaast

    Repeat group on pages

    I have a shipping label that prints a label per part number shipped. A shipment may contain several lines of the same or different part numbers so I am grouping on part number and summing the quantity. The total quantity shipped may be more than a box can fit. What I need is to start a new...
  2. bslaast

    A running total cannot refer to a print time formula

    I am receiving the arror "A running total acnnot refer to print time formula" I want to get how many, the and how many days parts have been in inventory. I also want know break down the quantities and costs by <1 year in inventory, 2 years in inventory and 3+ years in inventory. I have am...
  3. bslaast

    Display 2 decimal places.

    I want to display 2 decmial places I currently have: LPAD(t.full_curr_amount,10,'0') t.full_curr_amount is a number.
  4. bslaast

    Display 2 decimal places

    I want to display 2 decmial places I currently have: LPAD(t.full_curr_amount,10,'0') t.full_curr_amount is a number.
  5. bslaast

    Display Current Date in mm/dd/yy format

    How can I display the current date formatted dd/mm/yy in a text box? I currently have: textbox.text = now() but that displays a date time format of dd/mm/yyyy hh:mm:ss
  6. bslaast

    Rolling 12 Months

    I need a formula to calculate a rolling 12 months. I have a number parameter where the user will enter a year/period number like 201008. That would be the first column and the next 11 columns would be 201007 201006 201005 201004 201003 201002 201001 201000 200912 200911 200910 200909 200908.
  7. bslaast

    Change a Group Header date to group by a Saturday-Friday week

    I have a report that is groupping by week. I want to change the week to Saturday-Friday and display the Friday date. Any ideas?
  8. bslaast

    Supressing Detail Records

    I have a Customer Order group with line items as the details. I want to suppress the details and header if all material for the order has been shipped. On the Details:{@RemainM} = ({MATERIAL_COST\.BUCKET_ACCUM_COST}*({CUSTOMER_ORDER_LINE\.BUY_QTY_DUE}-{CUSTOMER_ORDER_LINE\.QTY_SHIPPED}))...
  9. bslaast

    Supressing Details Crystal Reports

    I have a Customer Order group with line items as the details. I want to suppress the details and header if all material for the order has been shipped. On the Details: {@RemainM} = ({MATERIAL_COST\.BUCKET_ACCUM_COST}*({CUSTOMER_ORDER_LINE\.BUY_QTY_DUE}-{CUSTOMER_ORDER_LINE\.QTY_SHIPPED}))...
  10. bslaast

    Remove listview item

    I want to remove lines from a listview where the input value from a text box matches the line number of the listview. This is what I have: Dim line As ListViewItem Dim no As String Dim index As String index = txtLine.Text no = frmLineItemDialog.txtLineNo.Text...
  11. bslaast

    Help using the first record in a formula for Crystal XI

    I need to refer to the first record in a details section for a formula. Currently, my formula reads: if previous({PURCHASE_RECEIPT_INVOICE.PART_NO}) = {PURCHASE_RECEIPT_INVOICE.PART_NO} then ((previous({PURCHASE_ORDER_LINE.FBUY_UNIT_PRICE}) -...

Part and Inventory Search

Back
Top