Solved

how to create a report in vb

Posted on 2002-06-18
9
168 Views
Last Modified: 2010-05-02
i want to create a report from vb. i connect to an access database and i would like to generate some reports based on the user's selection on the form.

how do i go about creating the report from scratch and how can i interface it from vb. im using vb6

Thanks
0
Comment
Question by:Sankar030999
[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
9 Comments
 
LVL 2

Expert Comment

by:TrueDrake
ID: 7090297
Hi,

This can be quite complex. You could hire a professional or you can learn VB and Access, try some code and then come back here if you can't find a solution.

Cheap solution, well maybe!
0
 
LVL 18

Expert Comment

by:bobbit31
ID: 7090323
you can use a data report.

first set up a dataenvironment. (project/more activex designers/data environment)

set up your connection to your access db in the wizard.

then add a data report.  

open up your dataenvironment, add a command and you should see the fields from your table.

you can then drag those on to the data report.
0
 
LVL 5

Accepted Solution

by:
rpai earned 33 total points
ID: 7090344
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!

 
LVL 70

Expert Comment

by:Éric Moreau
ID: 7090421
0
 

Expert Comment

by:john1811
ID: 7091622
Hi,
     You can use Data Report for report generation. You have to pass parameters to data report. The parameter is the user selection on the form. If you need further help revert back

Cheers,
John
0
 

Author Comment

by:Sankar030999
ID: 7105520
hi,
sorry for the late response. Your solns worked fine. But I find that bobbit, rpai and emoreau have all posted almost the same soln. Though I used the url provided by rpai, i donno how i should give the pts...
sankar
0
 

Author Comment

by:Sankar030999
ID: 7105560
hi,
sorry for the late response. Your solns worked fine. But I find that bobbit, rpai and emoreau have all posted almost the same soln. Though I used the url provided by rpai, i donno how i should give the pts...
sankar
0
 
LVL 5

Expert Comment

by:rpai
ID: 7105603
Sankar, There is a way to split points. You need to ask for help from the moderator.
0
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7108327
sankar

I reduced the points to 33 and refunded the rest. you can accept now one experts comment as an answer and post 2 more 33p question for the other experts with a title like : "Points for xxx" and a body "For your help with <URL>".

** Mindphaser - Community Support Moderator **
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

Suggested Solutions

Title # Comments Views Activity
How does CurrentUser work? 10 45
Assign a value in Excel V-Basic 3 38
Help with Classic ASP - Parameterizing Query 16 67
Word formfield existence 3 16
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
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.
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…

752 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