collation problem

hi

i have a db with hebrew collation.
i now want it to be cyrillic collation.
converting the db collation - wont help.
i tried exporting data to a blank DB created with cyrillic collation -
still, no good.

what is the best way of having a DB with a certain collation so no
matter the destination DB is, the collation of all columns will be
"database default"

thanks
amosCollations are defined a the column level. Create the tables with the
correct collation and then populate them. You can alter the existing
collation with an ALTER TABLE ... ALTER COLUMN statement but you first have
to drop any indexes on the columns and then re-create them afterwards.

--
David Portas
SQL Server MVP
--|||amos (amos@.cvidya.com) writes:
> i have a db with hebrew collation.
> i now want it to be cyrillic collation.
> converting the db collation - wont help.
> i tried exporting data to a blank DB created with cyrillic collation -
> still, no good.

I don't know exactly what you did, but presumably you used some export
wizard which performs too much things behind your back. Since I always
build my databases from scripts under version control, I have no idea
how these export wizard looks like.

If you don't have scripts under version control to build from your best
bet is probably to use the scripting facility in Enterprise Manager. I
don't think you can suppress generation of collation information there.
(You can in QA, but in QA you can only script one table at a time.)
However, once you have the script, you can open it an editor and to
a Replace All on "COLLATE Hebrew_CI_AI" to remove the collation information.

Then you can create the new database. If you need to copy data, you can
use INSERT/SELECT or bulk copy. In the latter case, be sure to export to
Unicode files.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

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

Clustered Indexes / Primary Key

Hi All,
I am converting an Access app. from .mdb to ODBC link to a SQL Server.
The first thing I have run into is Clustered Indexes not sorted. I have a
small lookup table with 2 fields. From what I was told here by our DBA,
every key has to have a primary key/clustered index. So, the lookup tables
first field is nothing but Category Numbers which are unique and created by
the user. The table has 121 records. The 2nd field is the Category Name.
The Cat. No. is the Primary Key, Clustered, Unique, No-Nulls. The Cat. Name
is indexed non-clustered. When you open the table, it is sorted by the Cat.
Name and not by the Primary Key! Why?
This is not the behavior I'm looking for. Just learning SQL Server.
Don
The only way you are guaranteed any type of sorting is by
using a query and using an order by clause. You don't want
to depend on a clustered index for sorting your data. You
use an order by.
-Sue
On Thu, 11 Aug 2005 07:59:02 -0700, "Donald King"
<DonaldKing@.discussions.microsoft.com> wrote:

>Hi All,
> I am converting an Access app. from .mdb to ODBC link to a SQL Server.
>The first thing I have run into is Clustered Indexes not sorted. I have a
>small lookup table with 2 fields. From what I was told here by our DBA,
>every key has to have a primary key/clustered index. So, the lookup tables
>first field is nothing but Category Numbers which are unique and created by
>the user. The table has 121 records. The 2nd field is the Category Name.
>The Cat. No. is the Primary Key, Clustered, Unique, No-Nulls. The Cat. Name
>is indexed non-clustered. When you open the table, it is sorted by the Cat.
>Name and not by the Primary Key! Why?
>This is not the behavior I'm looking for. Just learning SQL Server.
>Don
|||Sue,
Thanks, I figured out that a Primary key DOES NOT have to be clustered
which I was misinformed by the DBA here. The ORDER BY clause in a query will
execute faster I believe if the field that your ORDER BY clause refers to is
Indexed.
Tks again,
Don
"Sue Hoegemeier" wrote:

> The only way you are guaranteed any type of sorting is by
> using a query and using an order by clause. You don't want
> to depend on a clustered index for sorting your data. You
> use an order by.
> -Sue
> On Thu, 11 Aug 2005 07:59:02 -0700, "Donald King"
> <DonaldKing@.discussions.microsoft.com> wrote:
>
>
|||I think the clustering PK issues hits people because if you
don't have a clustered index on a table and create a PK the
default is for it to be clustered. But it does not mean it
has to be that way - you can specify non-clustered for the
PK. And yes, if you are accessing the data sequentially that
column may be a good candidate for the clustered index. It's
always good to look at the whole picture with the table
though. You get one clustered index so its important to
choose wisely.
-Sue
On Tue, 16 Aug 2005 10:01:02 -0700, "Donald King"
<DonaldKing@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue,
> Thanks, I figured out that a Primary key DOES NOT have to be clustered
>which I was misinformed by the DBA here. The ORDER BY clause in a query will
>execute faster I believe if the field that your ORDER BY clause refers to is
>Indexed.
>Tks again,
>Don
>--
>"Sue Hoegemeier" wrote:

Clustered Indexes / Primary Key

Hi All,
I am converting an Access app. from .mdb to ODBC link to a SQL Server.
The first thing I have run into is Clustered Indexes not sorted. I have a
small lookup table with 2 fields. From what I was told here by our DBA,
every key has to have a primary key/clustered index. So, the lookup tables
first field is nothing but Category Numbers which are unique and created by
the user. The table has 121 records. The 2nd field is the Category Name.
The Cat. No. is the Primary Key, Clustered, Unique, No-Nulls. The Cat. Name
is indexed non-clustered. When you open the table, it is sorted by the Cat.
Name and not by the Primary Key! Why'
This is not the behavior I'm looking for. Just learning SQL Server.
DonThe only way you are guaranteed any type of sorting is by
using a query and using an order by clause. You don't want
to depend on a clustered index for sorting your data. You
use an order by.
-Sue
On Thu, 11 Aug 2005 07:59:02 -0700, "Donald King"
<DonaldKing@.discussions.microsoft.com> wrote:

>Hi All,
> I am converting an Access app. from .mdb to ODBC link to a SQL Server.
>The first thing I have run into is Clustered Indexes not sorted. I have a
>small lookup table with 2 fields. From what I was told here by our DBA,
>every key has to have a primary key/clustered index. So, the lookup tables
>first field is nothing but Category Numbers which are unique and created by
>the user. The table has 121 records. The 2nd field is the Category Name.
>The Cat. No. is the Primary Key, Clustered, Unique, No-Nulls. The Cat. Nam
e
>is indexed non-clustered. When you open the table, it is sorted by the Cat
.
>Name and not by the Primary Key! Why'
>This is not the behavior I'm looking for. Just learning SQL Server.
>Don|||Sue,
Thanks, I figured out that a Primary key DOES NOT have to be clustered
which I was misinformed by the DBA here. The ORDER BY clause in a query wil
l
execute faster I believe if the field that your ORDER BY clause refers to is
Indexed.
Tks again,
Don
--
"Sue Hoegemeier" wrote:

> The only way you are guaranteed any type of sorting is by
> using a query and using an order by clause. You don't want
> to depend on a clustered index for sorting your data. You
> use an order by.
> -Sue
> On Thu, 11 Aug 2005 07:59:02 -0700, "Donald King"
> <DonaldKing@.discussions.microsoft.com> wrote:
>
>|||I think the clustering PK issues hits people because if you
don't have a clustered index on a table and create a PK the
default is for it to be clustered. But it does not mean it
has to be that way - you can specify non-clustered for the
PK. And yes, if you are accessing the data sequentially that
column may be a good candidate for the clustered index. It's
always good to look at the whole picture with the table
though. You get one clustered index so its important to
choose wisely.
-Sue
On Tue, 16 Aug 2005 10:01:02 -0700, "Donald King"
<DonaldKing@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Sue,
> Thanks, I figured out that a Primary key DOES NOT have to be clustered
>which I was misinformed by the DBA here. The ORDER BY clause in a query wi
ll
>execute faster I believe if the field that your ORDER BY clause refers to i
s
>Indexed.
>Tks again,
>Don
>--
>"Sue Hoegemeier" wrote:
>