all groups > sql server reporting services > october 2007 >
You're in the

sql server reporting services

group:

=User!Language


=User!Language jewelfire
10/5/2007 2:43:41 AM
sql server reporting services:
hey there

I am using Reporting Services 2005. I have recently been away and the
Microsoft Updates were done and now find that =User!Language no longer
works on my reports eg they are back to US dates?

Does anyone know of which Update? or what I need to do to correct.

thanks
Dianne
Re: =User!Language EMartinez
10/5/2007 3:44:22 AM
[quoted text, click to view]


You might look into using:
EXEC sp_configure 'default language', ##;
GO

RECONFIGURE WITH OVERRIDE;
GO

Also, you will want to look up the update history for the server that
was updated. Usually the update history is at update.microsoft.com.
There might be a KB article available related to the issue. Hope this
helps.

Regards,

Enrique Martinez
Sr. Software Consultant
Re: =User!Language Rajat
10/6/2007 12:31:39 AM

[quoted text, click to view]

Hi,

It seems that one can use only a single currency while showing the report.
What if I want to show number formatting in multiple currencies. I want to
show different currencies in the same column for different rows.

e.g. - I want to show the following format in my report. Please help...

1. Japan Y 500
2. US $ 500
3. Europe ? 500

Regards,
Rajat.

Re: =User!Language Rajat
10/6/2007 12:51:07 AM

[quoted text, click to view]

Hi,

I just found a blog post for solving the exact issue. Please refer the
following link...

http://blogs.msdn.com/bimusings/archive/2007/05/17/formatting-currency-on-a-row-by-row-basis-in-reporting-services.aspx

Regards,
Rajat.


Re: =User!Language jewelfire
10/7/2007 12:32:55 PM
[quoted text, click to view]

hey Enrique

thanks but after 2-3 reboots this solved itself (strange but there you
go)
cheers
Dianne
Re: =User!Language EMartinez
10/9/2007 12:20:33 AM
[quoted text, click to view]


Glad you could get it working. Let me know if I can be of further
assistance.

Regards,

Enrique Martinez
Sr. Software Consultant
AddThis Social Bookmark Button