Dears
I have a Report in which i have 1 Parameters in this report i want data as on my requirement like
select * from emp;
EMPNO ENAME MGR SAL COMM DEPTNO
--------- ---------- --------- --------- --------- ---------
7369 SMITH 7902 800 20
7499 ALLEN 7698 1600 300 30
7521 WARD 7698 1250 500 30
7566 JONES 7839 2975 20
7654 MARTIN 7698 1250 1400 30
7698 BLAKE 7839 2850 30
7782 CLARK 7839 2450 10
7788 SCOTT 7566 3000 20
7839 KING 5000 10
7844 TURNER 7698 1500 0 30
7876 ADAMS 7788 1100 20
7900 JAMES 7698 950 30
7902 FORD 7566 3000 20
7934 MILLER 7782 1300 10
14 rows selected.
in a report i have 1 parameter which is based on 2 Columns (1) is SAL (2) is COMM if i select SAL report should be based on SAL or if i select COMM report should be based on COMM please help me in this query il be great full to you all.
Thanks
Cheers
Report Parameter Based on 2 Columns
Hi,
You are saying the report should be based on SAL or COMM.
Do you mean that you need to group by SAL or COMM according to the selected value or is it some thing else.
Can you please elaborate your requirement in more detail.
<font color="blue"><b>Best Regards & Thanks,
Arun Reddy[:)]</b></font id="blue">
You are saying the report should be based on SAL or COMM.
Do you mean that you need to group by SAL or COMM according to the selected value or is it some thing else.
Can you please elaborate your requirement in more detail.
<font color="blue"><b>Best Regards & Thanks,
Arun Reddy[:)]</b></font id="blue">
Exactly I want as you say
my query is
select * from emp
where sal > 2000
or
where Comm > 500
then i use both 2 fields in a parameter
SAL
COMM
when i select SAL this query show result
select * from emp
where sal > 2000
and when i select COMM this query show result
select * from emp
where COMM > 500
I Hope you got it
Please Guide me
Thanks
Najm
my query is
select * from emp
where sal > 2000
or
where Comm > 500
then i use both 2 fields in a parameter
SAL
COMM
when i select SAL this query show result
select * from emp
where sal > 2000
and when i select COMM this query show result
select * from emp
where COMM > 500
I Hope you got it
Please Guide me
Thanks
Najm
Use the Lexical Reference for your required query
topic.asp?TOPIC_ID=84
topic.asp?TOPIC_ID=84
Who is online
Users browsing this forum: No registered users and 7 guests