 |
|||||
|
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [CLOSED] conditional printing | Login/Join |
| Gold member |
I have a report in which I should show only the missing numbers.. I get a sequence of numbers from the query. I need to print the missing numbers I tried using NOPRINT and PRINT with in the IF condition that doesnt work Any suggestions Thanks RamThis message has been edited. Last edited by: Kerry, WebFOCUS 762 Windows To be decided(All formats) | ||
|
| Expert |
How do you know they are missing? Are you doing a join? Is the table relational with MISSING=ON for the number you are trying to print? You aren't giving us a lot to go on here. Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google | |||
|
| Virtuoso |
What exactly is it that you need to do? Remember, that webfocus cannot show data that is not there just like that. If you need that, then you would have to provide a complete list of numbers, compare these with the database numbers and filter out which are present, thereby printing those that are not... This is a method much like the McGyver technique. There is a lot of info on that technique to be found on this forum. GamP
| |||||||||
| ||||||||||
| Gold member |
I get a list of ticket numbers issued from the stored procedure and these are all in sequence. For auditing purposes We need to generate a report with missing numbers only I am currently comparing IF Value EQ last 'Value'+1 (I converted Value to integer type) I dont want to print value if the above condition is true and will print the numbers between them if the condition is false Is there another approach to this. I cannot change the SP or the Joins I do not control that part. I am only converting from crystal reports to Webfocus WebFOCUS 762 Windows To be decided(All formats) | |||
|
| Expert |
Doing what Gam has suggested, when you get your list of numbers, determine what the highest and lowest values are and SAVE them in a file. Use Dialogue Manager -REPEAT and -WRITE to write a file of all numbers between the lowest and highest values. You will need to write a master for this file. Join this file with all the numbers to the file you get back with the list of ticket numbers. Use SET ALL=PASS and a dummy where condition to get all the ones that don't have a match. You can look all of this up in the language manual. Or if you list of ticket numbers has only one row per number, use MATCH FILE and OLD-NOT-NEW. I am guessing you don't know WebFOCUS very well. Some training might be in order.  Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google | |||
|
| Expert |
If this report is run on a regular basis, how will you know if there are missing tickets between runs ? You may have to keep the last ticket number from the previous run to do this. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 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 |