I just figured it out, thanks

Thank you so much Jason. it was a typo and I added a space...

Finally I managed to do it. I had to modify my stored proc and used Inscope function in ssrs.

Greatly appreciate your willingness to help. I just couldn't explain whole...

Thanks.

=iif(Fields!ID.Value =5,

max(Fields!freq.Value), sum(Fields!freq.Value))

This is in the data cell of matrix

1,2,3,4 IDs are for c1,c2,c3,c4

C5 has Id =5

Thanks, I hope I could do that, but the company policies do not allow me.

I am using the same formula , you mentioned, to get all C5 values in my proc, so that I dont have to do any calculations in SSRS.

and I only...

MAtrix ! C1 - C2 - C3 - C4 - C5

----------------------------------------------------

11/2/2011 ! 1 -...

all C1 c2 c3 cr c5 columns come from one single column in my stored proc.

I have not been able to put the way you mentioned in SSRS. ...

Ninja's_RGR'us (11/16/2011)

SQL_Nw (11/16/2011)

Hi Ninja , I could not find data driven subscription tab in my...

Yes, but thats in 2005, in ssrs 2008 there are options of specifying landscape/portrait by hitting appropriate radio button , then one doesnt need to specify length/width

Hi Ninja , I could not find data driven subscription tab in my report manager.

I...

A million thanks...Your solution /data set query looks great. I am using your dataset query and have put subscription for testing.

I am not aware about data driven subscriptions. It...

Do you mean I need to make changes in stored proc? I cant do that.

How can I do it in ssrs only. Any leads please..

Thanks for your reply.

I added defaults for @report_start and @report_end as for yesterday 24 hours 00:00 to 23:59, but even If i schedule it every 8 hours, the report...

Thanks I am trying to work it out