Solved

Reporting Database info to reports

Posted on 2004-08-31
8
154 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
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 

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

Industry Leaders: 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

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
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…
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…

717 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