Hey all,

I have a report that has 4 different WHERE clauses that when ran is supposed to ask for all 4 parameters. For some reason, after building out the different clauses and running the report, 3 out of 4 auto-prompts are visible, but the 4th prompt isn't. So, when I select what params I can and then run it, it throws an error stating it still needs a value for the 4th param. But it never populated a prompt for that specific param.

I've tried both DevStudio and AppStudio and it still fails to populate the 4th prompt. All the names across the board look right. It even states I need the param value after running. But no prompt to put the param value in before running.

Anyone else have this issue before and know how to fix it?

Thanks!

This message has been edited. Last edited by: <Kathryn Henning>,

CoolGuy,

please post your code.

The 3rd WHERE clause for DSNAME (store name) isn't populating an auto-prompt in either environment (App/DevStudio). Not sure why, but need it to. That or be able to manually create it in the HTML Canvas. Been trying that, but it won't let me create another dynamic param the way the others work. ???

  
TABLE FILE SRPROD
SUM 
     SRPROD.SRPROD.SRPDSTORECOUPCNT AS 'Store Cpn,Cnt'
     SRPROD.SRPROD.SRPDSTORECOUPAMT/P10.2CM AS 'Store Cpn,Amt'
     SRPROD.SRPROD.SRPDVOIDAMT/P10.2CM AS 'Void,Amt'
     SRPROD.SRPROD.SRPDCANCELSAMT/P10.2CM AS 'Cancels,Amt'
     SRPROD.SRPROD.SRPDNOSALECNT AS 'No Sale,Cnt'
     SRPROD.SRPROD.SRPDSUSPENDEDCNT AS 'Suspended,Cnt'
     SRPROD.SRPROD.SRPDSUSPENDEDAMT/P10.2CM AS 'Suspended,Amt'
     SRPROD.SRPROD.SRPDRESUMECNT AS 'Resume,Cnt'
     SRPROD.SRPROD.SRPDRESUMEAMT/P10.2CM AS 'Resume,Amt'
     SRPROD.SRPROD.SRPDRETURNSAMT/P10.2CM AS 'Returns,Amt'
     SRPROD.SRPROD.SRPDOVERSHORT/P10.2CM AS 'Over/Short'
     SRPROD.SRPROD.SRPDCUSTCNT AS 'Cstmr,Cnt'
     SRPROD.SRPROD.SRPDAVGCUSTPHR AS 'Avg Cstmrs,per hour'
     SRPROD.SRPROD.SRPDAVGSPHR/P10.2CM AS 'Avg Sales,per hour'
     SRPROD.SRPROD.SRPDITEMSOLD AS 'Items,Sold'
     SRPROD.SRPROD.SRPDITEMSCANNED AS 'Items,Scanned'
     SRPROD.SRPROD.SRPDKEYENTRYCNT AS 'Keyed In,Cnt'
     SRPROD.SRPROD.SRPDOPENDEPTCNT AS 'Open Dept,Cnt'
     SRPROD.SRPROD.SRPDAVGITMSPERMIN AS 'Avg Items,per min'
     SRPROD.SRPROD.SRPDAVGSCANSPERMIN AS 'Avg Scans,per min'
     SRPROD.SRPROD.AVGSCANSPERSEC AS 'Avg Scans,per sec'
     SRPROD.SRPROD.RTPERCUST AS 'Ringtime,per cstmr'
     SRPROD.SRPROD.RTPERITMSOLD AS 'Ringtime,per items sold'
     SRPROD.SRPROD.TTPERCUST AS 'Tendertime,per cstmr'
     SRPROD.SRPROD.TTPERITMSOLD AS 'Tendertime,per items sold'
     SRPROD.SRPROD.STPERCUST AS 'Sessiontime,per cstmr'
     SRPROD.SRPROD.STPERITMSOLD AS 'Sessiontime,per items sold'
     SRPROD.SRPROD.ITPERCUST AS 'Idletime,per cstmr'
     SRPROD.SRPROD.LTPERCUST AS 'Locktime,per cstmr'
BY  LOWEST SRPROD.SRPROD.BIZDATE_MDYY AS 'Business Date'
BY  LOWEST SRPROD.SRPROD.SRPDCASHIERNO AS 'Cashier #'
BY  LOWEST SRPROD.SRPROD.SRPDCASHIERNAME AS 'Cashier Name'
ON TABLE SUBHEAD
"Cashier Productivity - All Metrics"
"Fiscal Year: <SRPROD.DIMDATE.FISCALYEAR - Fiscal Week: <SRPROD.DIMDATE.FISCALWEEKOFYEAR - Store: <SRPROD.DIMSTORE.DSNAME "
ON TABLE SUBFOOT
"AFS Information Systems"
WHERE ( SRPROD.DIMDATE.FISCALYEAR EQ '&FISCALYEAR.(FIND SRPROD.DIMDATE.FISCALYEAR IN SRPROD).Fiscal year:.' ) 
AND ( SRPROD.DIMDATE.FISCALWEEKOFYEAR EQ &FISCALWEEKOFYEAR.(FIND SRPROD.DIMDATE.FISCALWEEKOFYEAR IN SRPROD).Fiscal week:. ) 
AND ( SRPROD.DIMSTORE.DSNAME EQ &DSNAME.(OR(FIND SRPROD.DIMSTORE.DSNAME IN SRPROD)).Store name:. ) 
AND ( SRPROD.SRPROD.SRPDCASHIERNO EQ &SRPDCASHIERNO.(OR(FIND SRPROD.SRPROD.SRPDCASHIERNO IN SRPROD)).Cashier #:. );
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENBlue_Light2.sty,
$
     ORIENTATION=LANDSCAPE,
$
TYPE=TABHEADING,
     SIZE=14,
     COLOR=RGB(72 78 87),
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=TABFOOTING,
     SIZE=12,
     COLOR=RGB(72 78 87),
     STYLE=BOLD+ITALIC,
     JUSTIFY=RIGHT,
$
ENDSTYLE
END

This message has been edited. Last edited by: CoolGuy,

If the where clauses is coming from table it self then use below code in your clauses , May be this will run-
---------------------------------------
WHERE ( SRPROD.DIMDATE.FISCALYEAR EQ '&FISCALYEAR.(FIND SRPROD.DIMDATE.FISCALYEAR IN SRPROD).Fiscal year:.' )
AND ( SRPROD.DIMDATE.FISCALWEEKOFYEAR EQ '&FISCALWEEKOFYEAR.(FIND SRPROD.DIMDATE.FISCALWEEKOFYEAR IN SRPROD).Fiscal week:.' )
AND ( SRPROD.DIMSTORE.DSNAME EQ '&DSNAME.(OR(FIND SRPROD.DIMSTORE.DSNAME IN SRPROD)).Store name:.' )
AND ( SRPROD.SRPROD.SRPDCASHIERNO EQ '&SRPDCASHIERNO.(OR(FIND SRPROD.SRPROD.SRPDCASHIERNO IN SRPROD)).Cashier #:.' );

Could it be that &DSNAME is a system variable, or at least at resolving which parameters to be prompted WF might consider it a system variable which does need to be asked. But later on it turns out it is not a system variable, so it throws an error.

Can you try another parameter name like &STORENAME

Martin.

&DSNAME must be a system variable name.
Change it to &XNAME and it works perfectly.

Hey all,

Thanks for all your help and insights! I did just change the variable name &DSNAME to &STRNAME and now it works. Now if this happens again I'll know what to check for and how to troubleshoot it.

Again, thanks everyone!