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     How to generate Conditional Alert Report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
How to generate Conditional Alert Report
 Login/Join
 
Platinum Member
posted
Dear Developers

i am using W.F 7.1.3 and i have to generate report as Alert like following:

scan database for Specifid value.
if that value is exist then generate Required Report and Distribute it via Rcaster.

my Environment as Following:

W.F Reporting Server 7.1.3
DataBase: MSSQL Server2000
OS: WinXP/SP1
W.F.DevStd 7.1.3
W.F Client 7.1.3
Web Application: NewAtlanta 5 Configured with IIS

i apreciate if you support me with sample report to do it

Regards
Ahmad Ali


WF 7.7.0.3HF3 / WinXP- WF-Client & Apache / DevStd 7.7.0.3HF3 win XP.
 
Posts: 118 | Registered: February 08, 2006Report This Post
Platinum Member
posted Hide Post
Is this possible without MRE ?

Lenny


(Production: WebFOCUS 7.1.3 on Win 2K/IIS 6/CGI)
(Test: WebFOCUS 7.1.3 on Win 2K/IIS 6/CGI)
 
Posts: 104 | Location: Boston | Registered: April 23, 2003Report This Post
Platinum Member
posted Hide Post
Hello Lenny

i see some technique to count number of record that retrived from database via &LINE
and make IF &LINE GT 0 view the report Else Display blank.but i am still test it.

but i need to know how to make this check with in report Caster.if there is result destribute report Else Dont destribute

kindly, any advice


WF 7.7.0.3HF3 / WinXP- WF-Client & Apache / DevStd 7.7.0.3HF3 win XP.
 
Posts: 118 | Registered: February 08, 2006Report This Post
Platinum Member
posted Hide Post
Q,

At a previous shop, we used the pre and post execution procedures in Report Caster to set and check for flags. Sorry i don't have a code snippet, but check into using the pre and post execution procedures to test for your values.

kevin


WF 7.6.10 / WIN-AIX
 
Posts: 141 | Location: Denver, CO | Registered: December 09, 2005Report This Post
Platinum Member
posted Hide Post
Dear Kevin

I got assistance from iBi techsupport.i will test the code that sent to me and i will post the result to the descussion


WF 7.7.0.3HF3 / WinXP- WF-Client & Apache / DevStd 7.7.0.3HF3 win XP.
 
Posts: 118 | Registered: February 08, 2006Report This Post
Platinum Member
posted Hide Post
Hi Kevin

i got the flag name from info response assistance. it is &&KILL_RPC.we add this flag on pre procedure with condition like following:

-SET &&KILL_RPC=IF &RECORDS EQ 0 THEN 'Y' ELSE 'N';

and it is working fine and smoothly.

thanks for Info Response Team and for you.


WF 7.7.0.3HF3 / WinXP- WF-Client & Apache / DevStd 7.7.0.3HF3 win XP.
 
Posts: 118 | Registered: February 08, 2006Report This Post
Gold member
posted Hide Post
Can you send me the coding that you used within the program, as it looks like a good technique to use


Webfocus 7.6.2 on Windows Enterprise 2003 Server and
Webfocus 7.6.2 on HP Unix Server
 
Posts: 74 | Location: London | Registered: January 28, 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     How to generate Conditional Alert Report

Copyright © 1996-2020 Information Builders