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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Carera2011

  1. Carera2011

    Select statement question

    I am trying to decifer an sql statement and can't figure out what this line is doing. Select distinct 4 as SSlevel A temporary table was created before this with 3 columns. Is the "4" in the line looking for 4 records? Any help is much appreciated. Thanks Carlos
  2. Carera2011

    The Truncate or Fix Function

    I am using XI Release 2. Can anyone tell my why the truncate or fix function will not work in XI? I've used it successfully in other versions but can not get XI to drop the decimals using truncate. I get no errors in my formula but the results don't show that it did anything.
  3. Carera2011

    Printing Problem -How to Print Multiple Labels

    I have customers ordering different amounts of products. Once the oders are completed I then know how many boxes it took to package the complete order. I need to use Crystal to print the labels for this customers orders. I have a parameter set up to accept the # of labels that need to be...
  4. Carera2011

    CR11- format fields in drill down tree

    I am not sure what you are trying to format...are you trying to change the font color in the tree? I don't know if that is possible. You can format the way a tree selection appears as far as syntax by customizing a group name with a formula though.
  5. Carera2011

    Inserting a check off box in a report Crystal 11

    You can also use chr(111) for an empty box and chr(510) for a box with a check inside of it. the rest applies...you'll have to change the font to wingdings. But this can give you other options. -Carlos
See more

Part and Inventory Search

Back
Top