Hi,

If you are using SSRS 2005 then edit values field in Data tab of chart properties as follows.

x =Fields!Store.Value

Y =Fields!Region.Value

Size = Fields!Sales.Value (If u want sum u can...

I think it is possible in 2008. Unfortunately in 2005 I couldn't find any such properties. I even tried changing the position to the bottom and made it as row...

Hi Pravin,

Do you want to perform grouping in sql query or else in your report layout?

Hi,

Is your balnk data "-" depends on any other column in the table? If so we can write some Iff conditions to display blank in that table.

Hi,

The you use union operator in your query in datatab resolves your problem.

for instance here is the sample query based on your example

Select Col4, Col2, Col3 from table

Union

Select Col1, Col2,...

Hi Sank,

Thanks for your response.

My exact problem is if my series label is too lengthy its not visible properly in the output because of legend table width. And I couldn't...