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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.