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 Rhinorhino 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

    thats great. thanks very much! [smile2]
  2. 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...
  3. leanneconnexions

    AND/OR formula

    using SQL database and crystal 9
  4. leanneconnexions

    AND/OR formula

    when using In in sql i still get the error as above: The text, ntext, or image data type cannot be selected as DISTINCT.
  5. leanneconnexions

    AND/OR formula

    unable to do: and exists ( select * from CR_History Hist where HIST.HistoryType_Ref = 'F' and HIST.HistoryCategory_Ref in ['0','1','2','3'] and HIST.CLient_ref = CR_HISTORY.CLient_ref )
  6. leanneconnexions

    AND/OR formula

    I get the following error from query analyser: Server: Msg 8163, Level 16, State 4, Line 1 The text, ntext, or image data type cannot be selected as DISTINCT.
  7. leanneconnexions

    AND/OR formula

    That is correct. Yes for every client ref i only want to see where the Category = D and at least one other Category of 0-5 for that client. As in AINDJ00 is the sample data.
  8. leanneconnexions

    AND/OR formula

    Many Thanks for all your help. It hasnt given me exactly what I want but I can use the data from the result set. ;-)
  9. leanneconnexions

    AND/OR formula

    no there is no group selection in the report. I used to select all the F Type Histories: {CR_HISTORY.HistoryType_Ref} = "F" and {CR_HISTORY.HistoryCategory_Ref} = "D" I then tried the 2 selections below to get the report to show those records where D and another is recorded...
  10. leanneconnexions

    AND/OR formula

    Client_Ref HistoryType HistoryCategory DateStart ZIMAS00 F 6 8-Jul-04 ZIMAS00 F 5 8-Jul-04 ZIMAN00 F 8 25-Feb-05 ZIMAN00 F 7 27-Jan-05 ZIMAN00 F...
  11. leanneconnexions

    AND/OR formula

    yes i want the report to show me where history category matched D for definate and any others ie 0-9A-Z.
  12. leanneconnexions

    AND/OR formula

    Both HistoryType and HitsoryCategory are Char 1.
  13. leanneconnexions

    AND/OR formula

    HistoryCategory_Ref is coded as 0-9 and A-Z. I want to be able to show for all those client records where history insert 'D' is record. where any other HistoryCaregory is recorded also. The HistoryCategory field is a string.
  14. leanneconnexions

    AND/OR formula

    Thanks. I have tried {CR_HISTORY.HistoryType_Ref} = 'F' and {CR_HISTORY.HistoryCategory_Ref} in ['D', '0','1','2','3'] and I still only get the D records returned. I do not get the record that has D and 0.
  15. 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...
  16. 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???
  17. leanneconnexions

    Parameter Fields

    Thank you that has worked just how I wanted it to.
  18. leanneconnexions

    Parameter Fields

    I have created the following formula to try and get multiple parameters selected to show: if (join({?area},", ")) = "2" then "Bournemouth" else if (join({?area},", ")) = "3" then "Poole" else if (join({?area},", ")) = "51" then "Beaminster" else if (join({?area},", ")) = "52" then "Bridport"...
  19. 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...
  20. leanneconnexions

    Is Like/Not Like Formula

    Just put square brackets round to look like:{CR_CLIENTS.Postcode} like "BH1*" and not (left({CR_CLIENTS.Postcode},4) in...

Part and Inventory Search

Back
Top