Get Culture For Multilanguage In Reporting Service

Sep 25, 2007


Hi..

I have a windows application that can change the language of the application depends on the language preference of the user. My application can switch between chinese(zh-CHS) and english(en-US). I also have a report that also can change the language (hopefully) if user change their language preference in the framework of my application.

I already follow the step provided in this link.
http://technet.microsoft.com/en-us/library/aa964130.aspx

While the code is at http://mhprofessional.com/product.php?isbn=0072262397&cat=112&promocode=

Since I want to apply it in windows application and C#, i already modified to make it suitable with my application. I can successfully deploy and view my report if user key in (for testing purpose) the language they want in the report interface.

My problem is, I actually want to retrieve the value automatically from the framework. I try to retrieve the current language from thread.


namespace Mynamespace.RSLanguage.MultiLanguage

{






public class MyReports

{



private static ResourceManager LocalizeRM;




static MyReports()

{


LocalizeRM = new ResourceManager("Mynamespace.RSLanguage.MultiLanguage.MyReports", System.Reflection.Assembly.GetExecutingAssembly());

}

[System.Security.Permissions.PermissionSetAttribute(System.Security.Permissions.SecurityAction.Assert, Name = "FullTrust")]


public static string LocalizedString(string stringIdentifier, string language)

{






string getLanguage = "";

try

{


if (language != "")

{


getLanguage = language;

}

else

{








getLanguage = Thread.CurrentThread.CurrentUICulture.ToString().Trim();

}




CultureInfo currentCulture = new CultureInfo(getLanguage);

return LocalizeRM.GetString(stringIdentifier, currentCulture);

}

catch (System.Exception ex)

{


return ex.Message;

}

}
::::
}
::::
}


But, the getLanguage value still get the "en-US" from the thread even though user change their language preference to chinese. So, it still deploy the report in english. But if user key in "zh-CHS" into the interface, the report will display the report like correctly.


How can I actually retrieve the current value for the language?

View 9 Replies


ADVERTISEMENT

How To Avoid Space Of Text Box In Reporting Service If It Is Null Reporting Service

May 16, 2008



i have a list report
some values of this are blank or null
i want to avoid that spacing if it is null
like
name:jjj
lastname kkk
firstname
address uuuu

i want it should be
name jjj
lastname kkk
address uuuu

View 3 Replies View Related

X-ref Documentation For DTS-package,views,tables,Reporting Service,Analyze Service

Mar 27, 2006

We are using the whole BI-package from Microsoft - from SQL, DTS-package,Raporting Service and Analyze Service.

It should be very helpful to be able to create a metadata databases where you could find all releations between different objects (tables,views,reports,cubes,DTS-package,Databases.

Just to get answer for: 'where is view xxx used', 'what are Report xxx depending upon'.

While everything exists in different SQL databases it should possible to do.

Has anyone any comments or the same needs ?

View 1 Replies View Related

How To Connect To Analysis Service Database Through Reporting Service?

Mar 31, 2006

Hello,

In our project, we would like to use the same data source for our analysis service database cubes and for our reporting service reports.

I created the analysis service project first, deployed successfully. When trying to setting up the data source in the report model project, I selected the "create a data source based on another object", and then selected the "create a data source based on an analysis service project". However, there is no analysis service project to select, and no browse button to see where the reporting service is looking for analysis service project either.

I have tried creating a new analysis service project with data source views, cubes, dimensions and all the stuff, but still cannot see the analysis service project in the drop down box to be selected for my reporting model project data source.

As I am fairly new to the reporting service, I'm sure I'm missing something, but couldn't find much information in the help or on the web. Any suggestion would be much appreciated.

Thank you very much,

Annie

View 5 Replies View Related

MultiLanguage Support

Dec 6, 2007



Hi friends,
I thinks this is not right place to post this question, but i don't know where can i post this one. I hope i will get reply. Actually our application is in two languages English & Spanish. We are having data in English in SQL Server 2005.
I need to Insert Spanish data in to tables. What is the way to Insert Spanish data? I need to create new table for inserting Spanish data? OR can i create new columns for spanish in existing table? OR I need to add data in the existing table without creating new table and new columns?
How they query, when they want Spanish data related to English?
Is it possible to get Spanish language words in SQL Server 2005 which is equal to English Words?
How can i write Scripts for retreiving Spanish data?

Could anyone help me to solve this problem. Thanks in Advance



Thanks
San

View 1 Replies View Related

Multilanguage Database Design

Feb 10, 2004

I need to build a multilanguage Web portal.
Any ideas on how i can design my sql database? (MS SQL server 2000)

View 1 Replies View Related

Multilanguage In Sql Server 2005

Jun 4, 2007

Hi,



I'm working with Sql Server Express and I have an application which supports multi language (Asp.net, .net 1.1). You can insert text in many languages (English, Portuguese, Romanian, Turkish, Hebrew, Arabic, Russian - basically all left-to-right and right-to-left languages.)

Which collation should I use?



Thanks,

Ruvik



View 3 Replies View Related

Reporting Services Menu Does Not Appear When Install Reporting Service Add-in For SharePoint

May 14, 2008

Hi all,

I have some problem about reporting service add-in.

After I install reporting service add-in for SharePoint, reporting service menu does not appear in Application Management Tab in SharePoint Central Administration.

I try to uninstall and re-install again, it remain not work.

How can I solve this problem?

Thank you very much.

View 4 Replies View Related

Multilanguage Database Design Recommendations

May 18, 2008

Dear friends
I'm developping a multilanguage human muscle database and wanted to know your opinion about my design
Table Muscle:-MuscleID(PK)-Name_DE...............german is standart-Description_DE
Table Muscle_LANG (for appr. languages):-MuscleID(PK)-Name_EN-Name_FR-Name_ES-Description_EN-Description_FR-Description_ES
Many thanks for your tips

View 7 Replies View Related

Microsoft SQL Server 2005 Multilanguage

Mar 25, 2008

Hello,

I need the Microsoft SQL Server 2005 Edition Express SP2 and the Management Studio Express SP2 in 4 languages (French, English, German, Spanish).

Where can I found a multilanguage (if exist) and the parameters to an unnaattended install off the Management Studio Express (I have for the Server 2005 Edition Express)?

In the same Idea, It's also exist for the Framework 2.0 (and the parameters)?

Thanks in advance

Best Regards

View 7 Replies View Related

Multilanguage Database Design Approach

May 28, 2008



Hi

Please take a look at this tables

As you can see muscle_category_table and muscle_table have names and descriptions columns in german (DE).

Now I want to have the option to add additional languages for those properties and ask you:

Would you recommend to move name and description into new approprate language table e.g. muscle_lang or Do you have another suggestion which makes maintenance and evolving easier?

Thank you for your suggestions


View 2 Replies View Related

SQL Server Reporting Service -Reporting Parameter

Sep 4, 2007

Hi,

Can we pass the Database name/Catalog name for the datasouce that will be used for report,
as a report parameter . Is yes can any one help me on how to achieve that .

Thanks in Advance

View 1 Replies View Related

Storing Locale And Culture-information

Dec 9, 2006

Hi, I'm creating a web application with membership and such. And I have some problem figuring out how to store locale and culture data. My application needs to know the following three things for every user: country (or region), prefered language and their timezone. Now, the country and language can easily be stored as a CultureInfo string (such as "en-US" or "sv-SE"). However, i'm probably going to need two columns in my database if say a person lives in the US (and therefore applies to US registration fees, etc) but want the site displayed in swedish (my app implements global resources). So i guess (if no one objects to the above) my question is how do I store the timezone-data? There is ofcourse a System.Timezone class, but I'm not sure how to implement it. I obviously want my site to display the correct local time (all datetimes are stored as universaltime though). Is there a "universal" timezone-standard? Any ideas would be greatly appreciated. /David N. 

View 1 Replies View Related

Localization/Language/Culture Parameter

Sep 17, 2007



Where can I obtain a list of the languages as used in the report language property for populating a parameter?

Currently if I put the list that is in the Language Dropdown (Ex. "French (France)") it does not work. I have to use "fr - Fr"

Thanks
BobP

View 1 Replies View Related

Crystal Reports Culture Info From Asp.Net

Nov 16, 2007

How to set the culture info of the Crystal Report document according to the
aspx page's culture info ?


View 1 Replies View Related

Passing SAML Token From Security Token Service To Reporting Service

Mar 28, 2007

Hi,

I am using SQL Server 2005 Reporting Services. I want to make it secure. I am also using WCF services and made them secure using Claim based System.Identity Model.

I want to apply same claim based model to Reporting Services.

How can I do that?



Amit

View 2 Replies View Related

Could Not Load File Or Assembly 'Microsoft.DataWarehouse, Version 9.0.242.0, Culture=neutral,publicKeyToken=89845dcd8080cc91'

Mar 2, 2007

Could not load file or assembly 'Microsoft.DataWarehouse, version 9.0.242.0, Culture=neutral,publicKeyToken=89845dcd8080cc91' - the system cannot find the file specified.

I get this message when I try to do a forcast from the Data Mining - Forecast menu.

Forecast from Table Tools, Analyse, Forecast works perfect.

Running Vista and using the DMAddins_SampleData workbook.

Any ideas ?

Trond

View 8 Replies View Related

System.Security.Permissions.SecurityPermission, Mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' Fai

Oct 29, 2007

Hi,
I am currently working on SQL server reporting. I have created custom assemblies. I am loading the custom assebly in the rdl file.
I am getting following exception


An error occurred while executing OnInit: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. (rsErrorInOnInit)



Please let me know if anyone knows the reason.
Thanks in Advance.

View 13 Replies View Related

Reporting Service

Sep 3, 2007

Hello sir

I am using SQL Reporting Service in SQL Server 2005
There I am creating a Report from Parameterised Stored Procedure

Its show the report after clicking on Button View
but it not sort a data according to parameter

Please help me out in this

Thanks
Ever Smiling
Ashish

You Have to Loss Many Times to Win Single Time

View 2 Replies View Related

Who Knows Reporting Service

Nov 23, 2005

let's work together

View 1 Replies View Related

SQL Reporting Service

Feb 8, 2008

How to deploy the newly created report on the Reprt Server

View 3 Replies View Related

Reporting Service

Feb 9, 2006

Hi all,

I am new to reporting services.
I have to call the reporting service(some else did this) from the web application that I have created using VB.NET . Not sure how to do it .. was reading few articles on the web .

Any good atricles out there ?

I have created web reference to http://server/ReportServer/ReportService.asmx in my web app. The report expects one parameter .

Below is the code I was starting to write to call the reporting service

Dim rs As New RSWebReference.ReportingService

rs.Credentials = System.Net.CredentialCache.DefaultCredentials

Dim result As Byte

Dim encoding As String

Dim mimetype As String

Dim parameters(2) As Parametervalue()

For some reason I cannot do ParameterValue() it says undefined. I am using Microsoft .NET Framework 1.1 . do I have to use ASP.net2.0 for using reporting services?

ANy way i can get this working

Thanks in advance.





View 2 Replies View Related

How To Install SQL Reporting Service

Apr 17, 2008

I have already Installed SQL Server management studio express edition in my computer. Now I want to install SQL reporting service.
Can anyone please guide me to how to do that.
Thanks
Kalloo 
 
 

View 1 Replies View Related

SQL Reporting Service And Registering Asp.net

May 14, 2004

Hi all
When I'm installing sql reporting service I get an error that says "ASP.NET is not installed or is not registered with your web server."

I have iis installed, all of .net, and just installed .NET Framework Redist version 1.1

Can anyone tell me what I need to do to register ASP.NET or what I've done wrong.

Thanks for your help
Jerry

View 3 Replies View Related

Reporting Service Issue

Apr 5, 2008

CAN ANYONE HELP ME OUT.

I have Generated a report using Tamil in reporting services in sql server 2005... i can able to generate and preview the report in local system,
But when i deployed in report manager server, the generated report
statement font's overlapping with others, even after alignment..

hope am clear...

pls gve the solution....

View 1 Replies View Related

Sql Reporting Service Problem

Jun 11, 2008

I want to make a table with dataset such as

employee

and in the header of the table i want to put

another table which has another dataset such as

empdata

Could you please help me

View 1 Replies View Related

Problems With Reporting Service

Jun 28, 2007

Hello all experts!
I have a problem I would be very happy if someone could help me out with;

I have a windows 2003 server with SQLExpress and Reporting Services.
I have developed a report in visual studio and successfully deployed that report to the server. I can browse http://localhost/reports to access the report and view them (Via terminal server). But when I browse the page from outside I recieve the following error;

"The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version."

If I run from VisualStudio 2005 and try to access the page I get this message;

"The request failed with HTTP status 401"

What is Wrong??

Thanks in advance for any good suggestion.

best regards
Nroblex from sweden

View 3 Replies View Related

TSQL LIKE In Reporting Service

Sep 17, 2007

Hi there

I've created Report Parameter called AssetCode. In quiry for database, I've created like this:

SELECT a.id1, a.deliverydate, a.retirementdate, b.organisationname, c.costcentre,a.id4,mm.hierarchydescription
FROM Asset as a (NOLOCK)
LEFT JOIN makemodel as mm (NOLOCK) ON a.makemodelid = mm.makemodelid
LEFT JOIN OrganisationTree as b (NOLOCK) ON a.physicalLocationOrgID = b.orgid
LEFT JOIN AssetChargeSplit as c (NOLOCK) ON a.assetid = c.assetid
WHERE a.status = '2'
AND a.id1 LIKE @AssetCode
AND (mm.assettype = 1 or mm.assettype = 6)
ORDER BY a.id1 ASC,
c.costcentre DESC

But when you run a report, if you put for instance "NA196" as keyword, it doesn't return the data for "NA1961", "NA19602", "NA1965", etc etc. But if you put in textfield such as "NA196%", it get the data. ?!?! So how do replace this behaviour?

Thanks

View 3 Replies View Related

Help With Reporting Service Using Excel

Oct 1, 2007

hello there,

i am trying to using SSRS with Excel. in the BI Design(Visual Studio) wehn i preview the report i can see the report.but when i deploy it on the localhost and try to view the report in there.i get this error.please help

An error has occurred during report processing.
Cannot create a connection to data source 'DataSource1'.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection

View 1 Replies View Related

In Touch With Reporting Service

Feb 25, 2008

Hello, All!

It`s the first time with Reporting Services and would like to know if there
are any performance problems when installed on the same server with a SQL
Server.
I`m a Database Administrator and I have a SQL Server into a DMZ with almost
200GB of data and nowadays the company is demanding a Reporting Service into
a DMZ and we don`t have a dedicated server to use with. Otherwise, we buy a
SQL Server license just for this request don`t worth.
So, we decide to install Reporting Service on this server, but I have no idea
about how much recource is needed to handle it and if this installation could
cause any issues.
Anybody knows how Reporting Service works? Are there any best practices when
installing Reporting Services on a OLTP SQL Server ?

Thanks

Juliano Horta

View 3 Replies View Related

XML And Reporting Service In 2005

Aug 19, 2005

Does anyone know if reporting services in sql server 2005 will supportquerying against the native xml datatype?

View 1 Replies View Related

Microsoft Reporting Service

Jul 20, 2005

I have the following Question:Is it possible to install a Reporting Service at IIS Webserver withoutSQL Server 2000 on the same machine.We have a Enterprise SQL Server at another machine and i don't want toinstall another SQL Server at a IIS.Thank you for all responsesFlecki

View 1 Replies View Related

Drilldown In SQl Reporting Service

Sep 30, 2006

Hi,

I'm new to SQL Reporting Service. Now only I've started studying that. My question is,

I wanna list out my product sales for each month for each keywords. For example, I have 4 products, some 15 keywords (its an ecommerce site. Visitor coming from a particluar keyword and buying some products. Wanna list out sales for each keywords and product for Every month. To know the quarter sales wanna see the sales and product name for particular keyword). I'm having reports for each month sales. like,



Keywords
Product A
Product B
Product C
Product D

Keyword 1
125
24
275
12

Keyword 2
456
245
67
1223

For quarter sales, I want to see the sales and keywords list for each month and for each products in the same report. I don't want to create one another report for each and every product and month. If I want to see the sales and keywords for a particular product I want a report like,For Product 1



Keywords
Month1
Month2
Month3
Month4

Keyword 1
125
24
275
12

Keyword 2
456
245
67
1223

and For Month 1



Keywords
Product A
Product B
Product C
Product D

Keyword 1
125
24
275
12

Keyword 2
456
245
67
1223

Just by using drilldown I want this report. If any other method is possible, please tell me. It's very urgent. Please Help me. I'm very new to SQL Reporting Service. Started studying before 2 days. Thanks.............

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved