OraFAQ Forum: Reports & Discoverer » Need summary column in the attached 10g RDF file.

Home » Developer & Programmer » Reports & Discoverer » Need summary column in the attached 10g RDF file. (ORACLE 10G DB,REPORT BUILDER 10g)

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

Need summary column in the attached 10g RDF file. [message #431786]

Thu, 19 November 2009 08:17

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

Senior Member

Below is the query i have written for matrix with group

SELECT   d.dname, e.job, d.loc,SUM (e.sal)
FROM emp e, dept d
WHERE e.deptno = d.deptno
AND e.job in ('CLERK','MANAGER')  
GROUP BY d.dname,e.job,d.loc

Use scott schema since i was using that..
Am using d.loc as matrix group
e.job as matrix column
d.dname as matrix row
and sum(e.sal)as matrix cell field
in the total field am using sum(e.sal) again to find the total

Attachment: MODULE1.rdf
(Size: 52.00KB, Downloaded 1415 times)

Report message to a moderator

Re: Need summary column in the attached 10g RDF file. [message #431788 is a reply to message #431786]

Thu, 19 November 2009 08:19

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

Senior Member

Herewith am attaching a screenshot which explains u in detail.

/forum/fa/7047/0/

Attachment: find_columnsummary.JPG
(Size: 39.33KB, Downloaded 1734 times)

Report message to a moderator

Re: Need summary column in the attached 10g RDF file. [message #431952 is a reply to message #431788]

Fri, 20 November 2009 03:42

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

Senior Member

You can use summary column to hold that value which should be reset at report level.....

sriram Smile

Report message to a moderator

Re: Need summary column in the attached 10g RDF file. [message #431990 is a reply to message #431952]

Fri, 20 November 2009 05:28

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

Senior Member

I tried report level as well page level.It doesnt work for me.
Please can you add the summary column in the rdf file and attach over here..Am so curious to get this job done.

Report message to a moderator

Re: Need summary column in the attached 10g RDF file. [message #432093 is a reply to message #431990]

Sat, 21 November 2009 01:52

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

Senior Member

seyed456

you want both summary columns for Both jobs? or total summary for all?

sriram Smile

Report message to a moderator

Re: Need summary column in the attached 10g RDF file. [message #432095 is a reply to message #432093]

Sat, 21 November 2009 02:04

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

Senior Member

Not total summary ..see in the above image for only clerk job.

for the first column i need total value that is sum in the image .
Please help me..

Report message to a moderator

Re: Need summary column in the attached 10g RDF file. [message #432099 is a reply to message #432095]

Sat, 21 November 2009 02:29

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

Senior Member

In the image you pointed for two columns ....I didn`t get you properly what exactly your requirement.....

See the attached..IF that is not your requirement...Let me know.

Thats a sample matrix report. if you use cube in your query you will get that.if you want group totals also try that with matrix group.Ok.

sriram Smile

Attachment: Orafaq_report.RDF
(Size: 56.00KB, Downloaded 1427 times)

Report message to a moderator

Re: Need summary column in the attached 10g RDF file. [message #432101 is a reply to message #432099]

Sat, 21 November 2009 03:33

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

Senior Member

Thanks ram.

I was using matrix with group while using with group i find difficulty to find the sum of columns ..I mean column summary per job,.

I have seen your rdf file in that u have used matrix only.Since am not using the same report which i have been attached here.its the sample one .

Thanks again for supporting ,
Syed

Report message to a moderator

Previous Topic:	Hiding non printing characters
Next Topic:	Reference matrix cell fields

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 06:35:54 CST 2024