Solved

Reporting Database info to reports

Posted on 2004-08-31
8
150 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
  • 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
 

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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now