 |
|||||
|
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
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 WebFOCUS/FOCUS Forum on Focal Point [CLOSED]Need Help in the following code
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED]Need Help in the following code Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED]Need Help in the following code | Login/Join |
| Gold member |
Hello, I am a beginner in web Focus and creating report. The purpose of the code is If Type of coverage is Assistant Living Care then show only 'Assistant Living care Cov Amount' and 'AssistantLiving Care Term Premium'. IF &P_Type Of Cov EQ 'AssistedLivingCare' THEN GO TO LBL 'Assisted Living Care' -LBL AsssitedLivingCare 'AssitedlivingCare CovAmount' 'AssistedLivingCare TermPremium' -GOTO LBL DONE CHECKING I am getting error regards, NiharikaThis message has been edited. Last edited by: <Emily McAllister>, WebFOCUS 8 Windows 7 HTML | ||
|
| Virtuoso |
You populate an &Variable with a prompt and then use it in a WHERE FIELD EQ &Variable within the request as a filter. TABLE FILE CAR SUM CAR.BODY.DEALER_COST BY CAR.ORIGIN.COUNTRY BY CAR.COMP.CAR BY CAR.BODY.BODYTYPE WHERE CAR.BODY.BODYTYPE EQ '&BODYTYPE.BODYTYPE:.'; ON TABLE PCHOLD FORMAT HTML ENDThis message has been edited. Last edited by: BabakNYC, WebFOCUS 8206, Unix, Windows | |||
|
| Virtuoso |
Hi Niharika and welcome in FOCUS world. First not sure of what you want to do with
But it certainly not working in FOCUS. It should be something like this -DEFAULT &P_Type_Of_Cov = 'AssistedLivingCare' -IF &P_Type_Of_Cov EQ 'AssistedLivingCare' THEN GOTO LBL_ALC; -LBL_ALC -TYPE 'AssitedLivingCare CovAmount' -TYPE 'AssistedLivingCare TermPremium' -GOTO LBL_DONE; -LBL_DONE Under LBL_ALC you cannot just put text without a verb. The -TYPE verb is used to display the text or variable. Also, you are limited on the label length, format and characters that you can used. Without knowing exactly what you want to do in you LBL_ALC, is difficult to help. Try to gives us an example using one the IBI sample file such as CAR file. WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007 | |||
|
| Gold member |
WebFOCUS 8 Windows 7 HTML | |||
|
| Gold member |
Thanks. I will try to elaborate with examples so that It will be fixed. Niharika WebFOCUS 8 Windows 7 HTML | |||
|
| Gold member |
Hello Martin, I want to dynamically place fields on reports based values of variables. One option is all fields...so I have some common fields , I need to dynamically add fields to report. Is it clear? REgards, Niha WebFOCUS 8 Windows 7 HTML | |||
|
| Virtuoso |
Maybe this may help given that I understand that you want to create kind of Ad Hoc reporting Ad Hoc part I Ad Hoc part II But there is several way to answer your need and it may be the easiest one if you don't have that much experience with FOCUS. WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007 | |||
|
| Expert |
Niharika, I think you need some basic training. The Dialog manager you posted is by no means correct. You have also not posted the error. I would always suggest that if you have an issue, repro it with one of the sample files and post the whole code. Makes it easier for us to determine what is wrong. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Member |
Hi Waz.. I work with Niharika.. I know what she is trying to do. She is junior level and has less than 4 months on WF.. so she is trying. And needs guidance from senior level guys like you, Martin and BabakNYC. What she needs to accomplish is for a drill down report that is drilled to from 3 summary reports, she needs to display different fields in the detail report. So if she clicks on 1 column, she will get a detail report with Columns A, B, C, D,E, F ... then if she clicks on column 2 then she needs a detail report with Columns A, B, C, D, H, I, J, K, L... and a 3rd report drills to columns A, B, C, D, X, Y,Z... so the idea is to achieve this with Print A,B,C, D and then do DMgr and based on a variable show EF or GHIJKL or XYZ.. and if column4 is clicked then columns ABCDEFGHIJKLXYZ are displayed. | |||
|
| Expert |
Hi CTM2015, Niharika. I would still suggest basic training on dialog manager. As a minimum there are many examples on the forum, and also in the sample fexes suplied with a WebFOCUS installation. There are several ways to do this. The simplest is to do the IF GOTO option. e.g. TABLE FILE Blah PRINT FLD1 -IF &TEST EQ '1' THEN GOTO 1Cont ; FLD2 FLD3 -1Cont FLD4 FLD5 BY FLD0 etc END Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Virtuoso |
Less than 4 months... and how much training, courses, ppt, pdf? Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
| Gold member |
Thanks a lot for all your help! I have taken Report Essential 1 and Report Essential 2 training from IBI and I have created 3 to 4 basic reports and also HTML. Regards, Niha WebFOCUS 8 Windows 7 HTML | |||
|
| Expert |
Sounds like you have been thrown in the deep end. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Master |
You have one other option. You could look at this like a guided adhoc report and pass the fields from the parent to the child report through the drill down. The child report would look something like this: TABLE FILE MYTABLE PRINT &MYFIELDS.EVAL BY FIELD1 BY FIELD2 ETC END This way you don't need to worry about GOTO's or anything like that. In your parent drill down you would just need to add MYFIELD="A B C D ETC" Eric Woerle 8.1.05M Gen 913- Reporting Server Unix 8.1.05 Client Unix Oracle 11.2.0.2 | |||
|
| Expert |
The other way is to generate comment variables to control what is seen.
-SET &FLD2Ctrl = IF {condition} THEN '-*' ELSE '' ;
-SET &FLD3Ctrl = IF {condition} THEN '-*' ELSE '' ;
TABLE FILE Blah
PRINT FLD1
&FLD2Ctrl.EVAL FLD2
&FLD3Ctrl.EVAL FLD3
FLD4
FLD5
BY FLD0
etc
ENDWaz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Gold member |
Thanks. Let see if it helps. Niharika WebFOCUS 8 Windows 7 HTML | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED]Need Help in the following code
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [CLOSED]Need Help in the following codeCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |