Home » Developer & Programmer » Reports & Discoverer » Rank calculation in Reports (reports 6i)
Rank calculation in Reports [message #608457] Wed, 19 February 2014 23:48 Go to next message
shahzad-ul-hasan
Messages: 600
Registered: August 2002
Senior Member
Dear
i want to calculate the Rank of the students on the basis of total obatin marks as shown in the figure. how i can use the Rank formula (in formula column to get this result).

/forum/fa/11711/0/
  • Attachment: 1.JPG
    (Size: 166.56KB, Downloaded 680 times)

Report message to a moderator

Re: Rank calculation in Reports [message #608459 is a reply to message #608457] Thu, 20 February 2014 00:09 Go to previous messageGo to next message
Littlefoot
Messages: 21713
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I think that you can't do that within the formula column (but you might do it within the main report's query).

Report message to a moderator

Re: Rank calculation in Reports [message #608521 is a reply to message #608459] Thu, 20 February 2014 08:07 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 600
Registered: August 2002
Senior Member
with database trigger it can be possible????
or
or any other idea.???

Report message to a moderator

Re: Rank calculation in Reports [message #608528 is a reply to message #608521] Thu, 20 February 2014 08:26 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
How did you get to database triggers?
LF is suggesting you use the rank analytical function in the main report query.

Report message to a moderator

Re: Rank calculation in Reports [message #608544 is a reply to message #608528] Thu, 20 February 2014 14:07 Go to previous message
Littlefoot
Messages: 21713
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Uh, no ... no analytical functions here, it is Reports 6i that can't use them.

It appears that you'll have to create a view which will calculate all values you are interested in, and report will just display these values (a simple "select * from that_view").

Report message to a moderator

Previous Topic: one report contain (Add_Parameter(pl_id,'Q_OM',DATA_PARAMETER,rg_name)) doesn't work
Next Topic: Read WHERE clause from TXT file. Possible?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 18 00:41:35 CDT 2022
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.