Home » Developer & Programmer » Reports & Discoverer » Particular column sum values to be hide (ORACLE 10G DB,REPORT BUILDER 6I)
Particular column sum values to be hide [message #431123] Sun, 15 November 2009 12:29 Go to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

./fa/7023/0/

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 298 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 Go to previous messageGo to next message
Littlefoot
Messages: 20827
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).
Re: Particular column sum values to be hide [message #431131 is a reply to message #431126] Sun, 15 November 2009 16:22 Go to previous messageGo to next message
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.
Re: Particular column sum values to be hide [message #431149 is a reply to message #431131] Sun, 15 November 2009 23:05 Go to previous message
ramoradba
Messages: 2454
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
Previous Topic: Want group column and its total in down side
Next Topic: how to make prametes as optional in reports 6i
Goto Forum:
  


Current Time: Sat Oct 01 16:12:29 CDT 2016

Total time taken to generate the page: 0.21224 seconds