next »

[TechnicalTalk]

 TechnicalTalk » Programming and Web Development » Visual Basic 6.0
 Generating a report via a query

[ipodman]

ipodman  

 Generating a report via a query

Hey Guys,

We;; this is my first post and I did have a look in the forums but could not see an answer to my question, first of all I am rather new to VB and am currently understanding a college project with Vb and like the application and what you can do with it, I am using VB6.

Right well, I am looking to allow for a user when they click a button for a report to be displayed. Is there a way to create the report via a query using VB and access? how I mean is that you already have the report created in Access but then you have a command that runs it in VB.

Sorry if its such a newbie question.

Thanks,

Dan

[Neoadam]

Neoadam  

 Re: Generating a report via a query

I *think* this is it. That's how I'd code the macros within Access.

Code:

OpenReport(ReportName)

[hitmark]

hitmark  

 Re: Generating a report via a query

using Crystal Report is very good and easy. so

http://www.vb6.us/tutorials/using-crystal-reports-vb6-tutorial

it is good article to start with

[Admin]

Admin  

 Re: Generating a report via a query

Crystal reports are easy way to develop reports using VB 6.0

[isidoriu]

isidoriu  

 Re: Generating a report via a query

You can check about crystal reports in microsoft's website. . .
hxxp: msdn. microsoft. com/en-us/library/ms227881%28v=vs. 80%29. aspx

also check this useful tutorial with screenshots here. . .
hxxp: www. c-sharpcorner. com/uploadfile/mahesh/crystalreportsintroduction11082005014959am/crystalreportsintroduction. aspx

good luck to your code

[johnpitter]

johnpitter  

 Re: Generating a report via a query

If you want to create a report via query than crystal report is a best way for you. Crystal report is a third party tool for reporting. It's freely available on the Internet  and also easy to use.

[the_purple_ink]

the_purple_ink  

 Re: Generating a report via a query

that is very nice info..