sorry, couldn't go through the whole code ..it's too big for a quick look;

1)was this initially taking less time = If data is less , report generating . But with large data in tables it took more time ,

2) and now you are facing the issue with sp or it's the first run ?? = When i call to this sp from code behind it working . but getting time. If table data is less , then report generating( sp running quickly). But i don't no any other way to code without join table like this.

pls reply

thanks