Hi Bhuvnesh,

Thanks for the reply. I will look into the code in detail.

i think the prob is with the 1st line.....

select distinct a.rid, a.username......

the DISTINCT keyword here is filtering records...

i have two user ids 1 and 4 ......

1 has only one record.......

Hi Ramdas,

Thanks for the reply.

Yes the report functions in the same way you mentioned it....

i am passing fields userid and clientid instead of parameters.

now i have 9400 clients in my...

oh m sorry...

anyway thanks for your reply....

hi,

thanks for your reply. i dont think it works practically as there are many possible durations...or even if we think of 5 min duration the least, i will have to...

Hi,

Yes the requirement is the same as you have mentioned.

I have written SP for that.

Now, i am facing one more prob. I have kept the client id of each row...

Hi All,

I would like to know if the above method causes performance issues....

this is for a Resume Application and hence hundreds of users will try to generate the report simultaneously....

Imagine...

Hi All,

For test purpose i tried the method we discussed above...

i kept both USER and CLIENTS parameters default ALL.

so my query run for ALL USERS and ALL CLIENTS for a...

Yes even i thought that would suffice the requirement...

but what my manager says is, when you make default ALL and run report,

2000 values will be passed to the proc.......

Hi,

That works well but my req is not that... sorry for this.

the prob is the application they have made is such....

Now, while choosing parameters itself i must write a condition.

In...

Hi,

I tried some methods for this. I kept a 'Select ALL' option and tried. It works fine but in that case i cant make it multi-valued parameter.....

And if i make...

Can i make the parameter multi-valued while doing this?

actually there is a report which they have designed in .Net i must now bring in same features for this...

thanks for the reply. could you please give more details on this?

Hi Rob,

Thanks for the reply. Yes as you said, the issue is with the browser.

In IE 8 it is shown correctly ...other browsers, we must scroll....

thanks

Hi All,

Thanks for your reply.

Now i have made the conv in my SP itself as Raunak has suggested.

But earlier i have used cdate many times without any prob, but...