OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » MATRIX Report (Report builder 6i)

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

MATRIX Report [message #482307]

Thu, 11 November 2010 00:26

fraction
Messages: 29
Registered: November 2010
Location: Pakistan

Junior Member

I want to Bold the value with highest value in Numeric field.
Please tell me how can i do this.

Thanks.

/forum/fa/8426/0/

Attachment: report.JPG
(Size: 24.83KB, Downloaded 1971 times)

Report message to a moderator

Re: MATRIX Report [message #482315 is a reply to message #482307]

Thu, 11 November 2010 01:02

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

IF the report contains two similar and Max values like (300 and 300) then?
Please show Us What you tried so far, So that we wil help you

Sriram

Report message to a moderator

Re: MATRIX Report [message #482317 is a reply to message #482307]

Thu, 11 November 2010 01:07

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

Senior Member
Account Moderator

Conditional formatting is what you are looking for.

Here's an example based on Scott's schema.

I created a matrix report (using Report wizard). Query is a simple one: employees are "rows", departments are "columns", salaries are "matrix cells":

select deptno, ename, sal
from emp

I told wizard that I want it to calculate "Maximum" for the SAL field. It created summary columns "per department" (that's the one I'm interested in); the rest ("per report" and "per ename") can be deleted as we don't need them.

In Layout Editor, I deleted all summaries (as I don't want to display those values - I just want to highlight matrix cell that is equal to "maximum salary per department").

This is how a Data Model looks like:

/forum/fa/8427/0/

Layout:

Conditional formatting for the "F_sal" field:

sal is equal to :MaxD

(note a colon (:) sign in front of MaxD!). I chose it to be "bold" and "red".

/forum/fa/8429/0/

Run the report; this is the result:

/forum/fa/8430/0/

Attachment: rep_matrix_10.PNG
(Size: 4.56KB, Downloaded 2157 times)
Attachment: rep_matrix_11.PNG
(Size: 6.11KB, Downloaded 2019 times)
Attachment: rep_matrix_12.PNG
(Size: 17.03KB, Downloaded 2092 times)
Attachment: rep_matrix_13.PNG
(Size: 10.98KB, Downloaded 2103 times)

Report message to a moderator

Re: MATRIX Report [message #482355 is a reply to message #482317]

Thu, 11 November 2010 02:59

fraction
Messages: 29
Registered: November 2010
Location: Pakistan

Junior Member

sorry, but now i have to calculate on MIN value.
if both values are MIN like 300,300, Bold both.

i havent tried so far...
but i tried littlefoot method shown above.
I think in this way my problem can be solved, but another problem is, now when i tried to open report wizard nd want to make new min group, report builder shutdowns.
Now i can bold price by fix way like bold value when price=300. it works but its not the solution.

[Updated on: Thu, 11 November 2010 03:13]

Report message to a moderator

Re: MATRIX Report [message #482371 is a reply to message #482355]

Thu, 11 November 2010 03:41

fraction
Messages: 29
Registered: November 2010
Location: Pakistan

Junior Member

Thanks.
i got the solution. i made a summary colum, where i get the min price. thn in formatting, i gave the condition price=min.
its working... but not the i want. it bold the value sometimes nd sometimes dony.

Report message to a moderator

Re: MATRIX Report [message #482384 is a reply to message #482371]

Thu, 11 November 2010 04:02

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

Senior Member
Account Moderator

Quote:

it bold the value sometimes nd sometimes dony.

I'll buy a drink for everyone (*) who translates this to something understandable.

_________________
* first time we meet

Report message to a moderator

Re: MATRIX Report [message #482388 is a reply to message #482384]

Thu, 11 November 2010 04:06

cookiemonster
Messages: 13960
Registered: September 2008
Location: Rainy Manchester

Senior Member

It sometimes bolds the value and sometimes doesn't.

I assume.
Which is understandable but gets us nowhere.

@fraction - you've got something wrong, but without knowing exactly what you did we really can't tell where the mistake is.

Report message to a moderator