How to change the language settings of an rdl

Hi,

Can we change the language settings for a report by modifying the rdl code?

For example:- If my report is in English US, how do I change it to English UK?

Thanks in advance

Hi

In Solution Explorer Right Click on the Report for which you want to change the language and select "View Code".

In the Code that opened search for "Language" there you can change the language

How to change report page settings

Is there a way to reset the page margins for all new
reports? I would like to reset them to allways be .5".
Also is there a way to create a new template?
ThanksPosted to the Wiki...
http://www.ReportingServicesFAQ.com/ow.asp?PageMargins
Help build the Wiki!
--
Reporting Services Articles, Forums, Blogs and Wiki Community
www.ReportingServicesFAQ.com
donald wrote:
> Is there a way to reset the page margins for all new
> reports? I would like to reset them to allways be .5".
> Also is there a way to create a new template?
> Thanks

How to change collation settings of a database

Hi,
what would be the best way to change the collation settings of a database? I
need to change the collation from SQL_Latin1_General_CP1_CI_AS to
Latin1_General_CI_AS.
Thank you a lot in advance!
Danielhttp://msdn.microsoft.com/library/d...br />
819v.asp
ML|||Hi,
have a look at the alter database TSQL in BOL. Thanks
--
--
Thanks,
Ibrahim
If you find this post useful, please click 'yes'
"Daniel Walzenbach" wrote:

> Hi,
> what would be the best way to change the collation settings of a database?
I
> need to change the collation from SQL_Latin1_General_CP1_CI_AS to
> Latin1_General_CI_AS.
> Thank you a lot in advance!
> Daniel|||Thank you ML!
Regards
Daniel
"ML" wrote:

> http://msdn.microsoft.com/library/d... />
a_819v.asp
>
> ML|||Just be make sure you perused the previously posted Books Online topic,
please note the following excerpt:
<Excerpt>
Altering the default collation of a database does not change the collations
of the columns in any existing user-defined tables. These can be changed
with ALTER TABLE. The COLLATE CLAUSE on an ALTER DATABASE statement changes:
</Excerpt>
Hope this helps.
Dan Guzman
SQL Server MVP
"Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
news:E4DEF1D9-83C8-4762-A99E-6B67F94C6261@.microsoft.com...
> Hi,
> what would be the best way to change the collation settings of a database?
> I
> need to change the collation from SQL_Latin1_General_CP1_CI_AS to
> Latin1_General_CI_AS.
> Thank you a lot in advance!
> Daniel|||Hi Dan,
the excerpt you posted is exactly the problem I have. Do you see any
solution to solve this?
Thank you!
Daniel
"Dan Guzman" wrote:

> Just be make sure you perused the previously posted Books Online topic,
> please note the following excerpt:
> <Excerpt>
> Altering the default collation of a database does not change the collation
s
> of the columns in any existing user-defined tables. These can be changed
> with ALTER TABLE. The COLLATE CLAUSE on an ALTER DATABASE statement change
s:
> </Excerpt>
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
> news:E4DEF1D9-83C8-4762-A99E-6B67F94C6261@.microsoft.com...
>
>|||Unfortunately, there is no easy way to change the collation of all existing
columns to the new collation. You'll need to recreate the tables. See
http://support.microsoft.com/defaul...b;en-us;325335.
Hope this helps.
Dan Guzman
SQL Server MVP
"Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
news:F704636E-CA46-42DD-AD1B-07D15243351F@.microsoft.com...
> Hi Dan,
> the excerpt you posted is exactly the problem I have. Do you see any
> solution to solve this?
> Thank you!
> Daniel
> "Dan Guzman" wrote:
>|||Dan,
I feared so ;-)
Thanks for you reply! Regards
Daniel
"Dan Guzman" wrote:

> Unfortunately, there is no easy way to change the collation of all existin
g
> columns to the new collation. You'll need to recreate the tables. See
> http://support.microsoft.com/defaul...b;en-us;325335.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Daniel Walzenbach" <daniel.walzenbach@.newsgroup.nospam> wrote in message
> news:F704636E-CA46-42DD-AD1B-07D15243351F@.microsoft.com...
>
>

How to change collation settings after install

I need to change the collation setting on a server which has already been
installed and setup. How do I do this?
Thanks.
moondaddy@.newsgroup.nospamIt depends on to what extent you want to change collation. The collation for system databases you
change using rebuildm.exe (2000) or setup (2005). See books online for details. This will rebuild
the system databases, so you need to recreate everything you need in the system databases.
A user database is a different thing...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"moondaddy" <moondaddy@.newsgroup.nospam> wrote in message
news:eTbPg7gAIHA.4232@.TK2MSFTNGP04.phx.gbl...
>I need to change the collation setting on a server which has already been installed and setup. How
>do I do this?
> Thanks.
>
> moondaddy@.newsgroup.nospam
>|||Take a look at this tip:
http://www.sqlcommunity.com/Default.aspx?grm2id=25&tabid=77
Hope this helps.
Saleem
WWW.SQLCOMMUNITY.COM
SQL Server Tips, SQL Server Scripts, SQL Server Forums, SQL Server Blogs,
SQL Server Radio, SQL Server Events..
"Tibor Karaszi" wrote:
> It depends on to what extent you want to change collation. The collation for system databases you
> change using rebuildm.exe (2000) or setup (2005). See books online for details. This will rebuild
> the system databases, so you need to recreate everything you need in the system databases.
> A user database is a different thing...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "moondaddy" <moondaddy@.newsgroup.nospam> wrote in message
> news:eTbPg7gAIHA.4232@.TK2MSFTNGP04.phx.gbl...
> >I need to change the collation setting on a server which has already been installed and setup. How
> >do I do this?
> >
> > Thanks.
> >
> >
> > moondaddy@.newsgroup.nospam
> >
>|||Hi,
I agree with Tibor. Just add some helpful links here for your reference.
For SQL 2000, please refer to:
How to rebuild the master database (Rebuild Master utility)
http://msdn2.microsoft.com/en-us/library/aa197950(sql.80).aspx
For SQL 2005, you may refer to:
Setting and Changing the Server Collation
http://msdn2.microsoft.com/en-us/library/ms179254.aspx
How to: Install SQL Server 2005 from the Command Prompt
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Additionally if you would like to change your user database collation, you
can use ALTER DATABASE statement which is applicable for both SQL 2000 and
2005:
Setting and Changing the Database Collation
http://msdn2.microsoft.com/en-us/library/ms175835.aspx
ALTER DATABASE (Transact-SQL)
http://msdn2.microsoft.com/en-us/library/ms174269.aspx
Please feel free to let us know if you have any questions or concerns.
Best regards,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================