Could you give details what the issue was and how you fixed it.

Thank you

jvanderberg (8/4/2010)

---

Ganesh has lead you down the right track. That is exactly what you need to do.

However, I usually take it a step further. When they select ALL...

Hi,

With respect to parameters you can a specify a list of values that can be entered by using the options in parameter definition window. I don't think you can perform...

I agree with Ganesh's post, use the JOIN function:

=Join(Parameters!state.Value,",")

Thank you Dan for the reply.

malavika.ramanathan (5/26/2010)

---

Hi,

Thanks for the reply. This is what i tried earlier then i felt matrix report would be better..

the screen shot i have sent you is of matrix report......

the one...

malavika.ramanathan (5/25/2010)

---

hi i tried the way you had mentioned.... it is showing totals for each status.

Thanks ...

but my prob is data is still incorrect....

here i dont have permit to...

i thought that was what i asked earlier, anyway in report builder, first choose status as the group using the Sort and Group option on the toolbar.

Then Under Report option...

Ok, check this out: look at how the column group has been defined:

This should give a good idea

are you using ssrs 2008?

You might have to explicity define it, dragging columns does not create groups automatically.

malavika.ramanathan (5/25/2010)

---

btw, i tried the same using matrix report and this seems to be better...

this is giving me the o/p in desired format.

now i need to fix these total issue....

it...

Would it be better just to use regular reporting services instead of report builder. With SSRS you could do better groupings/write stored procs which could offer more flexibility.

Hi,

Since you are using report builder 1.0, you need to first create a report model, this is usually done based on a data source view. The data source view is...

Hi,

Are you using report builder version 2.0 or version 1.0. There is a difference between both the versions, 1.0 came with sql 2005, 2.0 came with sql 2008. Version 2.0...