Home » Developer & Programmer » Reports & Discoverer » how display record no in report
how display record no in report [message #198174] Mon, 16 October 2006 00:32 Go to next message
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
Re: how display record no in report [message #198180 is a reply to message #198174] Mon, 16 October 2006 01:11 Go to previous messageGo to next message
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
Re: how display record no in report [message #198182 is a reply to message #198180] Mon, 16 October 2006 01:19 Go to previous messageGo to next message
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
Re: how display record no in report [message #198188 is a reply to message #198182] Mon, 16 October 2006 02:12 Go to previous messageGo to next message
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
Re: how display record no in report [message #198204 is a reply to message #198188] Mon, 16 October 2006 03:01 Go to previous messageGo to next message
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
Re: how display record no in report [message #198215 is a reply to message #198204] Mon, 16 October 2006 03:46 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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)?
Re: how display record no in report [message #198229 is a reply to message #198204] Mon, 16 October 2006 04:14 Go to previous messageGo to next message
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
Re: how display record no in report [message #198307 is a reply to message #198204] Mon, 16 October 2006 09:18 Go to previous message
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:
  


Current Time: Thu Dec 08 14:23:25 CST 2016

Total time taken to generate the page: 0.05173 seconds