In ssrs 2008 you can try this. Hit design tab on report> click report>report properties> page setup > you can choose landscape or portrait radio button

http://imageshack.us/photo/my-images/443/printstyle.png

Thank you sooooo much Grant, Dwain and Clive. This forum is awesome...

you can try,

(select * from dbo.SplitParameterValues(@Team,CHR(255)))

then in the tablix properties of your report> go to dataset properties> parameters

> add

= Join(Parameter!team.value,char(255)))

Thank you Sean. Very simple and informative article.

Thank you Everyone. Greatly Appreciate it. Learned a lot.

Thanks.

Any ideas?? thanks

Thanks, how do I do it? In the dataset NAme or in the proc?

something like this?

@Pararm =Replace( Parameters!Param.Value, "'", "''" )

yes it is for sure on the report's end. Any idea how to fix that? thanks

Thank you all.

Thank you Anthony. Greatly appreciate your help on this.

Thank you Anthony,

I just tried that and saw what you are talking about

Actually there are some more details to the dataset. Please see below. there are multiple charts...

Thank you Anthony.

I think the series option second graph might work for me. How should I achieve that. I dragged and dropped amount field in Series area but my graph...

I figured it out..Thanks everyone !!

Thanks for the reply,

Actually the data need to be filtered as

dateordered between @start and @end

Shipped_on has no significance here...

Thanks for the reply

Yes, I did that , making date ordered a sepearte column as datetime and then inserting values in that, I filtered bad data as well using isdate()...