Challenging Experts [message #297484] |
Fri, 01 February 2008 00:28 |
satish_dba
Messages: 9 Registered: February 2008 Location: BANGALORE
|
Junior Member |
|
|
Hi Experts,
Here i'm facing one problem in Reports 6i. I'm getting data from query using union all. In which i'm able to get data from single column , but bifurcating based on flag i.e F,V ( F- Fixed,V-variable).
my problem is to get 0 (zero) where ever data is not there.
for example:
amount ---- flag
1000 ---- F
2000 ---- F
3000 ---- V
4000 ---- V
5000 ---- V
I supposed to get data like
F ---- V
1000 ---- 0
2000 ---- 0
0 ---- 3000
0 ---- 4000
0 ---- 5000
but i'm getting some space at 0 (zeros). like
F ---- V
1000 ----
2000 ----
---- 3000
---- 4000
---- 5000
please help me anyone to comeout of this
please
please
Regards,
SATISH
[Updated on: Fri, 01 February 2008 02:22] Report message to a moderator
|
|
|
|
|
|
|