Crystal Reports Where am I going wrong!

Message


     I am having the worst time with Dynamic Cascading Parameters.... I need a report with 5 Dynamic parameters and I can't seem to get it right. Can someone send me an example to look at? I've looked at the GROUP.RPT in the samples but I can't seem to make the connection?? 
 
My SQL command is the following (these are all the parameters I need, but I need it based off the second query)
 
Command 1-
SELECT
    MWAPPTS."COMPANY", MWAPPTS."BOOK", MWAPPTS."USERCODE",MWBOOK."PROV", MWBOOK."FACILITY"
FROM
    { oj (("medical"."dbo"."MWAPPTS" MWAPPTS LEFT OUTER JOIN "medical"."dbo"."CLMASTER" CLMASTER ON
        MWAPPTS."COMPANY" = CLMASTER."COMPANY" AND
    MWAPPTS."ACCOUNT" = CLMASTER."ACCOUNT")
     LEFT OUTER JOIN "medical"."dbo"."MWBOOK" MWBOOK ON
        MWAPPTS."COMPANY" = MWBOOK."COMPANY" AND
    MWAPPTS."BOOK" = MWBOOK."BOOKCODE")
     LEFT OUTER JOIN "medical"."dbo"."MWSCHED" MWSCHED ON
        MWAPPTS."ADATE" = MWSCHED."ADATE" AND
    MWAPPTS."BOOK" = MWSCHED."BOOK" AND
    MWAPPTS."COMPANY" = MWSCHED."COMPANY"}
 
Command2-
CREATE PROCEDURE [dbo].[gm_SelCompanies]
AS
BEGIN
     SET NOCOUNT ON 
     
DECLARE @COMPANY TABLE(
       vcCompany    VarChar(10)
       )
     SET NOCOUNT ON
            
     --Insert the Companies from CLUSER
     INSERT INTO @COMPANY
     SELECT
          DISTINCT COMPANY
     FROM 
          CLUSER
     WHERE
          (ACTIVE = 'Y' OR ACTIVE IS NULL)
          
     --Insert the Companies from CLUSERCOMPANY
     INSERT INTO @COMPANY
     SELECT
          DISTINCT CLUSERCOMPANY.COMPANY
     FROM 
          CLUSERCOMPANY INNER JOIN CLUSER ON CLUSERCOMPANY.USERCODE = CLUSER.USERID
     WHERE
          (ACTIVE = 'Y' OR ACTIVE IS NULL)

     --RETURN THE DISTINCT LIST OF COMPANIES
     SELECT
          DISTINCT vcCOMPANY
     FROM 
          @COMPANY
     ORDER BY
          vcCOMPANY
END
GO

 
Edited by moleary - 09 Apr 2008 at 9:01am