| help - [message #83053] |
Thu, 31 July 2003 13:37  |
geetha
Messages: 20
Registered: August 2000
|
Junior Member |
|
|
I'm developing a report which consists a query, it incudes 5 queries by union. in the report i would like to print the serial number, if i take the rownum it is repeating as the query returns rows from different queries. i should get the serial number in sequence for all the rows.
please let me know is any of you have any sugessions?
|
|
|
|
| Re: help - [message #83059 is a reply to message #83053] |
Fri, 01 August 2003 02:45  |
lars
Messages: 11
Registered: July 2002
|
Junior Member |
|
|
Maybe this will help :
select rownum, field a, field b, field c ...
from
(
-- put your original query here
select field a, field b, field c ... from X
union
select field a, field b, field c ... from Y
)
|
|
|
|
| Re: help - [message #83070 is a reply to message #83059] |
Sun, 03 August 2003 03:25 |
prashant
Messages: 122
Registered: September 2000
|
Senior Member |
|
|
Geeta,
What you can do is that in the report data model make a calculated column and use the count function and any field as source.
I guess that would help u
Thanks
Prashant
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
