Code Problem in Reporting Services 2005

We have just installed SQL Server 2005 Reporting Services and have
encountered an error converting the first report from SQL Server 2000
Reporting Services 2000 to the new version. The error is in using an
embedded code function being used in an expression.
The expression is:
=Code.GetEmployeeId(Fields!EmployeeId.Value).
The code function is:
Public Function GetEmployeeId(ByVal id as Object) As String
Dim text as String
text = iif (IsNothing(id), 0, id)
Return text
End Function
When the expression is edited, the function name. "GetEmployeeId", is
underlined in red and the popup error text says "Unrecognized Identifier."
What do I need to do to be able to get RS 2005 to recognize my function?
Thanks,
Tomits a VB.net code.
try this:
if id is nothing then
return 0
else
return id
end if
"Tom Bean" <tbean@.newsgroup.nospam> wrote in message
news:%23ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl...
> We have just installed SQL Server 2005 Reporting Services and have
> encountered an error converting the first report from SQL Server 2000
> Reporting Services 2000 to the new version. The error is in using an
> embedded code function being used in an expression.
> The expression is:
> =Code.GetEmployeeId(Fields!EmployeeId.Value).
> The code function is:
> Public Function GetEmployeeId(ByVal id as Object) As String
> Dim text as String
> text = iif (IsNothing(id), 0, id)
> Return text
> End Function
> When the expression is edited, the function name. "GetEmployeeId", is
> underlined in red and the popup error text says "Unrecognized Identifier."
> What do I need to do to be able to get RS 2005 to recognize my function?
> Thanks,
> Tom
>|||Hello Tom,
If you use the following expression in a textbox directly, what is the
result?
=Code.GetEmployeeId(nothing)
=Code.GetEmployeeId(1)
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Tom Bean" <tbean@.newsgroup.nospam>
>Subject: Code Problem in Reporting Services 2005
>Date: Tue, 17 Jan 2006 18:37:33 -0600
>Lines: 26
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67023
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>We have just installed SQL Server 2005 Reporting Services and have
>encountered an error converting the first report from SQL Server 2000
>Reporting Services 2000 to the new version. The error is in using an
>embedded code function being used in an expression.
>The expression is:
> =Code.GetEmployeeId(Fields!EmployeeId.Value).
>The code function is:
>Public Function GetEmployeeId(ByVal id as Object) As String
> Dim text as String
> text = iif (IsNothing(id), 0, id)
> Return text
>End Function
>When the expression is edited, the function name. "GetEmployeeId", is
>underlined in red and the popup error text says "Unrecognized Identifier."
>What do I need to do to be able to get RS 2005 to recognize my function?
>Thanks,
>Tom
>
>|||Peter,
When I edit the expression, with either 'nothing' or '1' as the parameter,
GetEmployeeId is still underlined in red and the "Unrecognized Identifier"
error still pops up. However, when the report is rendered, the values '0'
and '1' are displayed in the textboxes.
My concern is that some undocumented change has occurred in the way a code
block needs to be formatted in order for the function to be recognized. The
code I showed in my original post is all that is contained in the window on
the Code tab of the reports properties. Does something need to be changed
in the Code window to get the function to be recognized?
Thanks,
Tom
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:93RJy0%23GGHA.3696@.TK2MSFTNGXA02.phx.gbl...
> Hello Tom,
> If you use the following expression in a textbox directly, what is the
> result?
> =Code.GetEmployeeId(nothing)
> =Code.GetEmployeeId(1)
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --
>>From: "Tom Bean" <tbean@.newsgroup.nospam>
>>Subject: Code Problem in Reporting Services 2005
>>Date: Tue, 17 Jan 2006 18:37:33 -0600
>>Lines: 26
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>Message-ID: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67023
>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>>We have just installed SQL Server 2005 Reporting Services and have
>>encountered an error converting the first report from SQL Server 2000
>>Reporting Services 2000 to the new version. The error is in using an
>>embedded code function being used in an expression.
>>The expression is:
>> =Code.GetEmployeeId(Fields!EmployeeId.Value).
>>The code function is:
>>Public Function GetEmployeeId(ByVal id as Object) As String
>> Dim text as String
>> text = iif (IsNothing(id), 0, id)
>> Return text
>>End Function
>>When the expression is edited, the function name. "GetEmployeeId", is
>>underlined in red and the popup error text says "Unrecognized Identifier."
>>What do I need to do to be able to get RS 2005 to recognize my function?
>>Thanks,
>>Tom
>>
>|||Peter,
After investigating the problem with my report further, I found that the
problem isn't with the code even though an error is raised in the expression
editor. The problem seems to be due to the location of the subreport.
The subreport with the problem is in a cell of a 3 row table that contains
two groups. The first group, the ServiceGroup, is in the first row and the
second group, the EmployeeGroup, is in the second row. If the subreport is
put in a cell in the first row (first group), it works. If the subreport is
put in a cell in the second row (second group), it fails with an "internal
error" message.
Is there some issue with multiple groups in one table that would cause the
subreport to fail?
Thanks,
Tom
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:93RJy0%23GGHA.3696@.TK2MSFTNGXA02.phx.gbl...
> Hello Tom,
> If you use the following expression in a textbox directly, what is the
> result?
> =Code.GetEmployeeId(nothing)
> =Code.GetEmployeeId(1)
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --
>>From: "Tom Bean" <tbean@.newsgroup.nospam>
>>Subject: Code Problem in Reporting Services 2005
>>Date: Tue, 17 Jan 2006 18:37:33 -0600
>>Lines: 26
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>Message-ID: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67023
>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>>We have just installed SQL Server 2005 Reporting Services and have
>>encountered an error converting the first report from SQL Server 2000
>>Reporting Services 2000 to the new version. The error is in using an
>>embedded code function being used in an expression.
>>The expression is:
>> =Code.GetEmployeeId(Fields!EmployeeId.Value).
>>The code function is:
>>Public Function GetEmployeeId(ByVal id as Object) As String
>> Dim text as String
>> text = iif (IsNothing(id), 0, id)
>> Return text
>>End Function
>>When the expression is edited, the function name. "GetEmployeeId", is
>>underlined in red and the popup error text says "Unrecognized Identifier."
>>What do I need to do to be able to get RS 2005 to recognize my function?
>>Thanks,
>>Tom
>>
>|||Hello Tom,
Since the issue occurs consistently on this specific situation, it is more
like a problem in RS2005 though I did not find any known issue related. You
may want to contact CSS directly so they could look into this in timely
manner.
For a complete list of Microsoft Customer Support Services phone numbers,
please go to the following address on the World Wide Web:
<http://support.microsoft.com/directory/overview.asp>
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Tom Bean" <tbean@.newsgroup.nospam>
>References: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
<93RJy0#GGHA.3696@.TK2MSFTNGXA02.phx.gbl>
>Subject: Re: Code Problem in Reporting Services 2005
>Date: Wed, 18 Jan 2006 14:46:54 -0600
>Lines: 92
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <uTsaQBHHGHA.3700@.TK2MSFTNGP15.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67080
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Peter,
>After investigating the problem with my report further, I found that the
>problem isn't with the code even though an error is raised in the
expression
>editor. The problem seems to be due to the location of the subreport.
>The subreport with the problem is in a cell of a 3 row table that contains
>two groups. The first group, the ServiceGroup, is in the first row and
the
>second group, the EmployeeGroup, is in the second row. If the subreport
is
>put in a cell in the first row (first group), it works. If the subreport
is
>put in a cell in the second row (second group), it fails with an "internal
>error" message.
>Is there some issue with multiple groups in one table that would cause the
>subreport to fail?
>Thanks,
>Tom
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:93RJy0%23GGHA.3696@.TK2MSFTNGXA02.phx.gbl...
>> Hello Tom,
>> If you use the following expression in a textbox directly, what is the
>> result?
>> =Code.GetEmployeeId(nothing)
>> =Code.GetEmployeeId(1)
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> =====================================================>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> --
>>From: "Tom Bean" <tbean@.newsgroup.nospam>
>>Subject: Code Problem in Reporting Services 2005
>>Date: Tue, 17 Jan 2006 18:37:33 -0600
>>Lines: 26
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>Message-ID: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.sqlserver.reportingsvcs:67023
>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>>We have just installed SQL Server 2005 Reporting Services and have
>>encountered an error converting the first report from SQL Server 2000
>>Reporting Services 2000 to the new version. The error is in using an
>>embedded code function being used in an expression.
>>The expression is:
>> =Code.GetEmployeeId(Fields!EmployeeId.Value).
>>The code function is:
>>Public Function GetEmployeeId(ByVal id as Object) As String
>> Dim text as String
>> text = iif (IsNothing(id), 0, id)
>> Return text
>>End Function
>>When the expression is edited, the function name. "GetEmployeeId", is
>>underlined in red and the popup error text says "Unrecognized
Identifier."
>>What do I need to do to be able to get RS 2005 to recognize my function?
>>Thanks,
>>Tom
>>
>>
>
>|||Peter,
I have rewritten my query so the second subreport, in the second row/group,
is no longer necessary. This provides me with a usable workaround but I
think you should escalate this problem to the Reporting Services group to
they can restore the functionality that was available in RS2000.
Thanks,
Tom
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:fT%23Yc2NHGHA.1240@.TK2MSFTNGXA02.phx.gbl...
> Hello Tom,
> Since the issue occurs consistently on this specific situation, it is more
> like a problem in RS2005 though I did not find any known issue related.
> You
> may want to contact CSS directly so they could look into this in timely
> manner.
> For a complete list of Microsoft Customer Support Services phone numbers,
> please go to the following address on the World Wide Web:
> <http://support.microsoft.com/directory/overview.asp>
> If you are outside the US please see http://support.microsoft.com for
> regional support phone numbers.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --
>>From: "Tom Bean" <tbean@.newsgroup.nospam>
>>References: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
> <93RJy0#GGHA.3696@.TK2MSFTNGXA02.phx.gbl>
>>Subject: Re: Code Problem in Reporting Services 2005
>>Date: Wed, 18 Jan 2006 14:46:54 -0600
>>Lines: 92
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>Message-ID: <uTsaQBHHGHA.3700@.TK2MSFTNGP15.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67080
>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>>Peter,
>>After investigating the problem with my report further, I found that the
>>problem isn't with the code even though an error is raised in the
> expression
>>editor. The problem seems to be due to the location of the subreport.
>>The subreport with the problem is in a cell of a 3 row table that contains
>>two groups. The first group, the ServiceGroup, is in the first row and
> the
>>second group, the EmployeeGroup, is in the second row. If the subreport
> is
>>put in a cell in the first row (first group), it works. If the subreport
> is
>>put in a cell in the second row (second group), it fails with an "internal
>>error" message.
>>Is there some issue with multiple groups in one table that would cause the
>>subreport to fail?
>>Thanks,
>>Tom
>>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>>news:93RJy0%23GGHA.3696@.TK2MSFTNGXA02.phx.gbl...
>> Hello Tom,
>> If you use the following expression in a textbox directly, what is the
>> result?
>> =Code.GetEmployeeId(nothing)
>> =Code.GetEmployeeId(1)
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> =====================================================>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> --
>>From: "Tom Bean" <tbean@.newsgroup.nospam>
>>Subject: Code Problem in Reporting Services 2005
>>Date: Tue, 17 Jan 2006 18:37:33 -0600
>>Lines: 26
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>Message-ID: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:67023
>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>>We have just installed SQL Server 2005 Reporting Services and have
>>encountered an error converting the first report from SQL Server 2000
>>Reporting Services 2000 to the new version. The error is in using an
>>embedded code function being used in an expression.
>>The expression is:
>> =Code.GetEmployeeId(Fields!EmployeeId.Value).
>>The code function is:
>>Public Function GetEmployeeId(ByVal id as Object) As String
>> Dim text as String
>> text = iif (IsNothing(id), 0, id)
>> Return text
>>End Function
>>When the expression is edited, the function name. "GetEmployeeId", is
>>underlined in red and the popup error text says "Unrecognized
> Identifier."
>>What do I need to do to be able to get RS 2005 to recognize my function?
>>Thanks,
>>Tom
>>
>>
>>
>|||Hello Tom,
Thank you for your feedback. Please rest assured that this issue has been
report to the proper channel. If there is any update about this, we will
let you know.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "Tom Bean" <tbean@.newsgroup.nospam>
>References: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
<93RJy0#GGHA.3696@.TK2MSFTNGXA02.phx.gbl>
<uTsaQBHHGHA.3700@.TK2MSFTNGP15.phx.gbl>
<fT#Yc2NHGHA.1240@.TK2MSFTNGXA02.phx.gbl>
>Subject: Re: Code Problem in Reporting Services 2005
>Date: Thu, 19 Jan 2006 08:46:54 -0600
>Lines: 165
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <O676qcQHGHA.984@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67121
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Peter,
>I have rewritten my query so the second subreport, in the second
row/group,
>is no longer necessary. This provides me with a usable workaround but I
>think you should escalate this problem to the Reporting Services group to
>they can restore the functionality that was available in RS2000.
>Thanks,
>Tom
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:fT%23Yc2NHGHA.1240@.TK2MSFTNGXA02.phx.gbl...
>> Hello Tom,
>> Since the issue occurs consistently on this specific situation, it is
more
>> like a problem in RS2005 though I did not find any known issue related.
>> You
>> may want to contact CSS directly so they could look into this in timely
>> manner.
>> For a complete list of Microsoft Customer Support Services phone numbers,
>> please go to the following address on the World Wide Web:
>> <http://support.microsoft.com/directory/overview.asp>
>> If you are outside the US please see http://support.microsoft.com for
>> regional support phone numbers.
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> =====================================================>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> --
>>From: "Tom Bean" <tbean@.newsgroup.nospam>
>>References: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
>> <93RJy0#GGHA.3696@.TK2MSFTNGXA02.phx.gbl>
>>Subject: Re: Code Problem in Reporting Services 2005
>>Date: Wed, 18 Jan 2006 14:46:54 -0600
>>Lines: 92
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>Message-ID: <uTsaQBHHGHA.3700@.TK2MSFTNGP15.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.sqlserver.reportingsvcs:67080
>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>>Peter,
>>After investigating the problem with my report further, I found that the
>>problem isn't with the code even though an error is raised in the
>> expression
>>editor. The problem seems to be due to the location of the subreport.
>>The subreport with the problem is in a cell of a 3 row table that
contains
>>two groups. The first group, the ServiceGroup, is in the first row and
>> the
>>second group, the EmployeeGroup, is in the second row. If the subreport
>> is
>>put in a cell in the first row (first group), it works. If the subreport
>> is
>>put in a cell in the second row (second group), it fails with an
"internal
>>error" message.
>>Is there some issue with multiple groups in one table that would cause
the
>>subreport to fail?
>>Thanks,
>>Tom
>>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>>news:93RJy0%23GGHA.3696@.TK2MSFTNGXA02.phx.gbl...
>> Hello Tom,
>> If you use the following expression in a textbox directly, what is the
>> result?
>> =Code.GetEmployeeId(nothing)
>> =Code.GetEmployeeId(1)
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader
so
>> that others may learn and benefit from your issue.
>> =====================================================>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> --
>>From: "Tom Bean" <tbean@.newsgroup.nospam>
>>Subject: Code Problem in Reporting Services 2005
>>Date: Tue, 17 Jan 2006 18:37:33 -0600
>>Lines: 26
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>>X-RFC2646: Format=Flowed; Original
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>>Message-ID: <#ZXpud8GGHA.1100@.TK2MSFTNGP10.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>>NNTP-Posting-Host: 71.4.140.141.ptr.us.xo.net 71.4.140.141
>>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
>>Xref: TK2MSFTNGXA02.phx.gbl
>> microsoft.public.sqlserver.reportingsvcs:67023
>>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>>We have just installed SQL Server 2005 Reporting Services and have
>>encountered an error converting the first report from SQL Server 2000
>>Reporting Services 2000 to the new version. The error is in using an
>>embedded code function being used in an expression.
>>The expression is:
>> =Code.GetEmployeeId(Fields!EmployeeId.Value).
>>The code function is:
>>Public Function GetEmployeeId(ByVal id as Object) As String
>> Dim text as String
>> text = iif (IsNothing(id), 0, id)
>> Return text
>>End Function
>>When the expression is edited, the function name. "GetEmployeeId", is
>>underlined in red and the popup error text says "Unrecognized
>> Identifier."
>>What do I need to do to be able to get RS 2005 to recognize my
function?
>>Thanks,
>>Tom
>>
>>
>>
>>
>
>