Data Report Fails - Error "Failed getting rowsets from current data source"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg Teets - 26 Jan 2005 20:21 GMT

I am trying to run a data report using the DataReport Designer in VB.

When I run it I get "Failed getting rowsets from current data
source".

Can I look at the SQL statement that this report is generating and
using?

How can I troubleshoot this error?

Thanks.

Greg

Reply to this Message

Ant - 27 Jan 2005 06:19 GMT

Hi greg,

Hi, I found that I got this message when the data member property had no
Data member set to it. Make sure the DataEnvironment has a valid DataMember &
that this DataMember is set to the DataReporters DataMember property.
If this is all done & you want to see the SQL code, right click the
DataEnvironment object in the project explorer & choose 'View object', then
right click the command object & choose properties. This will open up a
dialogue box in which you can view & modify the SQL string. Hope this helps.
Ant

> I am trying to run a data report using the DataReport Designer in VB.
>
[quoted text clipped - 9 lines]
>
> Greg

Reply to this Message

Greg Teets - 27 Jan 2005 20:53 GMT

>I am trying to run a data report using the DataReport Designer in VB.
>
[quoted text clipped - 9 lines]
>
>Greg

Here's what I came up with in case anyone has the same problem:

I wound up starting from scratch, working through the sample data
report instructions in the VB help file.

The key thing seemed to be "Right click on Data Report designer and
click Retrieve Structure." This made the report follow the
relationships in the Data Environment.

It worked fine so I think I forgot this step in the original project.

Greg

Reply to this Message

VB Forum / Database Access / January 2005

Data Report Fails - Error "Failed getting rowsets from current data source"