?
Solved

Reporting Database info to reports

Posted on 2004-08-31
8
Medium Priority
?
155 Views
Last Modified: 2010-05-02
Hello, I am trying to use the DataReport object.  I am getting an error....

Can anyone tell me if Visual Basic 6 comes with Crystal Reports?  I see there is a Crystal Reports Object, but do I need Crystal Report program to run it?  I probably do since it is named as a viewer.

The error I get with DataReport Object is : "Failed getting Rowset(s) from current datasource."  Can someone get me past this error?  Also can someone point me to example of how to use this tool?  I don't need to make complex report, just a basic one.

I would like advise on Crystal Reports and DataReport Object....   Which one is the quickest way to create a report.


Thanks...

0
Comment
Question by:strongd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 2

Expert Comment

by:x50Fade
ID: 11950680
Crystal is cool....Datareport is fine....

I use Data reports for basically all my reporting needs....I have yet to do something that is not possible in Datareports...

How are you using the Datareports?   Through Data Environment......or something else

Please elaborate a bit more on how u are using it and where it gives ou the error
0
 

Author Comment

by:strongd
ID: 11965777
I am trying to use Data Environment.  I think I have everything setup right but I keep getting the error "Failed getting Rowset(s) from current datasource."  

Now I know my query works.  I even opened up Enterprise Manager, and used the same SQL statement to test it.  It worked there, so I cut and pasted it into CommandText property in my command1, but it keeps giving me this error...  Does this error mean that it is not getting any records back?

I would like to use this tool, but I have read on other sites that is a kind of unstable and weird to get to work.  If I could just gets it to work with this basic query, I will use it.

0
 
LVL 2

Accepted Solution

by:
x50Fade earned 1000 total points
ID: 11970499
I dislike using the data environment....It's not a good tool....a lot of dwarwbacks....

So instead I stil use Datareports, but without the dataenvironment...

Make up your report in Datarepots, set the "field name" propperty of the labels to whatever the fields are that your wish to report (inside your DB).

Now you can open your recordset using using normal ADO coding.....

Once you populate your rs, merely do this

set Datareport1.recordsource rs
datareport1.show
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:strongd
ID: 11999142
I just got this message...  I will check this out....  if it works, I'll give x50Fade the points...

Give me a little bit to check and test it...


0
 

Author Comment

by:strongd
ID: 11999296
x50Fade....  can you supply sample code...


Thanks

0
 

Author Comment

by:strongd
ID: 12000831
Never mind X50Fade... I got it to work... Here are the points...
0
 

Author Comment

by:strongd
ID: 12000849
Thanks a lot x50Fade, what you told me worked great.  I wish I knew this sooner.  I wasted a couple of days messing with the stupid dataenvironment.

0
 
LVL 2

Expert Comment

by:x50Fade
ID: 12003581
No Problem

Glad I could help
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month14 days, 20 hours left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question