rsErrorReadingNextDataRow

eralper

unread,

Jan 24, 2005, 4:31:06 AM1/24/05

to

Hi,

I'm getting the below error with my reports.
Any help is appretiated much.
Thanks...

An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot read the next data row for the data set DataSet1.
(rsErrorReadingNextDataRow) Get Online Help
A severe error occurred on the current command. The results, if any, should
be discarded.

Kmistic

unread,

Mar 7, 2005, 1:51:04 PM3/7/05

to

I am having this issue too. Did you resolve this?

Kmistic

unread,

Mar 8, 2005, 9:05:05 AM3/8/05

to

Thanks for replying. i am not using linked servers i am actually getting
this error from reporting services.

"eralper" wrote:

> Hi,
>
> I was using Linked Servers for the data source of the reports. And
> dynamically changing the database server name and database name by passing
> these values as parameters.
>
> On some of the servers I was using "." to map the database server to itself.
> I changed the passed value "." to database server name for the database
> server name parameter.
>
> This change worked.
>
> http://www.kodyaz.com/ShowPost.aspx?PostID=52#52
>
> Eralper
> http://www.kodyaz.com

Kmistic

unread,

Mar 8, 2005, 9:51:05 AM3/8/05

to

I would like to mention that this error only happens when non-adminstrators
try to view the report. I have the dataset being generated by a stored
procedure that executes a dtspackage using xp_cmdshell. When i take the
xp_cmdshell command out of the stored procedure it works fine. I pass the
xp_cmdshell the dtsrun command using sa and its password. I don't understand
what else i might need to do to enable the none admins to work.

eralper

unread,

Mar 8, 2005, 9:55:04 AM3/8/05

to

Hi,

I was successfully running the report from VS.Net but it was failing when I
deploy it onto the report server. Do you have a similar behavior?

selva

unread,

Sep 10, 2007, 4:45:57 AM9/10/07

to

hi
i am getting error msg in sqlservice report

cannot read the next data row for the data set dataset1 in sql reporting service

i need a solloution for this problem

From http://www.developmentnow.com/g/115_2005_1_0_0_455079/rsErrorReadingNextDataRow.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

dadkins

unread,

Feb 7, 2008, 2:46:57 PM2/7/08

to

I am also getting this error intermittenly on some reports. It is text query not a stored procedure and sometimes it works for the same user. The database and table being queried have high activity. Could this be a colision or exclusive lock? Since it's intermittent it is hard to troubleshoot.

From http://www.developmentnow.com/g/115_2005_1_0_0_455079/rsErrorReadingNextDataRow.ht

Nesy

unread,

Jun 17, 2009, 10:25:18 AM6/17/09

to

I got same error - I ran same report in Visual Studio using Preview. I got same error but with more information (divide by zero error). The Preview should also give you more information even if different error.

From http://www.developmentnow.com/g/115_2005_1_0_0_455079/rsErrorReadingNextDataRow.ht

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/