How to report ?

[AvisSoft]

Hello!

I have a very basic question...maybe asked several times but i am unable to find satisfying answers:

First :: how to create a very basic report ?

for example:

i have a database in ms access
i have a table named Profile
i have fields in table: Name, Age, Sex

i want to generate a report using the following sql query:

strsql = "SELECT * FROM Profile WHERE Name = 'Bam'"

now the results should be displayed using the report so the user can print etc. how can i do that ?

If someone helps or tells this how to achieve the above step by step then it will help a lot of users. Cause when we get Crystal Reports we really don't understand how to do what ?

So a helpful tutorial or step by step guide will be really helpful and appericiated. I request admin of the forum to please look into the matter and try to help.

Thanks!

[Oscar Ashkroft]

im not a big thing on vb, but i think the answer could be that
you must use datamanager in your ´toject
then add a command, and turn it to an sql command.
then add a datareport to your project
and in the detail section you must drag the command in it.
hope this can be a little help for you
bye.

[AvisSoft]

Hi!

Thanks for your kind reply. But i am sorry to say that i don't want to use Datareports. I want to use Crystal Reports.

Anyone who can answer my question ?

Thanks!