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 derfloh 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. damselx

    ToNumber v7 vs v10

    Thank you lupins46..... worked great :-)
  2. damselx

    ToNumber v7 vs v10

    Lupins - I get an error message 'a number or currency amount is required here' on the 2nd STKM.BIN_LOCATION Synapsevampire - ummm sorry ... I have no idea what to do with this :-)
  3. damselx

    ToNumber v7 vs v10

    Thanks for replying The bin location has a number in it - ie .47, but the the field is usually used for alpha in the database, hence crystal considers it a string I assume Although the bin location is designed for alpha there are no alpha characters used in this database
  4. damselx

    ToNumber v7 vs v10

    I am rewriting a report written in version 7 The formula is ToNumber ({STMAST.BIN_LOCATION}) * {SOTRAN.QUANTITY} This works fine in version 7, but in version 10 I get an error 'The string is non-numeric' Anyone have any ideas? Thanks Helen
  5. damselx

    Crystal Reports 7 dictionaries to Crystal 9 ODBC

    Please disregard this post - Bruce from New Zealand has helped me :-)
  6. damselx

    Crystal Reports 7 dictionaries to Crystal 9 ODBC

    I have a report written in Crystal 7 using dictionaries coming from a dataflex db I need to bring it up to Crystal Reports 9 using ODBC rather than the dictionaries. Am encountering several problems. The first, is that if I bring it up to 8.5 using dictionaries it's ok. But if I then bring...
  7. damselx

    Making primary sort not what specified in Group

    Thank you both for your help LB this worked !!! I don't understand it but I guess I'll learn as I go :-) Thanks again Helen
  8. damselx

    Making primary sort not what specified in Group

    Hi again Sorry, but I can't get that to work because there is a group in place which it's sorting on as the primary sort I want to leave that group in place but force it to sort on due date first Thanks Helen
  9. damselx

    Making primary sort not what specified in Group

    Hi There was only one group for job no If I create a second group for due date it's still treating the job no as the primary sort If I reverse them I get garbage Is there someway to leave the 1 group (job no) in place but force it to sort by date first? Thanks Helen
  10. damselx

    Making primary sort not what specified in Group

    Hi ... hoping you can help me again I have a report listing: Job No. Due Date Hours + more etc Without the detail hidden the report will list line after line, all showing the same job no. All lines with the same job no will have the same date - other fields will differ Have grouped...
  11. damselx

    Registry Editor Problem

    There's a heap of them under HKEY_LOCALMACHINE\System\CurrentControlSet001\Control\Class but this isn't where the article's pointing me and there's no directory 'NET' there ... Helen
  12. damselx

    Registry Editor Problem

    Hi Yes, I've done a 'find' on it - not there I'm reluctant to create the structure as I'm not sure what's involved - the next section of the article says: Search through each of the listed 000n values to find the DriverDesc key that pertains to the dial-up adapter or modem. Double-click the...
  13. damselx

    Registry Editor Problem

    I've been having a problem with outlook express hanging with attachments Looked thru the Microsoft Knowledge Base & it appears 315008 'may' solve my problem (willing to give anything a try at this stage) I'm using xp pro, outlook express 6.0 Article says : If You Connect by Modem Click...
  14. damselx

    sending email attachments

    Hi I've been having a problem over the last few weeks sending large (1.5 - 4mb) emails via 56k dialup Have contacted isp(s) (am using 2 and having the same problem with both) everything seems ok at their end I can send small text emails no problem Assuming I was having a software...
  15. damselx

    Using XP Pro as a server

    Hi In a situation where there's 4 pc's running XP Pro, connected to a server (& the server is also being used as a pc) can the server also be running XP Pro, or should it run 2003 server, or Small Business Server. If it needs to be running one of the latter ones, can you please tell me why I...
  16. damselx

    unwanted detail section copying down the page

    Sorry - what I said in that post is not correct In the Design it just shows the details I want in the details section In the preview I have multiple sections, all named D Helen
  17. damselx

    unwanted detail section copying down the page

    I realise this if fairly basic but I can't stop it from doing this I have the following Sales Credits Net etc (text lines) (text line - sales rep) (text line - description) **** If I put a formula in here it copies all the detail above (except my headings) into detail...
  18. damselx

    using if - then - else with 'text'

    Thankyou ... fixed it perfectly Helen
  19. damselx

    using Crystal 8.5 on SQL returning junk

    It's using 3 tables via ODBC Debtors Masterfile Debtors Transaction File Stock Transaction File Linked DRSMAST & DRSTRAN via Customer Code Linked DRSTRAN & STKTRAN via transaction reference no Does this help Sorry - it's hard to explain ! Thanks Helen
  20. damselx

    using Crystal 8.5 on SQL returning junk

    Hi I've written a report based on a SQL very large SQL database. If I ask it to return say 3 trans for 1 day & 3 for the next day it comes back perfect. If I ask it to return a whole day I get figures that are too high. If I ask for a whole month they are off the scale - ie $1.5m when should...

Part and Inventory Search

Back
Top