Home » Developer & Programmer » Reports & Discoverer » urgent: how to display missing data in a range. (reports 6i)
urgent: how to display missing data in a range. [message #424985] Tue, 06 October 2009 23:34 Go to next message
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 #425012 is a reply to message #424985] Wed, 07 October 2009 03:00 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Something like this might be one way to do that:
SQL> select * from m1;

    SERIAL
----------
         1
         2
         4
         5
         8
         9

6 rows selected.

SQL> select level
  2  from dual
  3  connect by level <= (select max(serial) from m1)
  4  minus
  5  select serial
  6  from m1;

     LEVEL
----------
         3
         6
         7

SQL>

For more suggestions, search SQL & PL/SQL forum - there've already been discussions about such a problem.
Re: urgent: how to display missing data in a range. [message #425029 is a reply to message #425012] Wed, 07 October 2009 04:20 Go to previous message
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. /forum/fa/2115/0/
Previous Topic: report 6i to report 10g problem
Next Topic: Convertig more than one reports in 10g
Goto Forum:
  


Current Time: Thu Mar 28 12:11:29 CDT 2024