Hi everybody,
I have a question does it possible to have the param prompt in the different language without doing multipe report for each language, I saw it is possible for the label, but I didn't see how to do for the prompt param.
I hope someone could help me.
Thank you.
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
I want to make my report in both english and spenish language.
how can I set culture for reports?
Hello to all!
I want to translate de interface of the Report Manager to Portuguese. I'm develop a class that implements
Microsoft.Reporting.WebForms.IReportViewerMessages The class is in a file called "ReportViewerMessages.cs". The structure is like this, the project is called "PortugueseReportManager", there is a namespace named "PortugueseReportManager" and the name of the class is "ReportViewerMessages".
So far so good, but when I change de web.config file in the report manager folder I'm getting over and over this error message when I try to see a report: The type PortugueseReportManager.ReportViewerMessages, PortugueseReportManager, Version=1.612.19.1, Culture=neutral, PublicKeyToken=5cdefa29ce50bd9e does not implement IReportViewerMessages or could not be found
This is the line that I add to the config file:
<add key="ReportViewerMessages" value="PortugueseReportManager.ReportViewerMessages, PortugueseReportManager, Version=1.612.19.1, Culture=neutral, PublicKeyToken=5cdefa29ce50bd9e"/>
The version is correct and the public key token I get by strong signing the class and then run de command: "sn -T PortugueseReportManager.dll
I copy the dll file to the Bin folder of my Report Manager folder.
Please, can anyone help me in this one? I try a lot of combinations in the config file and so far I did't get any results.
Thanks in advance!
Is it possible to include a text/string as suffix(append to the end of textbox) to an report parameter prompt string ? Something like this
Enter Date: [ Textbox ] format:mm/dd/yyyy
Enter Age:[Textbox ] e.g 50
I need to include text like the one that I have highlighted in blue. Could someone help me out?
Request is to have a Requirement number from the requirement form generate a report in Reporting Services with the requirement number as a filter.
I can set up the parameter - how does the value get there? Should I be asking this question in the Visual C# group?
Thanks!
Terry B
Hello,
since a couple of days I'm fighting with RS 2005 and the Stored Procedure.
I have to display the result of a parameterized query and I created a SP that based in the parameter does something:
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE PROCEDURE [schema].[spCreateReportTest]
@Name nvarchar(20)= ''
AS
BEGIN
declare @slqSelectQuery nvarchar(MAX);
SET NOCOUNT ON
set @slqSelectQuery = N'SELECT field1,field2,field3 from table'
if (@Name <> '')
begin
set @slqSelectQuery = @slqSelectQuery + ' where field2=''' + @Name + ''''
end
EXEC sp_executesql @slqSelectQuery
end
Inside my business Intelligence Project I created:
-the shared data source with the connection String
- a data set :
CommandType = Stored Procedure
Query String = schema.spCreateReportTest
When I run the Query by mean of the "!" icon, the parameter is Prompted and based on the value I provide the proper result set is displayed.
Now I move to "Layout" and my undertanding is that I have to create a report Paramater which values is passed to the SP's parameter...
So inside"Layout" tab, I added the parameter: Name
allow blank value is checked and is non-queried
the problem is that when I move to Preview -> I set the value into the parameter field automatically created but when I click on "View Report" nothing has been generated!!
What is wrong? What I forgot??
Thankx for any help!
Marina B.
I had thought that this was possible but I can't seem to figure out the syntax. Essentially I have a report where one of the parameters is populated by a stored procedure.
Right now this is easily accomplished by using "exec <storedprocname>" as the query string for the report parameter. However I am not clear if it is possible to now incorporate User!UserID as parameter to the stored procedure. Is it? Thanks
I am using report builder 3.0.
I have a report parameter called para1 which is a drop-down list and what I want to do is display another report parameter based on the para1 selection.
So for example, para1 contains a, b, c choices. if a user selects b, I would like para2 to display but if the user selects a or c, I don't want the para2 to display.
I'll go to a dataset, open up the query designer, add a new parameter, then refresh the fields, but the parameter won't be added as a report parameter. If I go to the dataset properties under the list of parameters, the value in the dropdown will be blank. However, sometimes this will automatically add.Â
Is this a bug in Visual Studio? How do I get around this?Â
I have created a menu report listing available reports and am setting the Jump to settings of each text box in the list to take the user to the relevent report. But I am having a problem setting up drill down to reports with multivalued parameters.
What I want to happen when the user drills down is for the report to open up with no parameter values selected. This works for single value parameters where I have set Null as the default value. But I have not been able to figure out how to do this with MVPs. Does anybody know if this is possible?
As a workaround I have been using Jump to URL (rather than Jump to report), which has no problem opening the report without having to pass any values for the MPV. But I do not like using this as I use different DEV/UAT and PROD environments so would have to amend the URL for each environment.
Seems like this should be possible... Any idea?
Cheers, Mike
PS: I should add I can Jump to reports with MVP without specifying a parameter in development studio but not when the report is published.
OK, I'm pretty sure that the answer to my questions is "no", but the boss is pushing, and I thought I'd double check.
I want the selection of one report parameter to decide what shows up for another report parameter. Specifically in my case it has to do with dates. I have narrowed the results down to monthly dates, meaning that the starting dates always start with mm/1/yyyy and the ending dates are always mm/31/yyyy (for a 31 day month).
The boss wants the ending dates to always be >= the month of the starting dates. So, if the user choose 1/1/2007 for starting, the minimum ending date would be 1/31/2007, etc.. Since the parameters are loaded at report initiation, and SSRS isn't really event driven, I didn't think this was possible. I just wanted to make sure before I tell the boss that it's not. Please advise.
Here's tricky one.
I have a fairly complex report that was given to me that was hard coded for single parameters. There is a dropdown for each market (created from a query in SSRS). The users have to run for each market each week.
Is there a way to use this report as a Sub-report inside a list of a master report and then use a mult-value parameter?
I want this multi-value parameter to build the values for the list and then run the "sub-report" for each value.
Essentially, I want to create a for each loop.
Any ideas?
I am working on reports in SSRS 2008 (not R2)... There are some reports with parameters that are hidden when the report is accessed through normal URL using ReportViewer.asx..The thing is that these hidden parameters need to be visible when the report is accessed using SSRS Report Manager.
View 3 Replies View RelatedI am extracting RS reports through a WebService:
report = execService.Render("EXCEL", null, out extension, out mimeType, out encoding, out warnings, out streamIds);
Some works fine but some are generating the following SoapException:
Error during processing of €˜ReportParameterTime€™ report parameter. ---> Error during processing of €˜ReportParameterTime€™ report parameter. ---> Error during processing of €˜ReportParameterTime€™ report parameter.
I set required parameters to their default values. In this specific report I have two required parameters:
1: ReportParameterTime, String
2: ReportParameter1, String
I set them to their default values (ReportParameterTime to "[Czas].[Kalendarzowy].[Rok].&[2007]" - means
Time Calendar Year 2007) but I am getting the exception above. I set parameters using this code:
execService.SetExecutionParameters(parameterValues.ToArray(), CultureInfo.CurrentCulture.Name);
Where parameterValues is a List<ReportExecution2005.ParameterValue>.
When I am using Microsoft.Reporting.WinForms.ReportViewer the report is generated without
any problems. I can see one parameter to choose: "Kalendarzowy" (means adj. Calendar) and can
select years, the default value is "2007".
What am I doing wrong and how can I fix this error ? Does anybody know ?
Regards,
Daniel
Hi,
I'm having problems navigating from one report to another one if the second report has a multi-valued report parameter. When I navigate to the second report, I don't pass any parameters, but I get an error "parameter is missing a value" for the multi-valued report parameter. I have it setup as allow "multi-value" and "blank value". Any idea what the issue might be?
Thanks.
Hi,
I want to give filtering criteria in my SSRS report.
I have drop down list control having list of Email's of clients.
So, how can i pass the value of the particular Email id in my SSRS report using Report Viewer control?
How can i pass user input as parameter in my report using visula studio 2005?
Thanx,
Ruja
I am designing a report which will be used under the subreport control of a master report, now i am using a stored procedure for the subreport which has two parameters.
In the subreports dataset parameters tab, how can i mention the master reports columns, since i do not see the master reports columns here. since it is a different report.
If i use a hardcoded select query then i can just say
select address, city, state, zipcode from customer where (customerid = @customerID)
but i am using a stored proc. how to define the parameters under datasets parameter tab.
Thank you very much for the information.
Dear friends,
Is there any provision to make the SQL Server Reporting Services commands,returning from SQL query, instead of writing that directly in the report.
Best Regards,
Baburaj
I have a report parameter textbox in my SSRS report which has the parameter properties as "allow null value" and "allow blank value" checked.
How I can ensure that when the value is entered in textbox, it should accept any character ie. The SQL code I should write so that all the characters inputted via the report parameter are accepted.
Hi All,
I have a question, How to user the Multi value in Visual Studio Report Designer.
My dataset contains the following
Select empno,empname,basicpay,deptcd from employee where deptcd in (substring(@gdept,1,4))
Here variable gdept is the report parameter. I am passing the value.
it works fine with single value.
( the source of gdept is a another dataset to list the deparment code+name,
Example
DEP1 - COMPUTER
DEP2 - ADMIN
DEP3 - FINANCE
)
when I preview, i have a combo box to select the department.
If I choose one deparment, it works fine.
If I choose more than one department or select all I have error message
"substring function requires 3 aruguments."
what is wrong is the query
Please advise.
Cheers,
Saleem
Hi All,I already have a web site running with SQL Server as a backend (inenglish)For future growth, I would like to make it localized. Regardingthe database, I have come up with several approaches.1) just simply add the column in those table which needs differentlanguage.2) add additional tables to do it.3) create a new database to store different language's informationAs mentioned, my database have already been implemented, so the minimummodification is preferred. Could you guys suggest me the best way to doit?Another thing, if I alter my existing database into UTF-8 now, will itaffect the original data (ie. English).Thanks.Ice
View 7 Replies View RelatedHi,I have a simple 'user' table and an ASP form that connects to it. Iwant users of all languages to be able to type in their registrationinfo, in their own language, store it that way, then have another pagethat displays it.Are there any specific settings I need in SQL Server to handle this?Thanks
View 4 Replies View Related
How can i add resources to my report (*.rdl) at runtime depending upon the curren culture ie text ,date formats ,currency setting getting changed according to current culture.Is there any way i can define resource file for report?
Hello,I am working on a Blog and a Documents systems.What I need is:1. Each blog can have various language versions.2. Each document can have various language versions.I have been thinking about this and I end up with two approaches:1. Use a structure where all tables depend on a localized table:BLOGS|---- BlogsLocalized|---- BlogsPosts|---- BlogsRatings|---- BlogsComments2. Use a structure where each table has a localized versionBLOGS|---- BlogsLocalized|---- BlogsPosts|---- BlogsPostsLocalized|---- BlogsComments|---- BlogsCommentsLocalized3. Create a simpler, without localization, in SQL and in my web sites have different versions for each language.The same approach is under thinking for DocumentsTables.Could someone give me some advice?I have been looking in internet but until no I couldn't find anything really useful.Thanks,Miguel
View 1 Replies View RelatedHi.
I have distributed databases in different language versions, I am creating a stored procedure, and this problably in future is going to be migrated to other SQL Server database. the query that I have inside the stored procedure is this:
Insert Into Prueba Values(14,'31/07/1999') -------> format date of this query is in Hispanic version (this works fine)
But, If this query is migrated to other SQL Server and it's version would be in English, that query wouldn't work, the principal reason is the format date.
Solution that I have on mind is creating a stored procedure that receives three parameters the month,day and year. I want to identify the localization of that SQL Server database and use "IF" conditions and inside of these concatenate month,day and year obviously depending of the date format identified through "IF" conditions.
If somebody has an idea to solve this or somebody knows how to identify the locatization in an SQL Server database I would be thankful.
Thank you again and best regards.
Christian
Hello all,
I'm working on an ASP.NET with a SQL server for database. Some of the tables, for example, contain information such as different types of Fabrics (silk, cotton, etc..) . I'd like to have this table localizable (English and French for instance). Is this possible ? Is there an equivalent of resource files in SQL server ?
Or do I have to do this manually ? (have 2 separate fields in the table for those 2 locales)
Hi,
I am implementing a "customizable resource provider" for Globalization based on Sql Server instead of resource files. After reading the following articules:
http://msdn2.microsoft.com/en-us/library/azx5x197.aspx
http://msdn2.microsoft.com/en-us/library/9b1d2yze(en-US,VS.80).aspx
I was able to produce a library that save local resources and and retrive resources from Sql Server using "GetGlobalResourceObject() and GetLocalResourceObject()", but I am having trouble to make it work with "Intelicense".
I think that the issue is related to class derived from "System.Web.UI.Design.DesignTimeResourceProviderFactory" class.
Does anyone knows where I can get more information regarding customizable resource provider and intelicense?
Note: I do not know how to attach my code.
Thank you,
Rj3
I have written this ugly expression because I didn't know any other way. What I am trying to do is convert an English date string to a French string.
example
January 2005 ---> Janvier 2005
Thank you,
Pavel
=Switch(
Month(CDate(Fields!Month.Value) ) = 1, "Janvier" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 2, "Fevrier" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 3, "Mars" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 4, "Avril" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 5, "Mai" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 6, "Juin" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 7, "Juillet" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 8, "Aout" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 9, "September" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 10, "Octobre" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 11, "November" & " " & Year(CDate(Fields!Month.Value)),
Month(CDate(Fields!Month.Value) ) = 12, "December" & " " & Year(CDate(Fields!Month.Value))
)
Is there a synonym for the group BUILTINUsers which can be used for GRANT ... TO and sp_grantlogin/sp_grantdbaccess, but which will work on localized computers?
I have a number of automated unit tests I wish to run on two different computers. The process involves recreating a database if it does not exist and then granting access and privileges to the BUILTINUsers group.
The problem is that one computer is installed with a Swedish Windows XP Professional (the users group is called BUILTINAnvändare) and the other is an English WinXP MCE (the group is called BUILTINUsers) so I cannot easily script this.
An alternative is to be able to retrieve the respective name through a .NET class or the Windows API.
Is any of this possible?
Thanks,
Johan
Hi everyone,I followed the steps below to localize the report viewer control accoring to http://msdn2.microsoft.com/en-us/library/ms251723(VS.80).aspx"
Deploying Localized Versions of ReportViewer ControlsThe ReportViewer control includes language packs for eight languages: Chinese-Simplified, Chinese-Traditional, French, German, Italian, Japanese, Korean, and Spanish. To use a localized version of the control, you must do the following:1. Run ReportViewer.exe.2. Navigate to the folder that contains the language pack you want to use. Language pack folders are located at <drive>:Program FilesMicrosoft Visual Studio 8SDKv2.0BootStrapperPackagesReportViewer<lang>.3. Run ReportViewerLP.exe."
But I could not find the ReportViewerLP.exe in the step 3. Could anyone please tell me why?Thanks a lot.Danny
I have a table called country that will store all the country related details in it. Below is the screenshot of my country table.
I want to localize this table to Japanese language. I googled out and found out that a new table needs to be created for storing the data in localized language.
If that's the case do we need to manually translate the text in the country table for each and every country?
Is there any automated process for that? Just like not translating the text manually for each and every rows..
This is because I have few more tables in which the text are not static. they will get loaded on a daily basis. So i will not be able to translate them every day..
Hi,
I have a RDLC report in an aspx page.
The report has a table one of whose data column has a hyperlink.
ServerName Date ProjectStatus
Srv1 01/10 Green
Srv2 01/10 Red
Srv 3 01/10 Green
and the second shows the detailed history per server,
eg for Srv1
Table 2
ServerName Date ProjectStatus
Srv1 01/10 Green
Srv1 01/09 Green
Srv1 01/08 Red
Srv1 01/07 Red
Srv1 01/16 Red
On click of the hyperlink a report parameter SelectedServerName is set to say Srv1 (1st row).
The report is reloaded and Table 2's data set fetches the results only for Srv1 .
This works fine in RDL format.
But when i embed the report in an aspx page in RDLC format the Parameter value is not set even after clicking the link.
Hardcoding the value works fine
ReportParameter[] p = new ReportParameter[1];
p[0] = new ReportParameter("SelectedServerName", "Srv1");
ReportViewer1.LocalReport.SetParameters(p);
How do i pass the value of ServerName corresponding to the link clicked and refresh the report?
in RDLC?