Oracle Reports:Replace blank spaces with zero

[arr1]

Hello,

I have created an matrix oracle report. In which i'm getting blank spaces for the fields where i dont have data. can i replace these with a zero.

I tried the method provided on the documentation for "Building a Matrix Report".
But that works only if all the numbers in that field end in a zero. Else it superimposes that zero on top of the other numbers.

Please help me with this.

Regards
ARR

[debasisdas]

can you please post your code for my reference.

[arr1]

hi debasisdas,

putting the code in forum wouldnt be possible for me,
but my query is quite similar to the single matrix query example at the following link
http://download.oracle .com/docs/cd/B14504_01/dl/bi/B10602_01/orbr_matrix.htm

just try the example with salaries figures which do not have any zeros in them.
you may use the folowing insert scripts
INSERT INTO EMP ( DEPTNO, JOB, SAL ) VALUES (
20, 'Analyst', 5675);
INSERT INTO EMP ( DEPTNO, JOB, SAL ) VALUES (
20, 'Clerk', 56756);
INSERT INTO EMP ( DEPTNO, JOB, SAL ) VALUES (
20, 'Manager', 5676);
INSERT INTO EMP ( DEPTNO, JOB, SAL ) VALUES (
20, 'Salesman', 65756);
INSERT INTO EMP ( DEPTNO, JOB, SAL ) VALUES (
30, 'Manager', 56756);
INSERT INTO EMP ( DEPTNO, JOB, SAL ) VALUES (
30, 'Clerk', 5645);
INSERT INTO EMP ( DEPTNO, JOB, SAL ) VALUES (
20, 'Analyst', 34545);
INSERT INTO EMP ( DEPTNO, JOB, SAL ) VALUES (
10, 'Analyst', 12122);
COMMIT;


thanks,
arr

[debasisdas]

May i know why cant you post your code.

have you ever tried for that.

if you scroll the page link provided by you in previous post you will get the answer.

[arr1]

oh nothing like that... just because of policy and rules. I cannot put the code anywher outside, I'm sorry for that. But my query is very similar to the query in the link i had provided.

Infact I have been trying on the same query, because my quey takes 10-15 min to execute. So working with a light query saves time too.
let me know, if you need anything else.

i have already tried the solution provided there. but it works fine for numbers ending in zeros. but not for non zeros numbers.

i tried things like checking property of that field, and setting a trigger. but nothing seems to work.

[arr1]

hello,

thank you for the help provided.
this particular problem wasdifficult to solve, and was taking a lot of time.
hence i modified the query to get the desired output.

thanks,
arr