garyjgs
asked on
Crystal Report Parameter
How do I enter a parameter, Fiscal Year, within the SQL? See attached document.
How-do-I-enter-a-parameter.doc
How-do-I-enter-a-parameter.doc
Can't see the end of the SQL.
SELECT
List of Fields
FROM
Tablelist appropriately joined
WHERE
YourField = SELECT PARAMETER FROM THE LIST ON THE RIGHT
mlmcc
SELECT
List of Fields
FROM
Tablelist appropriately joined
WHERE
YourField = SELECT PARAMETER FROM THE LIST ON THE RIGHT
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Worked. Thanks.
FWIW, mlmcc probably deserves some points here. He posted first and he did give you the basics. I just included a lot more details (because that's what I do :-).
If you like, you can ask to have the question re-opened and split the points between us.
Oh, and you're welcome. :-)
James
If you like, you can ask to have the question re-opened and split the points between us.
Oh, and you're welcome. :-)
James
ASKER