Crystal Reports SQL Command Parameters

Message

     I'm using Crystal 10 within Visual Basic 6 and am having trouble with a command parameter. 

I have a VB 6 database which i am trying to add a Crystal Report to but am encountering problems with my parameter.

I have created the report using a command which includes the paramater SESS. I have dropped SESS onto the detail of my report.

My problem is that i am not prompted for SESS when running the report from my database. The only way i receive the prompt for SESS is when i access the report in design mode, and edit, then close my command.

This is far from ideal, and negates the use of a parameter entirely.

I'm really stuck...can anyone help me??

SQL from my command is:

SELECT
    sub1.ESOLExamHistStudRef,
    ViewExamHistESOL.ESOLExamHistSess,
    ViewExamHistESOL.ModuleDescript,
    ViewExamHistESOL.SylOptDescript,
    ViewExamHistESOL.ResultDescript,
    ViewExamHistESOL.TutorDescript  
FROM
   (SELECT
        ESOLExamHistStudRef
    FROM
        ViewExamHistESOL
    WHERE
        ESOLExamHistSess = {?SESS}
    GROUP BY
        ESOLExamHistStudRef
    ) sub1
    LEFT OUTER JOIN ViewExamHistESOL
        ON sub1.ESOLExamHistStudRef = ViewExamHistESOL.ESOLExamHistStudRef
WHERE 
    ViewExamHistESOL.ESOLExamHistSess <= {?SESS} 
ORDER BY
    sub1.ESOLExamHistStudRef,
    ViewExamHistESOL.ESOLExamHistSess DESC

Edited by Lewe22 - 18 Feb 2008 at 5:58am