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!

Search results for query: *

  • Users: bluevelvet
  • Content: Threads
  • Order by date
  1. bluevelvet

    FOA GMcNamara alter data with crystal

    You said that you could alter data in a database with Crystal, I'd be very interested to find out how. Could you post up the procedure for doing this please.... Thanks
  2. bluevelvet

    If, else if not returning correct data

    Can anyone help. I have the following if statement: {@DateOriginal} = {?DateOriginal} and (if{?StockNumber}=&quot;&quot; then {IPPOITM.STOCK_NUMBER}like&quot;*&quot; and {IPPOITM.VENDOR_NUMBER}like{?Vendor} else if {?StockNumber}<>&quot;&quot;then{IPPOITM.STOCK_NUMBER}like{?StockNumber}and...
  3. bluevelvet

    add shared variable and group summary

    Hi there, I have cr9 connecting to sql 2000. I have a shared variable in my mainreport from a sub report which calculates parts costs. This has been placed in the group footer of the main report which summarises the labour cost so I have job costs for labour and parts. I need to get the total...
  4. bluevelvet

    Parameters with wildcards

    Please help before I lose my sanity!!! I am trying to use wildcards with parameters so that when end users are prompted for a part no for example, they can put in C69-* where * represents the missing part of the number. I have tried using the following syntax in my record selection formula...
  5. bluevelvet

    Date range parameter but date is in a string

    Help! I need to set a date range parameter in my report (Crystal v8) but the date field in the database is actually a text string. I have a formula which converts the string to a date but of course can't use this in a parameter. Anyone out there know how to get round this??? :-)

Part and Inventory Search

Back
Top