(1). 1st is how to add callendar in report 6i.
(2). 2nd question is why "ORDER BY dbms_random.value" not
working in form 6i my problem is this that i am developing application regarding electronic balloting system it means quizz program.

my example code is this which i make on when button pressed on canvas

DECLARE
C VARCHAR2(10);
CURSOR C1 IS SELECT *
FROM (SELECT empno FROM EMP
ORDER BY dbms_random.value)
;
BEGIN
FOR A IN C1 LOOP
c:=a.EMPNO;
synchronize;
END LOOP;
END;

thnaks for reply
yes you are right it does'nt work i think its not compatible with forms 6i what else should i do can u give me some idea

actually i took emp table for example i took empno on canvas
on button pressed i put this code what it should do counter should run i mean loop will execute untill unless i will not stop this loop i mean it will be infanite loop but data will be in loop it will be randome wise

as far as concern calendar for form 6i there is no problem to add calendar in forms 6i but problem is to add calendar in report 6i i tried to find some threads but not for report 6i all are for forms 6i

sorry check code there will be one excess end loop; pls remove it. anyway let me clear you complete scnario this was a example form actually this should work like this

loop will be infanite untill unless we will not press any button user will press the button one of the no. will display in other text_item which will be winner like as i mentioned before electronic balloting system then again we will press butt counter will start for 2nd position. I hope you will understand my problem

You probably haven't got an answer yet because your problem description is less than clear.
I suspect what you need is a database function that returns a random emp record. Or just the primary key of a random record which you can then query in the form.

If that's not what you need then you need to restate your problem a lot more clearly than you have done.

As for the calendar issue - I assume you want this for a parameter. Just create a form to specify the parameters and use the calendar in that.