Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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: 1113 | Location: USA | Registered: January 27, 2015Report 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, 2008Report 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: 1113 | Location: USA | Registered: January 27, 2015Report 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, 2013Report 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 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
 
Posts: 168 | Registered: March 29, 2013Report 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: 74 | Registered: December 23, 2013Report 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: 1113 | Location: USA | Registered: January 27, 2015Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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-2020 Information Builders