resource file 'msmdsrv.rll' for locale '1049' could not be loaded

Hi forum,

does anyone know the cause of this error message?

23-Mar-2007 16:03:50

Computer: <ComputerName>

Source: MSSQLServerOLAPService

Category: None

Type: Error

Event ID: 25

Description: The resource file 'msmdsrv.rll' for locale '1049' could not be loaded. Switching to US English (1033) if available.

Tia,

/Gert

There is no localized version for locale 1049, or it was not installed.|||

Hello I'm with the same problem but from spanish(1034):

How can I solve it?

|||You need to install a version that includes the specific resource files for your locale. I'm not sure if one is available or not.

resource file 'msmdsrv.rll' for locale '1049' could not be loaded

Hi forum,

does anyone know the cause of this error message?

23-Mar-2007 16:03:50

Computer: <ComputerName>

Source: MSSQLServerOLAPService

Category: None

Type: Error

Event ID: 25

Description: The resource file 'msmdsrv.rll' for locale '1049' could not be loaded. Switching to US English (1033) if available.

Tia,

/Gert

There is no localized version for locale 1049, or it was not installed.|||

Hello I'm with the same problem but from spanish(1034):

How can I solve it?

|||You need to install a version that includes the specific resource files for your locale. I'm not sure if one is available or not.

RESOLVED - Help with SQL Query - "The multi-part identifier "alias field Name" co

Hi Everyone
This is the query and I am getting follwoing error message

"The multi-part identifier "InvDate.Account Reference" could not be bound."

SELECT MAX([DATE NOTE ADDED]) AS LASTDATE,
CC.[COMPANY],
CC.[ACCOUNT REFERENCE],
INVDATE.[LASTORDERDATE]
FROM CUSTOMERCONTACTNOTES AS CCN,
(SELECT *
FROM CUSTOMER) AS CC,
(SELECT MAX([INVOICE DATE]) AS LASTORDERDATE,
[ACCOUNT REFERENCE]
FROM INVOICEDATA
GROUP BY [ACCOUNT REFERENCE]) AS INVDATE
WHERE CCN.[COMPANY] = CC.[COMPANY]
AND CC.[ACCOUNT REFERENCE] COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS IN (SELECT DISTINCT ([ACCOUNT REFERENCE])
FROM INVOICEDATA)
AND CC.[ACCOUNT REFERENCE] COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS = INVDATE.[ACCOUNT REFERENCE]
GROUP BY CC.[COMPANY],CC.[ACCOUNT REFERENCE]
ORDER BY CC.COMPANY ASC

By the way its SQL Server 2005 Environment.
Mitesh
Well how about getting rid of:
- (select * from customer) -- just use a simple join to customer
- get rid of the collate statements in your where clauses.

Also, you'll need to add INVDATE.[LASTORDERDATE] to your group by statement.

SELECT MAX([DATE NOTE ADDED]) AS LASTDATE,
CC.[COMPANY],
CC.[ACCOUNT REFERENCE],
INVDATE.[LASTORDERDATE]

FROM CUSTOMERCONTACTNOTES AS CCN,

CUSTOMER AS CC,

(SELECT MAX([INVOICE DATE]) AS LASTORDERDATE,
[ACCOUNT REFERENCE]
FROM INVOICEDATA
GROUP BY [ACCOUNT REFERENCE]) AS INVDATE

WHERE CCN.[COMPANY] = CC.[COMPANY]
AND CC.[ACCOUNT REFERENCE] IN (SELECT DISTINCT ([ACCOUNT REFERENCE]) FROM INVOICEDATA)
AND CC.[ACCOUNT REFERENCE] = INVDATE.[ACCOUNT REFERENCE]

GROUP BY CC.[COMPANY],CC.[ACCOUNT REFERENCE], INVDATE.[LASTORDERDATE]
ORDER BY CC.COMPANY ASC|||Thanks Phill,

Your solution was just spot on.

Just out of curosity, how do you read any SQL Query, for e.g. like mine and find what is wrong.

Mitesh|||Experience, I guess. When you work with it enough, you can just "read" SQL and understand what's going on.

I really don't think you need the "select distinct [account reference] from invoicedata" query in your where clause though. You already have a distinct list from the INVDATE query in your FROM statement. Your where clause should probably be:

WHERE CCN.[COMPANY] = CC.[COMPANY]
AND CC.[ACCOUNT REFERENCE] = INVDATE.[ACCOUNT REFERENCE]

required filter on Ad-hoc reports

When using the Report Builder in SQL 2005 some larger reports give me an
error message = filter required.
I assume this is somthing is a setting somwhere but where?
--
Peter
Peter.freeborn@.halliburton.comGo to Filter from the menu bar and select a column for the filter, you can
have prompt as well for the user to select the values.
I think, the Adhoc is designed in such a way that you need to set a filter,
because without filter it will be a long running query and will have great
effects on various things.
Amarnath
"Peter" wrote:
> When using the Report Builder in SQL 2005 some larger reports give me an
> error message = filter required.
> I assume this is somthing is a setting somwhere but where?
> --
> Peter
> Peter.freeborn@.halliburton.com

Request for the permission of type System.Data.SqlClien

I got this message when running the same project at my work which I worked on
at home without encountering it. Thanks for the help.
Request for the permission of type System.Data.SqlClienAdditional
information: Request for the permission of type
System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
bic
Seems that sou didnt approve SQLServer Client to run in the special context
you are using it (wheter you use it with Biztalk or Sharepoint or etc..). It
depends on the type of underlying application you are using, in sharepoint
you have to configure a configfile, in other enviroments you have to set
..NET security for that. (Perhaps at home you have assigned Fulltrust --> To
all and in the comapany there is a domain policy which dont allow any
assemblies to run until they are aproced by some security administrator)
If you have further questions just raise a hand ;-)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"bic" <bic@.discussions.microsoft.com> schrieb im Newsbeitrag
news:825EDB65-0534-4A1C-B343-DAE786D8E601@.microsoft.com...
>I got this message when running the same project at my work which I worked
>on
> at home without encountering it. Thanks for the help.
> Request for the permission of type System.Data.SqlClienAdditional
> information: Request for the permission of type
> System.Data.SqlClient.SqlClientPermission, System.Data,
> Version=1.0.5000.0,
> Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
> --
> bic

Request for the permission of type System.Data.SqlClien

I got this message when running the same project at my work which I worked o
n
at home without encountering it. Thanks for the help.
Request for the permission of type System.Data.SqlClienAdditional
information: Request for the permission of type
System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
--
bicSeems that sou didnt approve SQLServer Client to run in the special context
you are using it (wheter you use it with Biztalk or Sharepoint or etc..). It
depends on the type of underlying application you are using, in sharepoint
you have to configure a configfile, in other enviroments you have to set
.NET security for that. (Perhaps at home you have assigned Fulltrust --> To
all and in the comapany there is a domain policy which dont allow any
assemblies to run until they are aproced by some security administrator)
If you have further questions just raise a hand ;-)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"bic" <bic@.discussions.microsoft.com> schrieb im Newsbeitrag
news:825EDB65-0534-4A1C-B343-DAE786D8E601@.microsoft.com...
>I got this message when running the same project at my work which I worked
>on
> at home without encountering it. Thanks for the help.
> Request for the permission of type System.Data.SqlClienAdditional
> information: Request for the permission of type
> System.Data.SqlClient.SqlClientPermission, System.Data,
> Version=1.0.5000.0,
> Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
> --
> bic

Repost : Custom tools

Hi
i am posting this message again.
We have the chart control. But i know that we can change the chart type dynamically. So is it posible that we can change the chart control dll and add some combobox along with it which will give the various types of chart. On selecting the type , the corresponding chart type would be shown.I mean to say can i add custom tool which will have the existing chart control of report designer and an extra combo box to select the type at runtime. MrRobert Bruckner [MSFT] has given one solution for that is to have multiple chart types and make any one visible based on some parameter. But then doing that the report will become very heavy.
Can some one throw some light on the approach i have put .
Or is this feature available in the SP1.
Thanks in advanceCombo boxes (or custom controls) are not available in a report. You could
have a set of hyperlinks that changed the type via a parameter. I'm not sure
why you mean it will become "very heavy".
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari" <Hari@.discussions.microsoft.com> wrote in message
news:15F6CB61-A8EE-484D-BE0E-6AAFD396BA76@.microsoft.com...
> Hi
> i am posting this message again.
> We have the chart control. But i know that we can change the chart type
dynamically. So is it posible that we can change the chart control dll and
add some combobox along with it which will give the various types of chart.
On selecting the type , the corresponding chart type would be shown.I mean
to say can i add custom tool which will have the existing chart control of
report designer and an extra combo box to select the type at runtime.
MrRobert Bruckner [MSFT] has given one solution for that is to have
multiple chart types and make any one visible based on some parameter. But
then doing that the report will become very heavy.
> Can some one throw some light on the approach i have put .
> Or is this feature available in the SP1.
> Thanks in advance|||Dynamic (expression-based) chart types will not be available in SP1. We
understand that having multiple charts side-by-side and only one visible at
runtime (based on parameter) will make the design more complex. However, the
impact at runtime is very limited because if chart instances are hidden, no
processing/rendering of the chart will happen.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari" <Hari@.discussions.microsoft.com> wrote in message
news:15F6CB61-A8EE-484D-BE0E-6AAFD396BA76@.microsoft.com...
> Hi
> i am posting this message again.
> We have the chart control. But i know that we can change the chart type
dynamically. So is it posible that we can change the chart control dll and
add some combobox along with it which will give the various types of chart.
On selecting the type , the corresponding chart type would be shown.I mean
to say can i add custom tool which will have the existing chart control of
report designer and an extra combo box to select the type at runtime.
MrRobert Bruckner [MSFT] has given one solution for that is to have
multiple chart types and make any one visible based on some parameter. But
then doing that the report will become very heavy.
> Can some one throw some light on the approach i have put .
> Or is this feature available in the SP1.
> Thanks in advance|||Thanks for the reply Brian, but my question was more of asking whether custom controls can be made or not.
And why i meant it heavy is that when the report is processing it will take more time since it has process data for two chart separetely and while showing it , it is showing only one but inside both the charts are processed. Even if we use hyperlinks we must have defferent chart for each type. Is it available in SP1.
"Brian Welcker [MSFT]" wrote:
> Combo boxes (or custom controls) are not available in a report. You could
> have a set of hyperlinks that changed the type via a parameter. I'm not sure
> why you mean it will become "very heavy".
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Hari" <Hari@.discussions.microsoft.com> wrote in message
> news:15F6CB61-A8EE-484D-BE0E-6AAFD396BA76@.microsoft.com...
> > Hi
> > i am posting this message again.
> >
> > We have the chart control. But i know that we can change the chart type
> dynamically. So is it posible that we can change the chart control dll and
> add some combobox along with it which will give the various types of chart.
> On selecting the type , the corresponding chart type would be shown.I mean
> to say can i add custom tool which will have the existing chart control of
> report designer and an extra combo box to select the type at runtime.
> MrRobert Bruckner [MSFT] has given one solution for that is to have
> multiple chart types and make any one visible based on some parameter. But
> then doing that the report will become very heavy.
> > Can some one throw some light on the approach i have put .
> > Or is this feature available in the SP1.
> > Thanks in advance
>
>

ReportViewer1.SetQueryParameter getting message not a member of reportviewer

I am using the reportviewer control in vs2003 accessing the rs2005.

I get the message setqueryparameter is not a member and also i do

****************************************************************

PrivateSub populateReportViewer()

ReportViewer1.ServerUrl = "http://localhost/ReportServer"

ReportViewer1.ReportPath = "/SampleReports/Product Line Sales"

ReportViewer1.SetQueryParameter("ProductCategory", CategoryDropDown.SelectedValue)

ReportViewer1.SetQueryParameter("ProductSubCategory", SubCategoryDropDown.SelectedValue)

ReportViewer1.SetQueryParameter("StartDate", StartDate.Text)

ReportViewer1.SetQueryParameter("EndDate", EndDate.Text)

ReportViewer1.Parameters = Microsoft.Samples.ReportingServices.ReportViewer.multiState.False

ReportViewer1.Format = "HTML4.0"

EndSub

PublicSub SetQueryParameter(ByVal ParamName AsString, ByVal ParamValue AsString)

SetParameter(ParamName, ParamValue)

EndSub

***************************************************************************************

Please can someone provide me a sample code how to use the reportviewer control to call a report via storedproc with parameters.

Please help thank you very much for the information.

see this page : http://www.codeproject.com/aspnet/Reporting_Services.asp

Hope this will help

ReportViewer1.SetQueryParameter getting message not a member of reportviewer

I am using the reportviewer control in vs2003 accessing the rs2005.

I get the message setqueryparameter is not a member and also i do

****************************************************************

Private Sub populateReportViewer()

ReportViewer1.ServerUrl = "http://localhost/ReportServer"

ReportViewer1.ReportPath = "/SampleReports/Product Line Sales"

ReportViewer1.SetQueryParameter("ProductCategory", CategoryDropDown.SelectedValue)

ReportViewer1.SetQueryParameter("ProductSubCategory", SubCategoryDropDown.SelectedValue)

ReportViewer1.SetQueryParameter("StartDate", StartDate.Text)

ReportViewer1.SetQueryParameter("EndDate", EndDate.Text)

ReportViewer1.Parameters = Microsoft.Samples.ReportingServices.ReportViewer.multiState.False

ReportViewer1.Format = "HTML4.0"

End Sub

Public Sub SetQueryParameter(ByVal ParamName As String, ByVal ParamValue As String)

SetParameter(ParamName, ParamValue)

End Sub

***************************************************************************************

Please can someone provide me a sample code how to use the reportviewer control to call a report via storedproc with parameters.

Please help thank you very much for the information.

see this page : http://www.codeproject.com/aspnet/Reporting_Services.asp

Hope this will help