Thanks.

I can (low, med, high) in one single column annd do the sorting but here I need to separate them in 3 columns because thats the way client wants it...:(...

Thanks Rich for pointing that out. I used stdev() and that time I did not know about stdevp(). but after reading your reply, I looked at my data, and...

Thanks a trillion Adrian. that worked llike a charm. Exactly what I was looking for. Thank you soooooooooooooo much.

thanks for your reply. This is the sample data , I get from my stored procedure, I was wondering inserting this result set into table variable/temp table how can...

Thanks for your reply.

I was able to do it using Pivot function in my code.

you may wanna set the visibility of those group conditionally.

right click group> edit group>visibility> write expression

iff(sum (field.value)>0, true, false)

& so on for respective groups..

My procedure worked 🙂

I spent almost 2 days trying to figure this out. I could not have done it without your advice.

thanks so much for your...

Thanks.

I used your query and it did break the column into 3 columns.

However the data is being replaced as 0:00 at most of the places.

While it...

Sorry, i was not clear, it will always be C1 c2 c3.

Thanks

No, it can change.

thanks.

Thanks for your reply, that looks good.

however still I am unable to do insert like that since that means I will have to manually insert data while it has...