dynamic column population?

Hello I'm new to reporting services (2000)
How do I dynamically populate a matrix column (or table) using the
parameters entered by users?
Example: A user enters a date range to filter the dataset. Parameters are
Start Date and End Date.
Then I want to be able to display in the report all the days between start
date and end date in the columns so that the
Table headers contain all the days/dates between start date and end date.
Start: 1/1/2006
End: 1/7/2006
--Col1: 1/1--Col2: 1/2--Col3: 1/3--Col4:
1/4--Col5:1/5--Col6: 1/6--Col7: 1/7
Row1
Row2
Row3
..how is this implemented in reporting services? is this possible?hey man,
right click on the 1st column header and select [expression] then you will
have to type something like:
=Parameters!startdate.Value
for the other columns you have to add 1 or 2 or 3 to the [days] part of the
parameter... then for the last column right click and select [expression]
then type:
=Parameters!enddate.Value
peace out...
"Abi" wrote:
> Hello I'm new to reporting services (2000)
> How do I dynamically populate a matrix column (or table) using the
> parameters entered by users?
> Example: A user enters a date range to filter the dataset. Parameters are
> Start Date and End Date.
> Then I want to be able to display in the report all the days between start
> date and end date in the columns so that the
> Table headers contain all the days/dates between start date and end date.
> Start: 1/1/2006
> End: 1/7/2006
>
> --Col1: 1/1--Col2: 1/2--Col3: 1/3--Col4:
> 1/4--Col5:1/5--Col6: 1/6--Col7: 1/7
> Row1
> Row2
> Row3
> ..how is this implemented in reporting services? is this possible?
>
>