How can i capitalize the first character in a report

How can i capitalise the first character in a report ... Regards

Karen

It is advisable to do it in the backend database.

--Imran

|||

The same question was asked long time back by somebody and I found this answer here in this forums.

I remember this was answered by Rajiv and Jarret. Thanks to them.

1.) Add this function in Code section.

Public Function ConvertToCamelCase(inputStr) as String
dim inputStrArr
dim tempWord
dim outputStr
dim i
inputStrArr = Split(inputStr, " ")

for i = 0 to UBound(inputStrArr)
tempWord = inputStrArr(i)
tempWord = UCase(Left(tempWord, 1)) & LCase(Right(tempWord, len(tempWord) - 1))
if outputStr = "" then
outputStr = tempWord
else
outputStr = outputStr & " " & tempWord
end if
Next

return outputStr
End Function

2.) Put this line of code in the expression you want.

=Code.ConvertToCamelCase(Fields!SomeText.Value)

Hope this helps...

Deepak

|||

Deepak....

Thanks for the answer.. when i run it i am getting an error saying

The Value expression for the textbox ‘textbox1’ contains an error: Argument 'Length' must be greater or equal to zero.

What should i do?

Regards

Karen

|||

Convert the value you to String.

ex:

=Code.ConvertToCamelCase("STRING VALUE")

Hope this helps.....

|||

Deepak,

i am displaying the information like this in the text box

all contribution, pre-tax contribution, etc....

so what do u think i should do....

|||

Karen,

Use this expression below in your textbox. Remember to give a space after the Comma or change the function code accordingly.

=Code.ConvertToCamelCase("all contribution, pre-tax contribution, tax contribution, red, yellow, pink panther")

Hope this helps..

Deepak

|||

Did this answer your question ?

|||Yes and No... But yeah i solved it... thanks a lot..|||

Can you please detail me what changes did you make to accomplish this task or what did you do. I am sorry if I am troubling you, I am just intrested to learn more.

--Deepak

|||

Actually i didnt do much change .... Tried using that logic directly in my stored procedure and it worked fine... But i ran into a user problem that they wanted Some Words to be a capitalised and some not to later on... so i ended up changing them in the database itself... Thanks a lot for your help

Regards

Karen

How can i capitalize the first character in a report

How can i capitalise the first character in a report ... Regards

Karen

It is advisable to do it in the backend database.

--Imran

|||

The same question was asked long time back by somebody and I found this answer here in this forums.

I remember this was answered by Rajiv and Jarret. Thanks to them.

1.) Add this function in Code section.

Public Function ConvertToCamelCase(inputStr) as String
dim inputStrArr
dim tempWord
dim outputStr
dim i
inputStrArr = Split(inputStr, " ")

for i = 0 to UBound(inputStrArr)
tempWord = inputStrArr(i)
tempWord = UCase(Left(tempWord, 1)) & LCase(Right(tempWord, len(tempWord) - 1))
if outputStr = "" then
outputStr = tempWord
else
outputStr = outputStr & " " & tempWord
end if
Next

return outputStr
End Function

2.) Put this line of code in the expression you want.

=Code.ConvertToCamelCase(Fields!SomeText.Value)

Hope this helps...

Deepak

|||

Deepak....

Thanks for the answer.. when i run it i am getting an error saying

The Value expression for the textbox ‘textbox1’ contains an error: Argument 'Length' must be greater or equal to zero.

What should i do?

Regards

Karen

|||

Convert the value you to String.

ex:

=Code.ConvertToCamelCase("STRING VALUE")

Hope this helps.....

|||

Deepak,

i am displaying the information like this in the text box

all contribution, pre-tax contribution, etc....

so what do u think i should do....

|||

Karen,

Use this expression below in your textbox. Remember to give a space after the Comma or change the function code accordingly.

=Code.ConvertToCamelCase("all contribution, pre-tax contribution, tax contribution, red, yellow, pink panther")

Hope this helps..

Deepak

|||

Did this answer your question ?

|||Yes and No... But yeah i solved it... thanks a lot..|||

Can you please detail me what changes did you make to accomplish this task or what did you do. I am sorry if I am troubling you, I am just intrested to learn more.

--Deepak

|||

Actually i didnt do much change .... Tried using that logic directly in my stored procedure and it worked fine... But i ran into a user problem that they wanted Some Words to be a capitalised and some not to later on... so i ended up changing them in the database itself... Thanks a lot for your help

Regards

Karen

hot key for "Expression" in VS2005

Is there a hotkey for "Expression" right-click menu item in report designer?
--
Regards,
Dmitryit sure would be nice if they gave us office-style shortcut keys;
instead of subjecting us to a piece of shit IDE for uber-geeks
VS crashes on me; it's slow..
time to correct your strategy, Microsoft.. moving Query Analyzer and
Enterprise Manager did _NOTHING_ to help database developers.
Making BIDS in VS instead of in Office?
IT DID NOTHING TO HELP US OUT.
-Susie
Dmitry Duginov wrote:
> Is there a hotkey for "Expression" right-click menu item in report designer?
> --
> Regards,
> Dmitry|||Hi Dmitry,
There is no HotKey for "Expression".
You could click the Context Menu Key and then click "E".
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Wei;
THERE SHOULD BE A SHORTCUT KEY FOR EVERYTHING
stop forcing people to use Visual Studio for everything; it's not as
user-friendly as Office is.
-Aaron
Wei Lu [MSFT] wrote:
> Hi Dmitry,
> There is no HotKey for "Expression".
> You could click the Context Menu Key and then click "E".
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)|||Hello Aaron,
You could set up your customize Hotkey in the Visual Studio. But it does
not contain the Expression action, so we could not set a Hotkey for this
operation.
To provide your feedback directly to the product groups:
http://connect.microsoft.com/VisualStudio
Sincerely,
Wei Lu
Microsoft Online Community 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.|||it's another symptom that MS should have used Office instead of VS for
BIDS.
VS is a usability NIGHTMARE.
maybe you kids should stop selling us on new products; and start using
your existing products
-Susie
Wei Lu [MSFT] wrote:
> Hello Aaron,
> You could set up your customize Hotkey in the Visual Studio. But it does
> not contain the Expression action, so we could not set a Hotkey for this
> operation.
> To provide your feedback directly to the product groups:
> http://connect.microsoft.com/VisualStudio
> Sincerely,
> Wei Lu
> Microsoft Online Community 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.|||Hello Susie,
If you have any concern, please send your feedback to the Product Team
directly.
http://connect.microsoft.com/VisualStudio
Microsoft will consider your request and improve our product. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community 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.|||how about SQL authtentication?
where can we send feedback about having a gaping hole in ALL of our
databases for the past decade?
Do you really think that Microsoft LISTENS to anyone outside the
company?
Can SQL Authentication be secured?
How does Oracle and IBM and mySql do it?
Why is it that Microsoft has ZERO ABILITY to secure SQL
authentication'
Wei Lu [MSFT] wrote:
> Hello Susie,
> If you have any concern, please send your feedback to the Product Team
> directly.
> http://connect.microsoft.com/VisualStudio
> Microsoft will consider your request and improve our product. Thank you!
> Sincerely,
> Wei Lu
> Microsoft Online Community 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.

Hot fix 821334

Hi,
Anyone knows where to download the above? The kb article doesn't have a link
to download it.
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit Us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkai
Contact MS Product Support if you need a fix that isn't in a Service Pack.
David Portas
SQL Server MVP
|||Or hang on a little while for SP4. :-)
David Portas
SQL Server MVP
|||http://www.microsoft.com/sql/downloads/2000/sp4.asp
David Portas
SQL Server MVP
|||Thanks
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit Us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkai
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:2_mdnZoBj_RPXObfRVn-vQ@.giganews.com...
> http://www.microsoft.com/sql/downloads/2000/sp4.asp
> --
> David Portas
> SQL Server MVP
> --
>

Hot fix 821334

Hi,
Anyone knows where to download the above? The kb article doesn't have a link
to download it.
--
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit Us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkaiHello Loke,
you could contact Microsoft Product Support Services directly to obtain the
fix. For a complete list of Microsoft Product Support Services phone
numbers and information about support costs, visit the following Microsoft
Web site:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS
NOTE: In special cases, charges that are ordinarily incurred for support
calls may be canceled if a Microsoft Support Professional determines that a
specific update will resolve your problem. The typical support costs will
apply to additional support questions and issues that do not qualify for
the specific update in question.
Thanks & 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: "Loke Kit Kai" <kitkai@.community.nospam>
| Subject: Hot fix 821334
| Date: Fri, 6 May 2005 11:16:07 +0800
| Lines: 14
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <eeYtzneUFHA.544@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 203.118.60.18
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42947
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi,
| Anyone knows where to download the above? The kb article doesn't have a
link
| to download it.
|
|
| --
| Best Regards,
| Kit Kai
| MVP (asp.net)
| SgDotNet Council Member
| Visit Us @. http://www.sgdotnet.org
| My Blog: http://community.sgdotnet.org/blogs/kitkai
|
|
||||Hi Peter,
I just called the PSS, but they say there is not such hotfix. Could you help
me check please?
--
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit Us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkai
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:KwS4EOgUFHA.3928@.TK2MSFTNGXA01.phx.gbl...
> Hello Loke,
> you could contact Microsoft Product Support Services directly to obtain
> the
> fix. For a complete list of Microsoft Product Support Services phone
> numbers and information about support costs, visit the following Microsoft
> Web site:
> http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS
> NOTE: In special cases, charges that are ordinarily incurred for support
> calls may be canceled if a Microsoft Support Professional determines that
> a
> specific update will resolve your problem. The typical support costs will
> apply to additional support questions and issues that do not qualify for
> the specific update in question.
> Thanks & 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: "Loke Kit Kai" <kitkai@.community.nospam>
> | Subject: Hot fix 821334
> | Date: Fri, 6 May 2005 11:16:07 +0800
> | Lines: 14
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <eeYtzneUFHA.544@.TK2MSFTNGP15.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 203.118.60.18
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:42947
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Hi,
> | Anyone knows where to download the above? The kb article doesn't have a
> link
> | to download it.
> |
> |
> | --
> | Best Regards,
> | Kit Kai
> | MVP (asp.net)
> | SgDotNet Council Member
> | Visit Us @. http://www.sgdotnet.org
> | My Blog: http://community.sgdotnet.org/blogs/kitkai
> |
> |
> |
>

Hot fix 821334

Hi,
Anyone knows where to download the above? The kb article doesn't have a link
to download it.
--
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit Us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkaiContact MS Product Support if you need a fix that isn't in a Service Pack.
--
David Portas
SQL Server MVP
--|||Or hang on a little while for SP4. :-)
--
David Portas
SQL Server MVP
--|||http://www.microsoft.com/sql/downloads/2000/sp4.asp
--
David Portas
SQL Server MVP
--|||Thanks :)
--
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit Us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkai
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:2_mdnZoBj_RPXObfRVn-vQ@.giganews.com...
> http://www.microsoft.com/sql/downloads/2000/sp4.asp
> --
> David Portas
> SQL Server MVP
> --
>

Hot fix 821334

Hi,
Anyone knows where to download the above? The kb article doesn't have a link
to download it.
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit Us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkaiContact MS Product Support if you need a fix that isn't in a Service Pack.
David Portas
SQL Server MVP
--|||Or hang on a little while for SP4. :-)
David Portas
SQL Server MVP
--|||http://www.microsoft.com/sql/downloads/2000/sp4.asp
David Portas
SQL Server MVP
--|||Thanks
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit Us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkai
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:2_mdnZoBj_RPXObfRVn-vQ@.giganews.com...
> http://www.microsoft.com/sql/downloads/2000/sp4.asp
> --
> David Portas
> SQL Server MVP
> --
>

HostName and ReinitializeSubscription

Hello all,

I'm having trouble with my Merge Replication setup in regards to changing the HostName property of the SqlCeReplication object. As we all know, if you modify the HostName value, you must then call the ReinitializeSubscription(true) method before calling Synchronize(). Unfortunately, this isn't working for me. Following this sequence of steps consistently results in error messages saying that I need to either call ReinitializeSubscription, or change my HostName back to it's original value. Has anyone ever experienced this problem?

Regards,

Rob Tiffany

Hey Rob,

You are correct, once you specify a HostName value for a subscriber, if you want to change that value later, you must call SqlCeReplication.ReinitializeSubscription(True) followed by .Synchronize() to effectively make the change.

I built an app recently for a large field service scenario where the mobile device can change hands from field worker to field worker. I decided to use the field worker's unique identifier as the value for HostName so that I could replicate only the appropriate data for a given worker to a given SQL Mobile database. If the device changes hands, here is the process of making the change to HostName and reinitializing:

Public Function Synchronize() As Boolean

Dim retVal As Boolean = False

Dim repl As SqlCeReplication = GetReplication()

If repl Is Nothing Then
Return False
End If

Try

If Globals.GetInstance().HostNameChanged Then
repl.ReinitializeSubscription(True)
Globals.GetInstance().HostNameChanged = False
End If

repl.Synchronize()

etc etc etc

If you are doing something similar and getting an error, could you post the details on the error itself and Laxmi and I can look into it? Also, some info on your configuration (assume you are talking about SQL Mobile and SS2005?)

Regards,

Darren

|||

Yeah, that's what I'm doing too. My Sync code blocks looks like the following:

private void replicate(bool reInit)

{

SqlCeReplication repl = new SqlCeReplication();

repl.InternetUrl = Settings1.Default.InternetURL;

repl.InternetLogin = Settings1.Default.InternetLogin;

repl.InternetPassword = Settings1.Default.InternetPassword;

repl.Publisher = Settings1.Default.Publisher;

repl.PublisherDatabase = Settings1.Default.PublisherDatabase;

repl.Publication = Settings1.Default.Publication;

repl.PublisherSecurityMode = SecurityType.NTAuthentication;

repl.SubscriberConnectionString = @."Data Source=" + localFolder + "MyDB.sdf;Password=p@.ssw0rd;";

repl.Subscriber = Settings1.Default.Subscriber;

repl.HostName = txtAgentId.Text;

repl.CompressionLevel = Settings1.Default.CompressionLevel;

repl.ExchangeType = ExchangeType.BiDirectional;

try

{

if (!File.Exists(localFolder + "MyDB.sdf"))

{

repl.AddSubscription(AddOption.CreateDatabase);

}

if (reInit == true)

{

repl.ReinitializeSubscription(true);

}

// Synchronize with SQL Server 2005

repl.Synchronize();

}

finally

{

repl.Dispose();

}

}

If the user changes the HostName, then I pass "true" to the method above to call ReinitializeSubscription(true).

Thanks,

Rob

|||

there is a possible code path in your code where the database does not exist and you (are going to create it using AddOption.CreateDatabase on the first replication), but reinit can also be true - this won't work - you cannot mix CreateDatabase and Reinit in the same call to Synchronize.

Could that be what's happening? What error messages are you getting?

Darren

|||

I don't have the exact error message in front of me now, but is says something like:

Error: Changing the HostName requires a call to ReinitializeSubscription() or change your HostName back to the original value. HostName = 2, Original HostName = 1.

Something like that. Keep in mind that it will even throw this same error when I call ReinitializeSubscription().

To answer your other question, I haven't experienced the possible code path error you described where the database doesn't exist. It should also be known that this is a desktop XP project and not on Windows Mobile. Just in case we have subtle differences or issues between the desktop and handheld dlls. I'm trying to do some load testing and the desktop is the only way to create enough clients.

Rob