--->I have table emp with columns empno,empname,deptno,deptname
--->I have Custimze a report by passing deptname as an inpout parameter.
--->Here I am going to pass five parameters(all values are coming form Deptname column)
p1(Operations Deptname)
p2(sales Deptname)
p3(Research Deptname)
p4(Banking deptname)
p5(Purchasing Deptname)
--->Here p1 parameter is must and the remaining parametrrs are Optinal
--->Conditions
1)If we will pass p1 and p2 then we have to get p1 and p2 related data .
2)If we will pass p1,p2,p3
3)If we will pass p1,p2,p3,p4.
4)If we will pass p1,p2,p3,p4 and p5
5)P1 ==>value
p2 ==>null
p3 ==>null
p4 ==>null
p5 ==>null
6)P1 ==>value
p2 ==>null
p3 ==>value
p4 ==>null
p5 ==>null
7)P1 ==>value
p2 ==>null
p3 ==>null
p4 ==>null
p5 ==>value
How to implement the same in report builder 6i
How to Implement this report
-
- Posts: 40
- Joined: Sat Mar 01, 2008 3:39 pm
- Location: India
Who is online
Users browsing this forum: No registered users and 0 guests