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
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
January 05, 2010, 02:11 PM
ramakrk
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)
January 05, 2010, 02:28 PM
GinnyJakes
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.