Matix?

I'm looking for suggestions...
The report will have columns named "Prob. 25%", "Prob. 50%", "Prob. 75%", "Prob.
90%"
Each column will be forecasted sales that are branded with the appropriate
probability for a sales person.
Should make mods to my sproc to accept a probability and run the sproc once for
each column as a single column table?
Should I make a temp table in SQL and update each column appropriately and then
query to a standard table in the SSRS report?
Should I use a Matrix?
TIA
JeffP...Could your stored procedure be fed one item, then return 4 probabilities'
Or am i misunderstanding how the process works.
"JDP@.Work" <JPGMTNoSpam@.sbcglobal.net> wrote in message
news:u4g0SNAcEHA.2880@.TK2MSFTNGP12.phx.gbl...
> I'm looking for suggestions...
> The report will have columns named "Prob. 25%", "Prob. 50%", "Prob. 75%",
"Prob.
> 90%"
> Each column will be forecasted sales that are branded with the appropriate
> probability for a sales person.
> Should make mods to my sproc to accept a probability and run the sproc
once for
> each column as a single column table?
> Should I make a temp table in SQL and update each column appropriately and
then
> query to a standard table in the SSRS report?
> Should I use a Matrix?
> TIA
> JeffP...
>
>|||maybe....
Each forecasted sale has a proabliity stored as a numeric value, e.g. 75 = 75%
So, for each sales person, I want the sales in the next 90 days to fall w/in the
appropriate column as noted below.
The report's table rows have no real corrolation, only the columns do.
The original request was for what would appear as a whiteboard for the next 90
days.
I'm thinking that I could either exec the sProc for each column defined w/in the
report or populate a temp table's columns and select * from that into the
report.
TIA
JeffP....
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:O9mizmAcEHA.3864@.TK2MSFTNGP10.phx.gbl...
> Could your stored procedure be fed one item, then return 4 probabilities'
> Or am i misunderstanding how the process works.
>
> "JDP@.Work" <JPGMTNoSpam@.sbcglobal.net> wrote in message
> news:u4g0SNAcEHA.2880@.TK2MSFTNGP12.phx.gbl...
> > I'm looking for suggestions...
> >
> > The report will have columns named "Prob. 25%", "Prob. 50%", "Prob. 75%",
> "Prob.
> > 90%"
> >
> > Each column will be forecasted sales that are branded with the appropriate
> > probability for a sales person.
> >
> > Should make mods to my sproc to accept a probability and run the sproc
> once for
> > each column as a single column table?
> >
> > Should I make a temp table in SQL and update each column appropriately and
> then
> > query to a standard table in the SSRS report?
> >
> > Should I use a Matrix?
> >
> > TIA
> >
> > JeffP...
> >
> >
> >
>