Solved

Reporting Database info to reports

Posted on 2004-08-31
8
153 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 250 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

736 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