Home » Developer & Programmer » Reports & Discoverer » getting missing numbers in report
getting missing numbers in report [message #315432] Mon, 21 April 2008 08:33 Go to next message
RAY_HT
Messages: 153
Registered: May 2005
Location: Giza
Senior Member

dear All

i need to retrive missing vouchers in report.
i wrote this statment and it's working in sqlplus

with
minmax as ( SELECT 1 minval, 1 maxval FROM dual ),
numbers as (
select minval+level-1 num
from minmax
connect by level <= maxval-minval+1

select num
into x from numbers
minus
select shipv_no from shipping_voucher
order by 1;

i need to put it in report , how can i do that
when i add it as sql-group or ref-cursor it is not allowed

any advice ??
Re: getting missing numbers in report [message #315463 is a reply to message #315432] Mon, 21 April 2008 10:00 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
I'm not sure what you mean. You say:
Quote:
when i add it as sql-group or ref-cursor it is not allowed

I can't see any ref cursor in the code you posted.

Furthermore, using "into" implies PL/SQL whereas the rest of your code is SQL. And you use
from numbers

although you don't define numbers earlier on, you do define a "minmax" with as query, but you don't refer to it further on.

Could you perhaps try to explain in words what you are trying to accomplish?
Re: getting missing numbers in report [message #315465 is a reply to message #315432] Mon, 21 April 2008 10:06 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Would you mind to read the OraFAQ Forum Guide and learn how to PROPERLY ask a question?

Missing vouchers? What vouchers? Where can they be found? Where are CREATE TABLE along with sample INSERT INTO statements? When do you plan to format your code (using the [code] tags)?
Previous Topic: Converting columns into rows
Next Topic: Display Chinese characters in PDF report developed in D2K
Goto Forum:
  


Current Time: Fri Dec 09 05:58:26 CST 2016

Total time taken to generate the page: 0.05488 seconds