Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Anyone else ever have this issue before?
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Anyone else ever have this issue before?
 Login/Join
 
Virtuoso
posted
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>,


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1111 | Location: USA | Registered: January 27, 2015Reply With QuoteReport This Post
Guru
posted Hide Post
CoolGuy,

please post your code.


WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit
 
Posts: 398 | Registered: February 04, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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,


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1111 | Location: USA | Registered: January 27, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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 #:.' );


Thanks!
@vi

WebFOCUS 8105, Dev Studio 8105, Windows 7, ALL Outputs
 
Posts: 103 | Registered: July 08, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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.


WebFocus 8203M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 154 | Registered: March 29, 2013Reply With QuoteReport This Post
Gold member
posted Hide Post
&DSNAME must be a system variable name.
Change it to &XNAME and it works perfectly.


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 75 | Registered: December 23, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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!


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1111 | Location: USA | Registered: January 27, 2015Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Anyone else ever have this issue before?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.