I actually just did that as i got your reply, getting back the correct data with that code as well.

Ok so i've run the profiler and it's definitely passing in the correct data to the stored proc.

Where do i go from here?

Just to be clear you mean the dev reporting server?

Unfortunately i may not have access to this so i might have to get someone else in my department to...

I've not used profiler before. I've got it up, i'm just not sure how to run it. I can't find a good "How To" example on the web.

Am i...

srichaitya (6/15/2011)

---

When i previewing the reportgetting below error:

"Conversion failed when converting datetime from character string"

The query in the dataset1:

Select f1,f2,f3

from tablename

where date=@Year and date=@Monthname

dataset2:

select datepart(yyyy,date) from table

dataset3:

select datename(month,date) from table...

I ran into this problem a little while ago and mine had to do with permissions and how i had granted permissions within the stored proc of the report. So...

The problem i believe you're running into is that it's a calculated field. You would be able to do your calculation in say a text box or something of that...

On this i think you would simply just need to drag your names field into the area of the chart where it says "Drop Series Field Here" and your other...

I'd say try a matrix or tablix and group by Publications.

Then for the report title, you coul try something like

=Join(Fields!Publication.value, ", ")

or whatever your publications field name...