• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 197
  • Last Modified:

Best Tool to create reports ??

I have a vb app connected with msde engine, I need to create few reports, reports will be lunched from vb app based on selection criteria on the screen. What would be fastes and easiest tool/method of creating them ??
Thanks
0
Pkrol1
Asked:
Pkrol1
  • 3
  • 2
  • 2
  • +2
3 Solutions
 
_agj_Commented:
i think u cud use crystal reports.
0
 
Pkrol1Author Commented:
that I know , I dont wanna buy another product
0
 
_agj_Commented:
if u got access, u cud use access reports.

there is also a report designer component that comes with vb6.
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
ShauliCommented:
If you don't want to buy a good report generator, such as Crystal Reports, or ActiveReports, then you can always use the integrated DataReport. To do that, set a reference to Microsoft Data Report (From the menu bar select Project, click reference and scroll down to Microsoft Data Report. Check the box on the left).
The help is in MSDN so you can start testing it, and ask specific question in this site when you need help.

S
0
 
Pkrol1Author Commented:
I would be probably most interested the one that comes with vb6 , any examples how to set it up , connect with database etc ??
0
 
JR2003Commented:
DataReports:

First you have to add text fields to the data report with the DataField property set to the name of the field in the table.
Then to show it:

    Dim sSql As String
   
    sSql = "select * from MyTable"
    Dim MySet As ADODB.Recordset
    Set MySet = CreateRecordset(sSql) '<--- However you create your recordsets

    Dim rpt As MyDataReport
    Set rpt = New MyDataReport
    With rpt
        Set .DataSource = MySet
        .Refresh
        .Show vbModal
    End With
   
0
 
Pkrol1Author Commented:
I will try this example tonight thanks for help
0
 
SethiCommented:
I would suggest buying VSView reports from ComponentOne. Infact buying their new suite will be a cheaper opetion and you will get more than 100 ActiveX controls along with it.

I posted the same question last year as I hate Crystal Reports. I have been using VSView reports since then and it works like a Charm.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 3
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now