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!

Register Log in
  • Congratulations Mike Lewis 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: *

  1. Tonyvee73

    Use a field from a subreport in a calculation formula

    Hi Guys I have a field from a sub report and its showing fine in the main report (Say total 1) Now i need to write a formula in the main report to calculate that Total1 + Total2 = Total3 but dont know how to reference the field from the subreport (I can access formulas by the '@' and parameters...
  2. Tonyvee73

    splitting a field based to create a new field for every line after a carriage return

    sorry, i mean how do i get into my SELECT query in sql?
  3. Tonyvee73

    split a sql field based on carriage return

    Hi All My first post here, hope someone can help me? I have a table named SL_ADDRESSES and a field in there named (AD_ADDRESS. This has 4 lines or so of data all with carriage returns at the end of each line. When i select the AD_ADDRESS field all data is in one field. Is there a way to separate...
  4. Tonyvee73

    splitting a field based to create a new field for every line after a carriage return

    Thanks Andy How would i integrate this into a select fundtion?
  5. Tonyvee73

    splitting a field based to create a new field for every line after a carriage return

    Hi All My first post here, hope someone can help me? I have a table named SL_ADDRESSES and a field in there named (AD_ADDRESS. This has 4 lines or so of data all with carriage returns at the end of each line. When i select the AD_ADDRESS field all data is in one field. Is there a way to separate...
  6. Tonyvee73

    select ALL codes

    I have a select line as below: if {table.field} = ["12548","12457","12248","95684","65236","78555","78854","12544"] then 'set1' else {table.field} Trouble is I want to only mark as 'set1' if ALL of them are in a record there as at the moment its putting in 'set1' if ANY of them are there. Is...
  7. Tonyvee73

    excel macro

    ok thanks. its just the text 1 order(s) I need it to look for, not different values. So how would I change my macro to just look for that and not anything else?
  8. Tonyvee73

    excel macro

    Hi I am running an excel macro to search for text then delete if found as below. However its also deleting lines with the text "11 order(s)" - is there a way I can specific set to avoid this? Sub A_Mainsort() Rows(1).EntireRow.Delete Rows(1).EntireRow.Delete Rows(1).EntireRow.Delete...
  9. Tonyvee73

    help with summing whileprintingrecords

    Ok and thanks for the reply, however not quite sure how to start here - any pointers?
  10. Tonyvee73

    help with summing whileprintingrecords

    Hi Quite new to crystal and need to get a sum in an existing report but need some help? Have this in GH2 WhilePrintingRecords; numbervar RunPhysical; RunPhysical:= {STK_STOCK.STK_PHYSICAL} + {STK_STOCK.STK_QTYPRINTED} Have this in Details Whileprintingrecords; Numbervar RunPhysical; If...

Part and Inventory Search

Back
Top