How to Dynamically set the width of report body.

I have a report where we display a certain number of columns based on
some condition. If I display all the columns then the report looks okay
but if I display fewer columns then there is empty space on each row
which would have otherwise been occupied by the hidden columns of the
table. Is there any way to dynamically set the width of the table and
the report body.
Thanks and I appreciate you taking the time.
S Girase
sgirase@.gmail.comyou could try building the report with a matrix.. it'll adjust the
number of columns based on the results.

How to do something like: SqlDataSource[nRow][nCol].Value ??

How do you get a record-set or something like it. I do not want to bind to any grids or display the data. I just need access to SQL Server tables.

What is the best way and where can I get some documentation and example code?

Thank's for any help

Then you do not need SqlDataSource. You can use SqlCommand/SqlDataReader/SqlDataAdapter etc. You can find lots of example from MSDN:

http://msdn2.microsoft.com/en-us/library/ms254937.aspx

How to do a join in multiple datasets

I have two datasets accessed from two different data sources.
I would like to display the report by doing a join between the two. How can
I achieve that?
This join can not take place at data source level.Man that's a tough one.
I wonder if you could set the reports' data source to a custom assembly
which brings the two data sources together?
Alternatively, I suppose you could link the two datasources through another
database say Access if that's an option.
HTH
Matt
"Gaurav" <Gaurav@.discussions.microsoft.com> wrote in message
news:A729C0A5-ECC4-4337-B88F-0DF072FA2202@.microsoft.com...
> I have two datasets accessed from two different data sources.
> I would like to display the report by doing a join between the two. How
can
> I achieve that?
> This join can not take place at data source level.
>