OraFAQ Forum: Reports & Discoverer » how display record no in report

Home » Developer & Programmer » Reports & Discoverer » how display record no in report

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

how display record no in report [message #198174]

Mon, 16 October 2006 00:32

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

hi master
sir rownum work in query but not work in report
sir how display record no in report
please give me idea
thanks
aamir

Report message to a moderator

Re: how display record no in report [message #198180 is a reply to message #198174]

Mon, 16 October 2006 01:11

shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan

Member

hi

rownum works in reports also

you should try again

by typing query as follows

select rownum,empno,ename from emp;

it will work because on my machine it is working

i hope you will find solution by this

regards

Muhammad Shahid Mughal

Report message to a moderator

Re: how display record no in report [message #198182 is a reply to message #198180]

Mon, 16 October 2006 01:19

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

thans for your relpy

brother i use group by functoin then rownum problum in group by

how i mention rownum in group by

please give me idea

thanks

aamir

Report message to a moderator

Re: how display record no in report [message #198188 is a reply to message #198182]

Mon, 16 October 2006 02:12

shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan

Member

hi
please show your code which you have given in report
then i shall try to solve your problem

regards

Muhammad Shahid Mughal

Report message to a moderator

Re: how display record no in report [message #198204 is a reply to message #198188]

Mon, 16 October 2006 03:01

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

hi
this is my code

select rownum,mfa.department,nvl(sum(amount),0) from
(SELECT departmentmfa.title AS department,chartofacc.title
,nvl(sum(debit),0)-nvl(sum(credit),0) as AMOUNT FROM voudetail,voumaster,chartofacc,departmentmfa WHERE voumaster.vno=voudetail.vno AND SUBSTR(voudetail.accid,1,2)='K2' AND voudetail.deptid=departmentmfa.deptid(+) AND voudetail.accid=chartofacc.accid and voumaster.entdate between :p_1 and :p_2
group by departmentmfa.title,chartofacc.title order by 1,2) mfa group by mfa.department order by mfa.department

thank

aamir

Report message to a moderator

Re: how display record no in report [message #198215 is a reply to message #198204]

Mon, 16 October 2006 03:46

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

Senior Member
Account Moderator

Did you consider creating a Summary column (and applying the COUNT function to the source column)?

Report message to a moderator

Re: how display record no in report [message #198229 is a reply to message #198204]

Mon, 16 October 2006 04:14

shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan

Member

salaam
dear aamir

i read your code

you are trying to get the summary of each row by getting rownum in group by clause

i think you want to get the serial number type column in your report for this

instead of using rownum you should make your report without
rownum and then

add a summary column in the data model of your report
in the detail group

set property of summary column
as follows

in the summary node select
1.function = count
2. source = primary key column
3. reset at = Report

then in layout model
insert a field in your desired frame
and set the source of that field = your summary column which you have made in data model

i am also uploading a rdf file for you download login with scott/tiger and view all the settings which i have done in it

i hope you will get the serial number of your records

regards

Muhammad Shahid Mughal

Attachment: sample_record_number.RDF
(Size: 72.00KB, Downloaded 1223 times)

Report message to a moderator

Re: how display record no in report [message #198307 is a reply to message #198204]

Mon, 16 October 2006 09:18

yogen
Messages: 39
Registered: October 2006
Location: UK

Member

how about this query

select rownum,department,sum from (
select mfa.department department,nvl(sum(amount),0) sum from
(SELECT departmentmfa.title AS department,chartofacc.title
,nvl(sum(debit),0)-nvl(sum(credit),0) as AMOUNT FROM voudetail,voumaster,chartofacc,departmentmfa WHERE voumaster.vno=voudetail.vno AND SUBSTR(voudetail.accid,1,2)='K2' AND voudetail.deptid=departmentmfa.deptid(+) AND voudetail.accid=chartofacc.accid and voumaster.entdate between :p_1 and :p_2
group by departmentmfa.title,chartofacc.title order by 1,2) mfa group by mfa.department order by mfa.department )

thank

Yogen

[Updated on: Mon, 16 October 2006 09:20]

Report message to a moderator

Previous Topic:	Layout not coming out properly on web
Next Topic:	Select Multiple Values

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 14:39:44 CST 2024