Home » Developer & Programmer » Reports & Discoverer » conditional formatting
conditional formatting [message #290662] Mon, 31 December 2007 01:20 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: conditional formatting [message #290677 is a reply to message #290668] Mon, 31 December 2007 01:44 Go to previous messageGo to next message
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
Re: conditional formatting [message #290680 is a reply to message #290677] Mon, 31 December 2007 01:47 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: conditional formatting [message #290815 is a reply to message #290662] Tue, 01 January 2008 01:01 Go to previous messageGo to next message
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
break on ename;
select ename,sal from emp
order by ename;
Re: conditional formatting [message #290840 is a reply to message #290815] Tue, 01 January 2008 07:02 Go to previous message
Littlefoot
Messages: 20901
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.
Previous Topic: How can i see the parameter form before run the report in 9iR1as environment
Next Topic: Report layout
Goto Forum:
  


Current Time: Sat Dec 10 22:40:56 CST 2016

Total time taken to generate the page: 0.07489 seconds