"Jennifer" <Jennifer@discussions.microsoft.com> wrote in message
news:EABA6B8A-7EE0-4125-B0CE-947A401EBFA0@microsoft.com...
>I have a problem where have a report that uses a shared datasource that
> references a SQL Server. My dataset called a stored procedure that builds
> a
> sql string and passes in the string to an openquery() command that queries
> a
> DB2 database that is a linked server on that same SQL Server. The results
> show up fine on the data tab when I run it, but when I try to preview the
> report I get the column headers but no fields show up. The query takes
> time
> to complete (under 2 minutes) I'm only returning 200 rows with under maybe
> 6
> columns and the preview mode indicates from the number of pages (6) that
> it
> knows some data should be returned. But none of the data is populating in
> the table. I've been on with Microsoft Tech Support going on three
> weeks
> now and they are clueless. Anyone have any idea why this is happening? I
> can view reports that are querying the linked server database w/o the
> stored
> proc. I get no error message just no data.

"Jennifer" wrote:

> I have a problem where have a report that uses a shared datasource that
> references a SQL Server. My dataset called a stored procedure that builds a
> sql string and passes in the string to an openquery() command that queries a
> DB2 database that is a linked server on that same SQL Server. The results
> show up fine on the data tab when I run it, but when I try to preview the
> report I get the column headers but no fields show up. The query takes time
> to complete (under 2 minutes) I'm only returning 200 rows with under maybe 6
> columns and the preview mode indicates from the number of pages (6) that it
> knows some data should be returned. But none of the data is populating in
> the table. I've been on with Microsoft Tech Support going on three weeks
> now and they are clueless. Anyone have any idea why this is happening? I
> can view reports that are querying the linked server database w/o the stored