Hi, I have almost the same problem that in the original post ‘irehman’ having (every thing same except the WHERE clause), But in my case I have 4 different quires, same tables, same where clause but column are different.

I have to develop this report in D2K I am little confuse that how I should handle this. Is there any way to handle multi query d2k report? As I said consider exactly the original posting of 'irehman'.

I am used to develop single query report this is first time I have new challenge. Please help to resolve this issue.

E.g.

Q1: select ENAME col from emp
Where job = ‘ANALYST’
AND option = 1

Q2: select SAL col from emp
Where job = ‘ANALYST’;
AND option = 2

Q3: select HIREDATE col from emp
Where job = ‘ANALYST’;
AND option = 3

Q4: select EMPNO col from emp
Where job = ‘ANALYST’;
AND option = 4

Do I have to create 4 SQL separate queries under data model; do I have to link each other or what else I can do? User will be entering option (1 or 2 or 3 or 4) from the parameter run time.

Thanks in advance.