Thanks Wayne. I am actually running the rep thru query but will soon change it to SP based on your hints.

And abt that WITH(NO LOCK), i am not sure why it is used. i am new here and in each and every query they have written it.

can you explain what is it and wht are its merits and de-merits?

And I have one more prob now:

I have a report which calls another report for details.

(like i have given the "jump to report" option.

Now i am not getting how to match the parameters between the reports.

In my Recruitment report, we will display the total vacancies in a particular co.

in the detail report, we will display the requirement title, no. of posts open, exp reqd and so on.

Now company id of my master report must match with that of detail. how to do?