OraFAQ Forum: Reports & Discoverer » conditional formatting

Home » Developer & Programmer » Reports & Discoverer » conditional formatting

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

conditional formatting [message #290662]

Mon, 31 December 2007 01:20

roni_a180
Messages: 45
Registered: October 2007

Member

hi
i create a table emp1
and data format are

7900	JAMES	CLERK		7698	12/3/1981	950		30
7876	JAMES	CLERK		7788	5/23/1987	1100		20
7902	JAMES	ANALYST		7566	12/3/1981	3000		20
7566	JONES	MANAGER		7839	4/2/1981	2975		20
7654	JONES	SALESMAN	7698	9/28/1981	1250	1400	30
7839	KING	PRESIDENT		11/17/1981	5000		10
7844	KING	SALESMAN	7698	9/8/1981	1500	0	30
7788	MARTIN	ANALYST		7566	4/19/1987	3000		20
7698	MARTIN	MANAGER		7839	5/1/1981	2850		30
7782	MARTIN	MANAGER		7839	6/9/1981	2450		10
7934	MILLER	CLERK		7782	1/23/1982	1300		10
7521	SMITH	SALESMAN	7698	2/22/1981	1250	500	30
7499	SMITH	SALESMAN	7698	2/20/1981	1600	300	30
7369	SMITH	CLERK		7902	12/17/1980	800		20

now i want to generate a tabular report
here are 3 james , 2 jones etc

and i want to output is only ename and salary
that means

JAMES  950
       1100
       3000
jones  2975
       1250

etc

and not using in group by format

[EDITED by LF: added [code] tags to improve readability]

[Updated on: Mon, 31 December 2007 01:37] by Moderator

Report message to a moderator

Re: conditional formatting [message #290668 is a reply to message #290662]

Mon, 31 December 2007 01:31

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

Senior Member
Account Moderator

You are a member of this forum for almost three months now. Is there any special reason for not wanting to read and follow some basic guidelines written in the OraFAQ Forum Guide? There really isn't much to do - just include those [code] tags to improve readability.

Because, if you don't wont to do that for the rest of us, I really don't see a reason why should anyone reply to your questions.

As a sign of a good will, I will add [code] tags for you this time. Please, do it yourself in the future.

As of your question: create a query

SELECT ename, sal FROM emp

. In the Data Model editor, draw the 'ename' column out of its default group in order to create a separate group; now you'll have two groups: one with the employee name, and the second one with his salary. Use Report Wizard to help you create desired output (don't forget to select "group left" (or above) as the report layout.

That's all.

Report message to a moderator

Re: conditional formatting [message #290677 is a reply to message #290668]

Mon, 31 December 2007 01:44

roni_a180
Messages: 45
Registered: October 2007

Member

i know group by command

but i am not using group by
i want to use conditional formating
if one name is found then same name is not display but we are only see salary

Report message to a moderator

Re: conditional formatting [message #290680 is a reply to message #290677]

Mon, 31 December 2007 01:47

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

Senior Member
Account Moderator

Please, read my post once again. I never said anything about the GROUP BY clause. Creating a group in Reports Builder is a different term.

Report message to a moderator

Re: conditional formatting [message #290815 is a reply to message #290662]

Tue, 01 January 2008 01:01

mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi

Senior Member

break on ename;
select ename,sal from emp
order by ename;

Report message to a moderator

Re: conditional formatting [message #290840 is a reply to message #290815]

Tue, 01 January 2008 07:02

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

Senior Member
Account Moderator

Right, if we are talking about SQL*Plus. But we are not; this is the Reports Builder question.

Report message to a moderator

Previous Topic:	How can i see the parameter form before run the report in 9iR1as environment
Next Topic:	Report layout

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 09:42:22 CDT 2024