OraFAQ Forum: Reports & Discoverer » Particular column sum values to be hide

Home » Developer & Programmer » Reports & Discoverer » Particular column sum values to be hide (ORACLE 10G DB,REPORT BUILDER 6I)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Particular column sum values to be hide [message #431123]

Sun, 15 November 2009 12:29

seyed456
Messages: 220
Registered: May 2008
Location: south india .

Senior Member

In the above image you can see the live previewer for the below query

SELECT   d.dname, e.job, SUM (e.sal)
         
    FROM emp1 e, dept1 d
   WHERE e.deptno = d.deptno
   and job in ('ANALYST','CLERK')
GROUP BY d.dname,
         e.job

The above report done in matrix style..
Dname as row,
Job as column
and sum(sal) as cell fields..

I wants to hide the sum(sal)values in the cell of the matrix for the clerk column.

Is it possible to do from report builder since i dont wants to do from query ?..

Thanks
Syed.

Attachment: CK.JPG
(Size: 20.79KB, Downloaded 1762 times)

[Updated on: Sun, 15 November 2009 13:24]

Report message to a moderator

Re: Particular column sum values to be hide [message #431126 is a reply to message #431123]

Sun, 15 November 2009 14:53

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Try conditional formatting; see what "Hide the Object" does. If it doesn't work, paint text to background color (white, by default).

Report message to a moderator

Re: Particular column sum values to be hide [message #431131 is a reply to message #431126]

Sun, 15 November 2009 16:22

seyed456
Messages: 220
Registered: May 2008
Location: south india .

Senior Member

Thanks LittleFoot.

I tried conditional formatting its working good.
But i dont need the blank space ..If i could do something for that it will be more perfect.Thanks.

Report message to a moderator

Re: Particular column sum values to be hide [message #431149 is a reply to message #431131]

Sun, 15 November 2009 23:05

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

seyed456 wrote on Sun, 15 November 2009 16:22

Thanks LittleFoot.

I tried conditional formatting its working good.
But i dont need the blank space ..If i could do something for that it will be more perfect.Thanks.

I did n`t get you properly....
You don`t want the blank space ...Then what you want...?

Do you want the vertical & horizantal Elasticity to contract Or You dont want the column Clerk to be print there?

Or for some possitions You want the column and for some not? Or you want the column heading only @ all possitions?

Sriram. Smile

Report message to a moderator

Previous Topic:	Want group column and its total in down side
Next Topic:	how to make prametes as optional in reports 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 08 19:48:15 CST 2025