encoding problem

Hi
I use Oracle data source. The report is in Polish. When I try display some text from database or use report parameters, this text is not written correctly. The environment on the machine, where is installed Reporting Services is rather correct, when I am using SQL*PLUS it is ok. I linked Oracle database to MSSQL, I used Query Analyzer, the text was written correct in Polish. What to do?
morganWhat is the report language set to?
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"morgan" <morgan@.discussions.microsoft.com> wrote in message
news:9E40E53A-C040-470F-89E2-0E9807BA98D7@.microsoft.com...
> Hi
> I use Oracle data source. The report is in Polish. When I try display some
text from database or use report parameters, this text is not written
correctly. The environment on the machine, where is installed Reporting
Services is rather correct, when I am using SQL*PLUS it is ok. I linked
Oracle database to MSSQL, I used Query Analyzer, the text was written
correct in Polish. What to do?
> morgan|||Polish is the report language. By I used English ( US) too.
morgan
"Ravi Mumulla (Microsoft)" wrote:
> What is the report language set to?
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "morgan" <morgan@.discussions.microsoft.com> wrote in message
> news:9E40E53A-C040-470F-89E2-0E9807BA98D7@.microsoft.com...
> > Hi
> >
> > I use Oracle data source. The report is in Polish. When I try display some
> text from database or use report parameters, this text is not written
> correctly. The environment on the machine, where is installed Reporting
> Services is rather correct, when I am using SQL*PLUS it is ok. I linked
> Oracle database to MSSQL, I used Query Analyzer, the text was written
> correct in Polish. What to do?
> >
> > morgan
>
>

Enabling remote errors

Hi. I am trying to get remote errors to display in Report Manager. I've set the "EnableRemoteErrors" configuration value to True in the ReportServer.ConfigurationInfo table. Then I restarted both the Reporting Services Service and IIS. However, I am still seeing the following message when running a report:

An error has occurred during report processing.

What am I missing?

Thanks

Has anyone had a chance to look into this? Please let me know if you need more information. Thanks.

- Mark

|||

Check the reportserver logfiles (not the service logfiles!). They may contain more details about the error.

The logfiles are typically located in: \Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\Logfiles

-- Robert

|||

The problem has fixed itself. I am not sure how, but it did. I haven't made any changes. The only thing I did was reload my data processing extension. I doubt that's what fixed the problem because afterwards I was able to change the "EnableRemoteErrors" value back and forth and see the effect immediately, without restarting or reloading anything.

Strange...

|||

Hi,

I am pretty new to reporting services, can you please help me on how to set the 'EnableRemoteErrors' ?

Thanks in advance.

|||

Please read this related thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=230593&SiteID=1

-- Robert

Enabling remote errors

Hi. I am trying to get remote errors to display in Report Manager. I've set the "EnableRemoteErrors" configuration value to True in the ReportServer.ConfigurationInfo table. Then I restarted both the Reporting Services Service and IIS. However, I am still seeing the following message when running a report:

An error has occurred during report processing.

What am I missing?

Thanks

Has anyone had a chance to look into this? Please let me know if you need more information. Thanks.

- Mark

|||

Check the reportserver logfiles (not the service logfiles!). They may contain more details about the error.

The logfiles are typically located in: \Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\Logfiles

-- Robert

|||

The problem has fixed itself. I am not sure how, but it did. I haven't made any changes. The only thing I did was reload my data processing extension. I doubt that's what fixed the problem because afterwards I was able to change the "EnableRemoteErrors" value back and forth and see the effect immediately, without restarting or reloading anything.

Strange...

|||

Hi,

I am pretty new to reporting services, can you please help me on how to set the 'EnableRemoteErrors' ?

Thanks in advance.

|||

Please read this related thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=230593&SiteID=1

-- Robert

Enable Report Builder for User

I cannot figure out how to display the 'Report Builder' icon in the toolbar for a user.

I've tried setting the different security roles, but the icon doesn't display.

Thanks.

I guess what I should have asked was -- "How do I deploy Report Builder to a user?"

I've found that this URL will execute Report Builder -- http://server name/reportserver/reportbuilder/reportbuilder.application

What is the best way to deploy ReportBuilder to a user?

|||

Hi,

If I am correct, you want the user to build his own ad-hoc reports using the report model. If this is correct, when the user click on the report builder, he will be able to select the report models (already deployed on the production server).

When user selects the report model and the format for the report, the report builder is available to the user as clickonce application. It would require .NET framework to be available on the user's machine as prerequiste.

Hope this helps.

Virendra

|||

Hi Virendra,

I am having the same issue with Report Builder as Pwomack.

Like Pwomack i found that same link to http://<<server>>/reportserver/reportbuilder/reportbuilder.application although i couldn't use it because our users work with Res Powerfuse in a Terminal Server environment (users don't have access to the local C: drive and .Net Framework tries to place Tmp files in Documents & Settings\username\local settings\... which is prohibited in our environment / infrastructure.)

I've been testing and i've tried to adjust user rights and such but without luck. The .Net framework is installed on our servers. Do you have any other suggestions where i could look?

With regards,

Gawelles

Enable Report Builder for User

I cannot figure out how to display the 'Report Builder' icon in the toolbar for a user.

I've tried setting the different security roles, but the icon doesn't display.

Thanks.

I guess what I should have asked was -- "How do I deploy Report Builder to a user?"

I've found that this URL will execute Report Builder -- http://server name/reportserver/reportbuilder/reportbuilder.application

What is the best way to deploy ReportBuilder to a user?

|||

Hi,

If I am correct, you want the user to build his own ad-hoc reports using the report model. If this is correct, when the user click on the report builder, he will be able to select the report models (already deployed on the production server).

When user selects the report model and the format for the report, the report builder is available to the user as clickonce application. It would require .NET framework to be available on the user's machine as prerequiste.

Hope this helps.

Virendra

|||

Hi Virendra,

I am having the same issue with Report Builder as Pwomack.

Like Pwomack i found that same link to http://<<server>>/reportserver/reportbuilder/reportbuilder.application although i couldn't use it because our users work with Res Powerfuse in a Terminal Server environment (users don't have access to the local C: drive and .Net Framework tries to place Tmp files in Documents & Settings\username\local settings\... which is prohibited in our environment / infrastructure.)

I've been testing and i've tried to adjust user rights and such but without luck. The .Net framework is installed on our servers. Do you have any other suggestions where i could look?

With regards,

Gawelles

Empty report: displayed on server 1, error on server 2

Hello,

I'm deploying the same report on different servers, same database. For the year 2007, I have no data. When I display the report on server 1 or in VS2003 locally, I see an empty report. But on server 2, I have the "rsProcessingAborted" error.

Is there a way to configure the server so that it displays an empty report even if the dataset returned is empty?

Thanks for the answers!

Tiago

Usually the report is empty if the resultset is empty. Have you looked at the logfiles (\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Logfiles)? If processing was aborted there is usually an error (empty resultsets do not cause errors)..
|||

Yes I did. Indeed, the error happens when the resultset is empty, but it should display an empty report, not an error.

The error is the following (LogFile):

w3wp!processing!11a0!30.05.2006-14:44:10:: e ERROR: An exception has occurred in data source 'Query'. Details: System.IndexOutOfRangeException: [Product].[Activity Code]

at System.Data.Common.FieldNameLookup.GetOrdinal(String fieldName)

at System.Data.OleDb.OleDbDataReader.GetOrdinal(String name)

at Pmi.RaDGims.ReportingServices.DataExtensions.OseDataReaderWrapper.GetOrdinal(String name)

at Microsoft.ReportingServices.DataExtensions.MappingDataReader..ctor(String dataSetName, IDataReader sourceReader, String[] aliases, String[] fieldNames)

at Microsoft.ReportingServices.ReportProcessing.h..ctor(String A_0, IDataReader A_1, String[] A_2, String[] A_3)

at Microsoft.ReportingServices.ReportProcessing.a1.v()

at Microsoft.ReportingServices.ReportProcessing.ax.c()

at Microsoft.ReportingServices.ReportProcessing.a1.a(Boolean& A_0)

at Microsoft.ReportingServices.ReportProcessing.ax.b()

at Microsoft.ReportingServices.ReportProcessing.a1.a(Object A_0)

Configuration file difference between server 1 and 2 is only "ConnectionType" (0 in first server, 1 in second one). Moreover, in first server there is:

ReportingServicesService!library....

And in second one it is:

w3wp!library...

I believe it doesn't come from the report, but from the server configuration...

|||

Ok I found out. For an empty dataset:

Connection Type = OLE DB generates an empty report.

Connection Type = Olap Secure generates an error.

Had to compare LogFiles init section to find out =)

|||ps. Olap Secure is a custom connection type