Sankar030999
asked on
how to create a report in vb
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
how do i go about creating the report from scratch and how can i interface it from vb. im using vb6
Thanks
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
see this article: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q244779
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
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
ASKER
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
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
ASKER
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
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
Sankar, There is a way to split points. You need to ask for help from the moderator.
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 **
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 **
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!