urgent: how to display missing data in a range. [message #424985] |
Tue, 06 October 2009 23:34 |
shaz
Messages: 182 Registered: June 2009
|
Senior Member |
|
|
Hi Gurus,
I want to create a report which will display the data which is not present in a range.
for example
There is a table m1 which contains serial as:
1
2
4
5
Expected result: The report should show the serial 3.
Please help.
|
|
|
|
Re: urgent: how to display missing data in a range. [message #425029 is a reply to message #425012] |
Wed, 07 October 2009 04:20 |
shaz
Messages: 182 Registered: June 2009
|
Senior Member |
|
|
Got the solution.
What I have done is I have executed a loop in the after param. form trigger, in that i checked for the given range of data and the missing data i fetched from the exception no_data_found.
I assigned the missing data in user parameter(using concatenation) and displayed that in a field.
Moreover, I will try your solution.
Thanks Little for your(as usual) quick response.
|
|
|