sql server reporting services: Dataset error when deployed to Report Manager -- sql server reporting services

Dataset error when deployed to Report Manager

Ashley.Manos NO[at]SPAM gmail.com
8/2/2005 6:25:59 PM

sql server reporting services:

Hi

I've got a custom assembly which performs validation on parameters
prior to submitting the query to the database. My dataset which
retrieves the report data is in Text format and calls an appropriate
validation method on free-text parameters, such as dates and numbers.
When validation passes, the code returns a string formatted for use in
the query, and when it fails it returns a string value that the stored
procedure recognises as a dummy value and returns without SELECTing any
data. My custom assembly sets a user-friendly error message as a
property, which is displayed on the report in place of any data.

I've designed a number of reports using this method and it works well
in the Designer environment. However, I've deployed a few of them to
Report Manager and am getting the following error when pressing "View
Report":

An error has occurred during report processing. (rsProcessingAborted)
Cannot set the command text for data set 'Report'.
(rsErrorSettingCommandText)
Error during processing of the CommandText expression of dataset
'Report'. (rsQueryCommandTextProcessingError)

An example of one of the simple Datasets is:
="EXEC spAgentSettlementsDetailedRpt " &
Code.Validator.ResetValidator &
"@p_StartDate_IN = '" +
Code.Validator.ValidateStartDate(Parameters!p_StartDate_IN.Value) + "',
" &
"@p_EndDate_IN= '" +
Code.Validator.ValidateEndDate(Parameters!p_StartDate_IN.Value,
Parameters!p_EndDate_IN.Value) + "', " &
"@p_AgentID_IN = " + Parameters!p_AgentID_IN.Value.ToString() + ", "
&
"@p_WS_Code_IN = " +
Code.Validator.ValidateWSCode(Parameters!p_WS_Code_IN.Value,
Parameters!p_AgentID_IN.Value, false)

I'm happy to provide the code within the assembly if it would be of any
help in debugging this problem.

In deploying to the server, I have copied the assembly (dll) to the
\bin directory on the server and uploaded the rdl file as per normal.

Any help would be greatly appreciated. Thank you.

Ashley

Re: Dataset error when deployed to Report Manager

Ash
8/3/2005 12:04:36 AM

I've discovered what was causing the error... it turned out to be a
security/permissions problem. The validate date methods attempted to
set the culture of the current thread to "en-AU" with the following
statement:

Thread.CurrentThread.CurrentCulture = New CultureInfo("en-AU")

This was to get around the fact that the result of the VB IsDate()
function appears to be dependent upon the culture settings of the
server. It was always returning false for dd/mm/yyyy dates such as
13/1/2005.

The above line of code was causing an exception to be raised in the
assembly and hence was returning garbage to the dataset.

Does anyone know the precise reason that setting the culture of the
thread, once the report is deployed, results in an exception?

[quoted text, click to view]

Re: Dataset error when deployed to Report Manager

Ash
8/3/2005 12:04:51 AM

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.