Saturday, February 11, 2012

$10 for first good answer. how to add an extra column?

I have a tablur report like this
Product @.Year1 (Price)
1 1.00
2 2.00
3 2.00
I want to add another column @.Year2?
Product @.Year1 (Price) @.Year2(price)
1 1.00 1.34
2 2.00 2.30
3 2.00 2.98
What shall I do without breaking down the integrity of table?
Thanks!
Do I have to go for a Matrix?If you want new columns to dynamically appear based on the data you will
have to use a matrix. See the CompanySales.rdl sample report that shipped
with SQL Server 2000 Reporting Services for an example of how this can be
accomplished.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Frank RS" <FrankRS@.discussions.microsoft.com> wrote in message
news:3C565BA9-1C00-4EDF-B20F-5F6B06EA3BB6@.microsoft.com...
> I have a tablur report like this
> Product @.Year1 (Price)
> 1 1.00
> 2 2.00
> 3 2.00
> I want to add another column @.Year2?
> Product @.Year1 (Price) @.Year2(price)
> 1 1.00 1.34
> 2 2.00 2.30
> 3 2.00 2.98
> What shall I do without breaking down the integrity of table?
> Thanks!
>
> Do I have to go for a Matrix?
>

No comments:

Post a Comment