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 TouchToneTommy 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. leanneconnexions

    sql update script

    on a test dataset i have created a tbl (testaddress) containing two fields Client_Ref and AddLocality from another table (CR_Clients). I have updated the addlocality values in CR_CLIENTS to Null and now i am trying to put the addlocality back into CR_CLIENTS using the stored data in TestAddress...
  2. leanneconnexions

    AND/OR formula

    This is returning a null dataset. I know it should return one at least as I have a record that contains FD and F1. What is wrong with the formula? In my dataset I need all history categories D and where there is also 0 or 1 or 2 etc. HELP! ;-) {CR_HISTORY.HistoryType_Ref} = 'F' and...
  3. leanneconnexions

    Crystal Report Application Server

    using crystal RAS through a web database application for users to run reports. Is there a way to get a text tip to appear when the user hovers over the report before clicking to run???
  4. leanneconnexions

    Parameter Fields

    I have set up a parameter field to allow users to select more than one value for the report, they could have up to 6. I want to be able to display the values they have included in their report on the front page. I have tried adding the parameter to display on the front page but it only picks...
  5. leanneconnexions

    Is Like/Not Like Formula

    I am trying to select the postcode starting with BH1 but do not want for example BH10, BH11 etc. Afetr looking through dummies guides I am using the right expressions but it wont work! Any crystal experts out there? The formula i am using is below: {CR_CLIENTS.Postcode} like "BH1*&quot...

Part and Inventory Search

Back
Top