Search results for query: *

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

No, because the graph is too large and the users don't always want to see it. Only when they click on the specific group.

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

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

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

That was just a test to see if the logic works. I want to change the WHERE clause depending on a given value. For example if today is a Monday I want to pull up all the 'Monday' clients so WHERE Today='Monday' if today is Tuesday I want WHERE Today='Tuesday'. It may sound a bit screwy but...

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

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