Home » Developer & Programmer » Reports & Discoverer » Rank/Position Calculation. (6i Reports)
Re: Rank/Position Calculation. [message #632230 is a reply to message #632075] Tue, 27 January 2015 22:24 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 561
Registered: August 2002
Senior Member
waiting for any hint.
Re: Rank/Position Calculation. [message #632246 is a reply to message #632230] Wed, 28 January 2015 03:13 Go to previous messageGo to next message
cookiemonster
Messages: 13864
Registered: September 2008
Location: Rainy Manchester
Senior Member
Running the query against the test case data you provided gives the correct results as far as I can see.
 SNO OBTMARKS EXAMC           TOTMARKS SEE        SUBJECT       STUID DIS               POS       PERC
---- -------- --------------- -------- ---------- ---------- -------- ---------- ---------- ----------
   1    40.00 1st Term Exams        50 KG/A       English          22  ALI                1 80.7142857
   1    33.00 1st Term Exams        50 KG/A       English          23  ABB                2 70.7142857
   2    25.50 1st Term Exams        50 KG/A       Math             24  AII                3         55
   2    25.00 1st Term Exams        50 KG/A       Math             24  AII                3         55
   2    33.00 1st Term Exams        50 KG/A       Math             23  ABB                2 70.7142857
   2    33.00 1st Term Exams        50 KG/A       Math             22  ALI                1 80.7142857
   3    40.00 1st Term Exams        40 KG/A       Urdu             22  ALI                1 80.7142857
   3    33.00 1st Term Exams        40 KG/A       Urdu             23  ABB                2 70.7142857
   3    25.50 1st Term Exams        40 KG/A       Urdu             24  AII                3         55


You need to supply some data that'll cause the query to give the wrong results.
Post it directly in the thread in code tags, rather than as a file - some people can't/won't download them.
Re: Rank/Position Calculation. [message #632247 is a reply to message #632246] Wed, 28 January 2015 04:20 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 561
Registered: August 2002
Senior Member
Sir, its shows accurate result on SQL. but in reports it shows this./forum/fa/12480/0/
  • Attachment: 1.JPG
    (Size: 151.37KB, Downloaded 218 times)

[Updated on: Wed, 28 January 2015 04:20]

Report message to a moderator

Re: Rank/Position Calculation. [message #632248 is a reply to message #632247] Wed, 28 January 2015 04:24 Go to previous message
cookiemonster
Messages: 13864
Registered: September 2008
Location: Rainy Manchester
Senior Member
Well the last query you supplied can't possibly give the above output.
So you need to supply the query(s) (and formula columns if applicable) that the report is actually using.
Previous Topic: how to get the values asc order??
Next Topic: drill down reports in oracle reports10g
Goto Forum:
  


Current Time: Sun Apr 05 22:15:38 CDT 2020