MATRIX REPORT, CHANGING COLUMNS

I'm trying to change that a matix column reflects, but if i place a
case statement in my SQL I get:
The multipart identifier could not be bound.Does your query work in Management Studio?
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"jobs" <jobs@.webdos.com> wrote in message
news:1193943491.118935.176660@.k79g2000hse.googlegroups.com...
> I'm trying to change that a matix column reflects, but if i place a
> case statement in my SQL I get:
> The multipart identifier could not be bound.
>

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...
> >
> >
> >
>

Matix: refering to TOT column

I Have a Matrix:

IN OUT TOT
num avg max % num avg max % num avg max %
r1
r2

I want calculate the "%" so: num(tot)/num(in/out)

I added the column tot wiht right-click.... etc
How I can refer to num of TOT?

Thanks

abc_abc

more details
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=673479&SiteID=1

Matix Grouping error need advice fast

SQLServer 2000 SP4 with RS SP2:
I have a matrix that displays URLs and Dates. The grouping is by URL
within Date. The URL is being formatted through custom code that strips
of everything after the first '/' ignoring 'http://' as below:
<Code>
Public Function FormatUrl(ByRef url As String) As String
Dim r As New
System.Text.RegularExpressions.Regex("[^http://].*/|[^http://].*\?",
System.Text.RegularExpressions.RegexOptions.IgnoreCase)
Dim m As System.Text.RegularExpressions.Match = r.Match(url)
return m.ToString()
End Function
</Code>
When I display the URL as in
<Textbox Name="Address">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontSize>9pt</FontSize>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>Address</rd:DefaultName>
<CanGrow>true</CanGrow>
<Value>=Code.FormatUrl(Fields!HttpReferrer.Value)</Value>
</Textbox>
It works as I hoped but when I try to group the matrix of off
'=Code.FormatUrl(Fields!HttpReferrer.Value)' as:
<Grouping Name="matrix1_DateRow">
<GroupExpressions>
<GroupExpression>=Code.FormatUrl(Fields!HttpReferrer.Value)</GroupExpression>
</GroupExpressions>
</Grouping>
the report compiles, but throughs an exception at runtime as below:
--
Processing Errors
--
An error has occurred during report processing.
Exception of type
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException
was thrown.
--
OK
--
Can someone explain why I am getting this exception? Can you group off
of this type of expression?
Thanks for any helpI'm not sure, I'd call MS Support. The help doesn't offer a whole lot...
http://msdn2.microsoft.com/zh-cn/library/ms153581.aspx
Steve MunLeeuw
"p91473" <p91473@.sbcglobal.net> wrote in message
news:1159896928.329150.68180@.h48g2000cwc.googlegroups.com...
> SQLServer 2000 SP4 with RS SP2:
> I have a matrix that displays URLs and Dates. The grouping is by URL
> within Date. The URL is being formatted through custom code that strips
> of everything after the first '/' ignoring 'http://' as below:
> <Code>
> Public Function FormatUrl(ByRef url As String) As String
> Dim r As New
> System.Text.RegularExpressions.Regex("[^http://].*/|[^http://].*\?",
> System.Text.RegularExpressions.RegexOptions.IgnoreCase)
> Dim m As System.Text.RegularExpressions.Match = r.Match(url)
> return m.ToString()
> End Function
> </Code>
> When I display the URL as in
> <Textbox Name="Address">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> <FontSize>9pt</FontSize>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>2</ZIndex>
> <rd:DefaultName>Address</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=Code.FormatUrl(Fields!HttpReferrer.Value)</Value>
> </Textbox>
> It works as I hoped but when I try to group the matrix of off
> '=Code.FormatUrl(Fields!HttpReferrer.Value)' as:
> <Grouping Name="matrix1_DateRow">
> <GroupExpressions>
> <GroupExpression>=Code.FormatUrl(Fields!HttpReferrer.Value)</GroupExpression>
> </GroupExpressions>
> </Grouping>
> the report compiles, but throughs an exception at runtime as below:
> --
> Processing Errors
> --
> An error has occurred during report processing.
> Exception of type
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException
> was thrown.
> --
> OK
> --
> Can someone explain why I am getting this exception? Can you group off
> of this type of expression?
> Thanks for any help
>|||Seems like what you are doing is correct, can you try a dummy select
statement with the strings?
SELECT 'http://foo.com'
UNION
SELECT 'http://foo.a.com'
UNION
SELECT 'http://foo.c.com'
UNION
SELECT 'http://foo.b.com'
Steve MunLeeuw
"p91473" <p91473@.sbcglobal.net> wrote in message
news:1159896928.329150.68180@.h48g2000cwc.googlegroups.com...
> SQLServer 2000 SP4 with RS SP2:
> I have a matrix that displays URLs and Dates. The grouping is by URL
> within Date. The URL is being formatted through custom code that strips
> of everything after the first '/' ignoring 'http://' as below:
> <Code>
> Public Function FormatUrl(ByRef url As String) As String
> Dim r As New
> System.Text.RegularExpressions.Regex("[^http://].*/|[^http://].*\?",
> System.Text.RegularExpressions.RegexOptions.IgnoreCase)
> Dim m As System.Text.RegularExpressions.Match = r.Match(url)
> return m.ToString()
> End Function
> </Code>
> When I display the URL as in
> <Textbox Name="Address">
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <BorderStyle>
> <Default>Solid</Default>
> </BorderStyle>
> <FontSize>9pt</FontSize>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingTop>2pt</PaddingTop>
> <PaddingRight>2pt</PaddingRight>
> </Style>
> <ZIndex>2</ZIndex>
> <rd:DefaultName>Address</rd:DefaultName>
> <CanGrow>true</CanGrow>
> <Value>=Code.FormatUrl(Fields!HttpReferrer.Value)</Value>
> </Textbox>
> It works as I hoped but when I try to group the matrix of off
> '=Code.FormatUrl(Fields!HttpReferrer.Value)' as:
> <Grouping Name="matrix1_DateRow">
> <GroupExpressions>
> <GroupExpression>=Code.FormatUrl(Fields!HttpReferrer.Value)</GroupExpression>
> </GroupExpressions>
> </Grouping>
> the report compiles, but throughs an exception at runtime as below:
> --
> Processing Errors
> --
> An error has occurred during report processing.
> Exception of type
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException
> was thrown.
> --
> OK
> --
> Can someone explain why I am getting this exception? Can you group off
> of this type of expression?
> Thanks for any help
>