Home » Developer & Programmer » Reports & Discoverer » Need summary column in the attached 10g RDF file. (ORACLE 10G DB,REPORT BUILDER 10g)
Need summary column in the attached 10g RDF file. [message #431786] Thu, 19 November 2009 08:17 Go to next message
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 192 times)
Re: Need summary column in the attached 10g RDF file. [message #431788 is a reply to message #431786] Thu, 19 November 2009 08:19 Go to previous messageGo to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

Herewith am attaching a screenshot which explains u in detail.


./fa/7047/0/
Re: Need summary column in the attached 10g RDF file. [message #431952 is a reply to message #431788] Fri, 20 November 2009 03:42 Go to previous messageGo to next message
ramoradba
Messages: 2454
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
Re: Need summary column in the attached 10g RDF file. [message #431990 is a reply to message #431952] Fri, 20 November 2009 05:28 Go to previous messageGo to next message
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.
Re: Need summary column in the attached 10g RDF file. [message #432093 is a reply to message #431990] Sat, 21 November 2009 01:52 Go to previous messageGo to next message
ramoradba
Messages: 2454
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
Re: Need summary column in the attached 10g RDF file. [message #432095 is a reply to message #432093] Sat, 21 November 2009 02:04 Go to previous messageGo to next message
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..
Re: Need summary column in the attached 10g RDF file. [message #432099 is a reply to message #432095] Sat, 21 November 2009 02:29 Go to previous messageGo to next message
ramoradba
Messages: 2454
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
Re: Need summary column in the attached 10g RDF file. [message #432101 is a reply to message #432099] Sat, 21 November 2009 03:33 Go to previous message
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
Previous Topic: Hiding non printing characters
Next Topic: Reference matrix cell fields
Goto Forum:
  


Current Time: Sun Sep 25 04:15:57 CDT 2016

Total time taken to generate the page: 0.15697 seconds