Link to home
Start Free TrialLog in
Avatar of garyjgs
garyjgsFlag for United States of America

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
Avatar of garyjgs
garyjgs
Flag of United States of America image

ASKER

Need to know the best method of creating a parameter at the command with a SQL.
Avatar of Mike McCracken
Mike McCracken

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
ASKER CERTIFIED SOLUTION
Avatar of James0628
James0628

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of garyjgs

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