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     [CLOSED] Autoprompt for Input parameters

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Autoprompt for Input parameters
 Login/Join
 
Member
posted
I am creating a Designer report that uses an SQL stored procedure as the data source. The stored procedure requires two date parameters. The INPUT segment of the .mas is here:

SEGMENT=INPUT, SEGTYPE=S0, $
FIELDNAME=@ACTIVEDATE, ALIAS=P0001, USAGE=HYYMDs, ACTUAL=HYYMDs,
MISSING=ON, ACCESS_PROPERTY=(INTERNAL, NEED_VALUE), $
FIELDNAME=@CODEEFFDATE, ALIAS=P0002, USAGE=HYYMDs, ACTUAL=HYYMDs,
MISSING=ON, ACCESS_PROPERTY=(INTERNAL, NEED_VALUE), $

I tried all variations of the ACCESS_PROPERTY property, (INTERNAL, NEED_VALUE, or both).

I would like the input parameters to use a default date (for the initial report load), and add a date control to the filter shelf that will allow the user to rerun with the date selected.

When I drop the input parameter on the filter shelf I get this error:

(FOC295) A VALUE IS MISSING FOR: &ACTIVEDATE(IA_200526_134055-1)(IA_200526_134055-1)(IA_200526_134055-1)(IA_200526_134055-1)(IA_200526_134055-1)(IA_200526_134055-1)(IA_200526_134055-1)(IA_200526_134055-1)

I also tried using a reporting object, with filters for the input parameters. When running it I get an autoprompt error. I've looked for autoprompt documentation to determine if/how it applies to input parameters, can't find anything that addresses this.

So my question is twofold,

1. Is there a way to provide a default value for input fields?
2. Are filter shelf controls based only on output fields? Can they apply to input fields?

Thank you for your time.

Update: I defaulted the date parameters within the stored procedure, this will probably be acceptable for now. But, I am still getting errors trying to prompt for fields in the input segment.

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 29 | Registered: July 17, 2007Report This Post
Virtuoso
posted Hide Post
Hi Tim

Been a while since we have talked.. Hope all is well...

When you create the report against the stored procedure if you put a -DEFAULT for the two date variables at the beginning of the fex and use those parameters in your where conditions it should work just fine. The filter shelf will have the default values displayed. My synonym only has an ACCESS_PROPERTY of NEED_VALUE.

My stored procedure looks like this.


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE GetProducts @ProdCat varchar(40)
AS
BEGIN
SET NOCOUNT ON;
SELECT PRODUCT_NAME FROM wrd_wf_retail_product WHERE PRODUCT_CATEGORY = @ProdCat
END
GO


My WebFOCUS Report is as follows.

-DEFAULT &PRODCAT='Televisions';
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET SQUEEZE=ON
-DEFAULTH &WF_HTMLENCODE=ON;
SET HTMLENCODE=&WF_HTMLENCODE

SET HTMLCSS=ON
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT

-DEFAULTH &WF_ARVERSION=1;
SET ARVERSION=&WF_ARVERSION

-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE wfretail82/getproducts
BY GETPRODUCTS.ANSWERSET1.PRODUCT_NAME
WHERE GETPRODUCTS.INPUT.@PRODCAT EQ '&PRODCAT';
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
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, $
ENDSTYLE
END


I drug this onto a designer page and enabled the filter and all was good.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2127 | Location: Customer Support | Registered: April 12, 2005Report 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     [CLOSED] Autoprompt for Input parameters

Copyright © 1996-2020 Information Builders