For Programmers: Free Programming Magazines  


Home > Archive > Visual Basic Crystal Reports > May 2005 > passing a parameter??????









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author passing a parameter??????
Reny

2005-05-15, 3:59 pm

Hi ,
i am trying to create a Dynamic Top N Report in CR.NET as Oracle as
Backend.Can any one tell me how do i write the query to that i can pass the
parameter at run time?

I wrote one like this , but it is not working.
select
*
from
(select empno,sal,rank()
over (order by sal desc ) rnk
from emp)
where rnk <= {?N};
Can any one tell me how do i do it?

Reny


Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com