Dynamically Populated Columns

Hi everyone,
I have to create report that has dynamically populated columns. The data
example is below:
Zone Mar-06 Apr-06 May-06
---
Med 1841.096666 1955.371600 2359.752608
Sub 0.000000 0.000000 0.000000
Work 1353.824214 945.390865 1542.416949
West 1022.000000 0.000000 0.000000
Nat'l 0.000000 0.000000 0.000000
And month columns are added dynamically. Like so:
Zone Mar-06 Apr-06 May-06
Jun-06 Jul-06 Aug-06
------
Med 1841.096666 1955.371600 2359.752608 1098.842727
1827.094062 1381.066666
Sub 0.000000 0.000000 0.000000
0.000000 0.000000 0.000000
Work 1353.824214 945.390865 1542.416949 1176.967816
1192.468396 621.960000
West 1022.000000 0.000000 0.000000
0.000000 1353.905000 0.000000
Nat'l 0.000000 0.000000 0.000000
0.000000 0.000000 0.000000
How can I design a report so that it grows with however many columns are
returned from the SP.
Thanks everybody for your input.Check out matrix control.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"CI" <ci@.ci.com> wrote in message
news:u1BzUcc1GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Hi everyone,
> I have to create report that has dynamically populated columns. The data
> example is below:
> Zone Mar-06 Apr-06 May-06
> ---
> Med 1841.096666 1955.371600 2359.752608
> Sub 0.000000 0.000000 0.000000
> Work 1353.824214 945.390865 1542.416949
> West 1022.000000 0.000000 0.000000
> Nat'l 0.000000 0.000000 0.000000
> And month columns are added dynamically. Like so:
> Zone Mar-06 Apr-06 May-06
> Jun-06 Jul-06 Aug-06
> ------
> Med 1841.096666 1955.371600 2359.752608 1098.842727
> 1827.094062 1381.066666
> Sub 0.000000 0.000000 0.000000
> 0.000000 0.000000 0.000000
> Work 1353.824214 945.390865 1542.416949 1176.967816
> 1192.468396 621.960000
> West 1022.000000 0.000000 0.000000 0.000000
> 1353.905000 0.000000
> Nat'l 0.000000 0.000000 0.000000 0.000000
> 0.000000 0.000000
> How can I design a report so that it grows with however many columns are
> returned from the SP.
> Thanks everybody for your input.
>|||I did,
However I am not sure how to map the top columns to it. In the dataset that
I get back I do not have the reference to the Mar-06 Apr-06
May-06 columns.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23ySQzoc1GHA.1304@.TK2MSFTNGP05.phx.gbl...
> Check out matrix control.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "CI" <ci@.ci.com> wrote in message
> news:u1BzUcc1GHA.1252@.TK2MSFTNGP04.phx.gbl...
>> Hi everyone,
>> I have to create report that has dynamically populated columns. The data
>> example is below:
>> Zone Mar-06 Apr-06 May-06
>> ---
>> Med 1841.096666 1955.371600 2359.752608
>> Sub 0.000000 0.000000 0.000000
>> Work 1353.824214 945.390865 1542.416949
>> West 1022.000000 0.000000 0.000000
>> Nat'l 0.000000 0.000000 0.000000
>> And month columns are added dynamically. Like so:
>> Zone Mar-06 Apr-06 May-06
>> Jun-06 Jul-06 Aug-06
>> ------
>> Med 1841.096666 1955.371600 2359.752608 1098.842727
>> 1827.094062 1381.066666
>> Sub 0.000000 0.000000 0.000000
>> 0.000000 0.000000 0.000000
>> Work 1353.824214 945.390865 1542.416949
>> 1176.967816 1192.468396 621.960000
>> West 1022.000000 0.000000 0.000000 0.000000
>> 1353.905000 0.000000
>> Nat'l 0.000000 0.000000 0.000000
>> 0.000000 0.000000 0.000000
>> How can I design a report so that it grows with however many columns are
>> returned from the SP.
>> Thanks everybody for your input.
>>
>|||i am new to this RS2005. i have same fucntionality with interactive
sorting... any steps to implement this functionality...,, please send
me link or code
Thanks
vinod
CI wrote:
> I did,
> However I am not sure how to map the top columns to it. In the dataset that
> I get back I do not have the reference to the Mar-06 Apr-06
> May-06 columns.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23ySQzoc1GHA.1304@.TK2MSFTNGP05.phx.gbl...
> > Check out matrix control.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "CI" <ci@.ci.com> wrote in message
> > news:u1BzUcc1GHA.1252@.TK2MSFTNGP04.phx.gbl...
> >> Hi everyone,
> >> I have to create report that has dynamically populated columns. The data
> >> example is below:
> >>
> >> Zone Mar-06 Apr-06 May-06
> >> ---
> >> Med 1841.096666 1955.371600 2359.752608
> >> Sub 0.000000 0.000000 0.000000
> >> Work 1353.824214 945.390865 1542.416949
> >> West 1022.000000 0.000000 0.000000
> >> Nat'l 0.000000 0.000000 0.000000
> >>
> >> And month columns are added dynamically. Like so:
> >>
> >> Zone Mar-06 Apr-06 May-06
> >> Jun-06 Jul-06 Aug-06
> >> ------
> >> Med 1841.096666 1955.371600 2359.752608 1098.842727
> >> 1827.094062 1381.066666
> >> Sub 0.000000 0.000000 0.000000
> >> 0.000000 0.000000 0.000000
> >> Work 1353.824214 945.390865 1542.416949
> >> 1176.967816 1192.468396 621.960000
> >> West 1022.000000 0.000000 0.000000 0.000000
> >> 1353.905000 0.000000
> >> Nat'l 0.000000 0.000000 0.000000
> >> 0.000000 0.000000 0.000000
> >>
> >> How can I design a report so that it grows with however many columns are
> >> returned from the SP.
> >>
> >> Thanks everybody for your input.
> >>
> >>
> >
> >|||Oh, so you are getting back a varying number of columns? I thought you
wanted to take your data and get variable columns. RS cannot deal with
multiple columns. However, you could probably write your SP to not create
the variable columns and let RS do it with the matrix control.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"CI" <ci@.ci.com> wrote in message
news:e%23fdm$c1GHA.2036@.TK2MSFTNGP05.phx.gbl...
>I did,
> However I am not sure how to map the top columns to it. In the dataset
> that I get back I do not have the reference to the Mar-06
> Apr-06 May-06 columns.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23ySQzoc1GHA.1304@.TK2MSFTNGP05.phx.gbl...
>> Check out matrix control.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "CI" <ci@.ci.com> wrote in message
>> news:u1BzUcc1GHA.1252@.TK2MSFTNGP04.phx.gbl...
>> Hi everyone,
>> I have to create report that has dynamically populated columns. The data
>> example is below:
>> Zone Mar-06 Apr-06 May-06
>> ---
>> Med 1841.096666 1955.371600 2359.752608
>> Sub 0.000000 0.000000 0.000000
>> Work 1353.824214 945.390865 1542.416949
>> West 1022.000000 0.000000 0.000000
>> Nat'l 0.000000 0.000000 0.000000
>> And month columns are added dynamically. Like so:
>> Zone Mar-06 Apr-06 May-06
>> Jun-06 Jul-06 Aug-06
>> ------
>> Med 1841.096666 1955.371600 2359.752608
>> 1098.842727 1827.094062 1381.066666
>> Sub 0.000000 0.000000 0.000000
>> 0.000000 0.000000 0.000000
>> Work 1353.824214 945.390865 1542.416949
>> 1176.967816 1192.468396 621.960000
>> West 1022.000000 0.000000 0.000000 0.000000
>> 1353.905000 0.000000
>> Nat'l 0.000000 0.000000 0.000000
>> 0.000000 0.000000 0.000000
>> How can I design a report so that it grows with however many columns are
>> returned from the SP.
>> Thanks everybody for your input.
>>
>>
>|||Everybody,
Thanks for your help. What i ended up doing is I unpivot the result set and
now i can use the Matrix to do it all for me
"CI" <ci@.ci.com> wrote in message
news:u1BzUcc1GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Hi everyone,
> I have to create report that has dynamically populated columns. The data
> example is below:
> Zone Mar-06 Apr-06 May-06
> ---
> Med 1841.096666 1955.371600 2359.752608
> Sub 0.000000 0.000000 0.000000
> Work 1353.824214 945.390865 1542.416949
> West 1022.000000 0.000000 0.000000
> Nat'l 0.000000 0.000000 0.000000
> And month columns are added dynamically. Like so:
> Zone Mar-06 Apr-06 May-06
> Jun-06 Jul-06 Aug-06
> ------
> Med 1841.096666 1955.371600 2359.752608 1098.842727
> 1827.094062 1381.066666
> Sub 0.000000 0.000000 0.000000
> 0.000000 0.000000 0.000000
> Work 1353.824214 945.390865 1542.416949 1176.967816
> 1192.468396 621.960000
> West 1022.000000 0.000000 0.000000 0.000000
> 1353.905000 0.000000
> Nat'l 0.000000 0.000000 0.000000 0.000000
> 0.000000 0.000000
> How can I design a report so that it grows with however many columns are
> returned from the SP.
> Thanks everybody for your input.
>