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 bkrike 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: dancarr22
  • Content: Threads
  • Order by date
  1. dancarr22

    Pass parameters from VB 6.0 to Crystal 8.5 AND export to pdf

    I need to pass parameters from VB 6.0 to Crystal 8.5. Then, export the report as a pdf If I do not assign values to the parameter this works and exports (to pdf) the previously saved values. If I just pass the parameters and view the report it works. BUT when I do both I get a 'Server has not...
  2. dancarr22

    Display a graph only when the group is 'drillied-down'

    I would like to display a report with several groupings. On one of the report group sections I would like to display a graph ONLY when the group is 'drilled-down'--i.e. when a seperate report is cut-out and put onto a separate tab. Any help is greatly appreciated. Thanks. Dan
  3. dancarr22

    How do I create a simple function

    I have several fields in my result set that are 0 or 1. 0 is 'Pass', 1 is 'Fail' I would like to create a function that accepts one IN parameter (the 1 or 0) and returns a string 'PASS' or 'FAIL'. I know I can do this for every field individually (i.e. If {test1.field1}=0 then 'Pass' else...
  4. dancarr22

    Oracle components required on web server to call asp pages

    Which Oracle components need to be installed on the web server in order to connect to Oracle. -tia
  5. dancarr22

    CASE clause in the WHERE section

    Anyone know how to put a CASE or IF statement in a where clause...this didn't work SELECT NAME FROM CUSTOMERS WHERE CASE WHEN SYSDATE=SYSDATE THEN NAME LIKE 'a%' ELSE NAME LIKE 'b%' END
  6. dancarr22

    Query can not read a form's control (for experts only)

    Hello, Very bizarre problem. We are using Access 2000 and our queries recently 'stopped working'. When we try to add a column to the query which references a form's control: Expr1: [Forms]![Form1]![txtName]--it works ONLY IF the value being returned is a String. If a date or number is in the...

Part and Inventory Search

Back
Top