According to the doc:

TABLE FILE synonym 
PRINT [parameter [parameter] ... | *]
[IF in-parameter EQ value]
  .
  .
  .
END

where:

synonym

    Is the synonym of the stored procedure you want to execute.
parameter

    Is the name of a parameter whose values you want to display in the report. You can specify input parameters, output parameters, or input and output parameters.

    If the stored procedure does not require parameters, specify an asterisk (*). This displays a dummy segment, created when the synonym is generated, to satisfy the structure of the SELECT statement.
*

    Indicates that you want to display all indicated parameters, or that there are no required parameters. 
IF

    Is an IF or WHERE keyword. Use this to pass a value to an IN parameter or an INOUT parameter in IN mode.
in-parameter

    Is the name of an IN parameter, or INOUT parameter in IN mode, to which you want to pass a value.

    Note: The length of in-parameters cannot exceed 1000 characters if the adapter is configured for Unicode support.
value

    Is the value you are passing to a parameter.

Here's a synonym I created for an sp in Adventurworks.

FILENAME=USPGETMANAGEREMPLOYEES, SUFFIX=SQLMSS  , $
  SEGMENT=INPUT, SEGTYPE=S0, $
    FIELDNAME=@BUSINESSENTITYID, ALIAS=P0001, USAGE=I11, ACTUAL=I4,
      MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
  SEGMENT=OUTPUT, SEGTYPE=S0, PARENT=INPUT, $
    FIELDNAME=@RETURN_VALUE, ALIAS=P0000, USAGE=I11, ACTUAL=I4, $
  SEGMENT=ANSWERSET1, SEGTYPE=S0, PARENT=INPUT, $
    FIELDNAME=RECURSIONLEVEL, ALIAS=RecursionLevel, USAGE=I11, ACTUAL=I4,
      MISSING=ON, $
    FIELDNAME=ORGANIZATIONNODE, ALIAS=OrganizationNode, USAGE=A4000, ACTUAL=A4000,
      MISSING=ON, $
    FIELDNAME=MANAGERFIRSTNAME, ALIAS=ManagerFirstName, USAGE=A50, ACTUAL=A50, $
    FIELDNAME=MANAGERLASTNAME, ALIAS=ManagerLastName, USAGE=A50, ACTUAL=A50, $
    FIELDNAME=BUSINESSENTITYID, ALIAS=BusinessEntityID, USAGE=I11, ACTUAL=I4,
      MISSING=ON, $
    FIELDNAME=FIRSTNAME, ALIAS=FirstName, USAGE=A50, ACTUAL=A50,
      MISSING=ON, $
    FIELDNAME=LASTNAME, ALIAS=LastName, USAGE=A50, ACTUAL=A50,
      MISSING=ON, $


Here's a report you can run against it:

ENGINE INT CACHE SET ON


-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE ibisamp/uspgetmanageremployees
SUM USPGETMANAGEREMPLOYEES.ANSWERSET1.RECURSIONLEVEL
USPGETMANAGEREMPLOYEES.ANSWERSET1.BUSINESSENTITYID
BY USPGETMANAGEREMPLOYEES.ANSWERSET1.MANAGERFIRSTNAME
BY USPGETMANAGEREMPLOYEES.ANSWERSET1.MANAGERLASTNAME
BY USPGETMANAGEREMPLOYEES.ANSWERSET1.FIRSTNAME
WHERE USPGETMANAGEREMPLOYEES.INPUT.@BUSINESSENTITYID EQ &BUSINESSENTITYID.(<1,1>, <2,2>, <3,3> |FORMAT=I11).@BUSINESSENTITYID:.;
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET GRWIDTH 1
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, ORIENTATION=LANDSCAPE, HFREEZE=OFF, $
ENDSTYLE
END

-RUN

This works too:

WHERE USPGETMANAGEREMPLOYEES.INPUT.@BUSINESSENTITYID EQ 1;


Can you post the synonym or is it too long?  

 -DEFAULTH &StartDate=20170301
 -DEFAULTH &EndDate=20170331
 TABLE FILE FLASHRPTAPPOINTMENTS
 SUM
 CNT.FLASHRPTAPPOINTMENTS.ANSWERSET1.APPOINTMENT_ID
 BY	FLASHRPTAPPOINTMENTS.ANSWERSET1.GENDER_NM
 WHERE FLASHRPTAPPOINTMENTS.INPUT.@StartDate GE 20170301;
 WHERE READLIMIT IS 10
 END
 FILENAME=  FLASHRPTAPPOINTMENTS
 @StartDate         P0001              I11
 @EndDate           P0002              I11
 @RETURN_VALUE      P0000              I11
 APPOINTMENT_ID     APPOINTMENT_ID     P20
 APPT_DATE_DIM_ID   APPT_DATE_DIM_ID   P20
 PATIENT_DIM_ID     PATIENT_DIM_ID     P20
 RACE1_NM           RACE1_NM           A256V
 ETHNICITY_NM       ETHNICITY_NM       A256V
 GENDER_NM          GENDER_NM          A10V
 RESOURCE           Resource           A160V
 PCPATAPPT          PCPatAppt          A160V
 APPTTYPE           ApptType           A50V
 IS_APPT_KEPT       IS_APPT_KEPT       I11
 IS_SAMEDAY         IS_SAMEDAY         I11
 IS_MORNING         IS_MORNING         I11
 IS_AFTERNOON       IS_AFTERNOON       I11
 IS_EVENING         IS_EVENING         I11
 IS_DAY             IS_DAY             I11
 IS_WEEKEND_HOLIDAY IS_WEEKEND_HOLIDAY I11
 IS_NO_SHOW         IS_NO_SHOW         I11
 IS_CANCELLED       IS_CANCELLED       I11
 CANX_RSN_TXT       CANX_RSN_TXT       A256V
 (FOC1400) SQLCODE IS 201 (HEX: 000000C9) XOPEN: 42000
 (FOC1500)  :  Microsoft OLE DB Provider for SQL Server: [42000] Procedure or function
 (FOC1500)  :  'FlashRptAppointments' expects parameter '@StartDate', which was not
 (FOC1500)  :  supplied.
 L    (FOC1406) SQL OPEN CURSOR ERROR.

 0 NUMBER OF ERRORS=     0
 NUMBER OF SEGMENTS=   3  ( REAL=    3  VIRTUAL=   0 )
 NUMBER OF FIELDS=    22  INDEXES=   0  FILES=     1
 TOTAL LENGTH OF ALL FIELDS= 1240

TABLE FILE FLASHRPTAPPOINTMENTS
 SUM
 CNT.FLASHRPTAPPOINTMENTS.ANSWERSET1.APPOINTMENT_ID
 BY	FLASHRPTAPPOINTMENTS.ANSWERSET1.GENDER_NM
 WHERE FLASHRPTAPPOINTMENTS.INPUT.@StartDate GE 20170301;
 WHERE FLASHRPTAPPOINTMENTS.INPUT.@EndDate LE 20170331;
 WHERE READLIMIT IS 10
 END

(FOC1400) SQLCODE IS 201 (HEX: 000000C9) XOPEN: 42000
 (FOC1500)  :  Microsoft OLE DB Provider for SQL Server: [42000] Procedure or function
 (FOC1500)  :  'FlashRptAppointments' expects parameter '@StartDate', which was not
 (FOC1500)  :  supplied.
 L    (FOC1406) SQL OPEN CURSOR ERROR.

Could you try this code?

TABLE FILE FLASHRPTAPPOINTMENTS
 SUM
 CNT.FLASHRPTAPPOINTMENTS.ANSWERSET1.APPOINTMENT_ID
 BY	FLASHRPTAPPOINTMENTS.ANSWERSET1.GENDER_NM
 WHERE P0001 GE 20170301;
 WHERE P0002 LE 20170331;
 WHERE READLIMIT IS 10
 END

quote:

TABLE FILE FLASHRPTAPPOINTMENTS
SUM
CNT.FLASHRPTAPPOINTMENTS.ANSWERSET1.APPOINTMENT_ID
BY FLASHRPTAPPOINTMENTS.ANSWERSET1.GENDER_NM
WHERE P0001 GE 20170301;
WHERE P0002 LE 20170331;
WHERE READLIMIT IS 10
END

quote:

FILENAME= FLASHRPTAPPOINTMENTS
@StartDate P0001 I11
@EndDate P0002 I11
@RETURN_VALUE P0000 I11
APPOINTMENT_ID APPOINTMENT_ID P20
APPT_DATE_DIM_ID APPT_DATE_DIM_ID P20
PATIENT_DIM_ID PATIENT_DIM_ID P20
RACE1_NM RACE1_NM A256V

quote:

FILENAME= FLASHRPTAPPOINTMENTS
@StartDate P0001 I11
@EndDate P0002 I11
@RETURN_VALUE P0000 I11
APPOINTMENT_ID APPOINTMENT_ID P20
APPT_DATE_DIM_ID APPT_DATE_DIM_ID P20
PATIENT_DIM_ID PATIENT_DIM_ID P20
RACE1_NM RACE1_NM A256V
ETHNICITY_NM ETHNICITY_NM A256V

FILENAME=CCSGDETAIL2AE_WF, SUFFIX=SQLMSS  , $
  SEGMENT=INPUT, SEGTYPE=S0, $
    FIELDNAME=@RUNID, ALIAS=P0001, USAGE=A38, ACTUAL=A38,
      MISSING=ON, ACCESS_PROPERTY=(NEED_VALUE), $
  SEGMENT=OUTPUT, SEGTYPE=S0, PARENT=INPUT, $
    FIELDNAME=@RETURN_VALUE, ALIAS=P0000, USAGE=I11, ACTUAL=I4, $
  SEGMENT=ANSWERSET1, SEGTYPE=S0, PARENT=INPUT, $
    FIELDNAME=FY, ALIAS=FY, USAGE=A4, ACTUAL=A4,
      MISSING=ON, $
    FIELDNAME=RUN_PARM, ALIAS=RUN_PARM, USAGE=A8, ACTUAL=A8,
      MISSING=ON, $
    FIELDNAME=HIGH_GROUP_PARM, ALIAS=HIGH_GROUP_PARM, USAGE=A30, ACTUAL=A30,
      MISSING=ON, $
    FIELDNAME=GROUP_PARM, ALIAS=GROUP_PARM, USAGE=A30, ACTUAL=A30,
      MISSING=ON, $
    FIELDNAME=GROUP_ORDER, ALIAS=GROUP_ORDER, USAGE=A100, ACTUAL=A100,
      MISSING=ON, $

 
-DEFAULTH &RunID = '{0CCBB6C0-DCC0-4A26-AB7F-1C39241E7E3E}';
TABLE FILE CCSGDETAIL2AE_WF
BY  @RUNID
BY  FY
BY  RUN_PARM
BY  HIGH_GROUP_PARM
BY  GROUP_PARM
BY  GROUP_ORDER
WHERE @RUNID EQ '&RunID';
END

quote:

Update: If I run the 'Sample Data', for this same master, from App Studio I get the same error BUT if I run it from the Reporting Server Console I get records while passing @StartDate and @EndDate!Any ideas why the difference?

quote:

Originally posted by gregv:
Same results. Thanks.

TABLE FILE FLASHRPTAPPOINTMENTS
 SUM
 CNT.FLASHRPTAPPOINTMENTS.ANSWERSET1.APPOINTMENT_ID
 BY	FLASHRPTAPPOINTMENTS.ANSWERSET1.GENDER_NM
 WHERE FLASHRPTAPPOINTMENTS.INPUT.@StartDate GE 20170301;
 WHERE FLASHRPTAPPOINTMENTS.INPUT.@EndDate LE 20170331;
 WHERE READLIMIT IS 10
 END

(FOC1400) SQLCODE IS 201 (HEX: 000000C9) XOPEN: 42000
 (FOC1500)  :  Microsoft OLE DB Provider for SQL Server: [42000] Procedure or function
 (FOC1500)  :  'FlashRptAppointments' expects parameter '@StartDate', which was not
 (FOC1500)  :  supplied.
 L    (FOC1406) SQL OPEN CURSOR ERROR.

 WHERE @StartDate GE 20170301;
 WHERE @EndDate LE 20170331;