data report?

[trex]

hi guys. I haven't tried doing reports in vb6 yet. And i need to print data retrieved in the database. i was told that what I should do is to use/creeate data reports. But the thing is, I'm not familiar with data reports. Could you please help me? Any kind of help will do. Thanks in advance guys.

[Hack]

I would start here. (http://www.google.com/search?hl=en&q=%22data+report%22+vb6)

[trex]

thanks Hack. I tried doing the search in google but the results that came out are a little more advance and i can't understand them very well. Coudl anyone please help me in creating a data report? And how do I create one? Is a crystal report better? PLease help. Thanks.

[trex]

I would just like to create a report. The contents of which are retrieved from the database in various tables (inner join). And then print the report..

[kulitag]

are you using access as database? you can upload your sample database then will work around on it

[trex]

Yup im using access as a databse. here's my sample database. thanks.

[kulitag]

here try this, i create a grouping for extra reference

[trex]

thank you so much kulitag. I was just wondering how do i print specific records from the database and put it in the data report (for example from a recordset)? Is this possible?

[kulitag]

yeah fill up your database with records, for some example then send me again the file that i've sent you but of course with updated database

[trex]

hi kulitag. here's the updated database. the number of records that i need to print is the number of records in the table m_timesheets. but some of the information still depends in the other tables. thank you so much for your help.

[kulitag]

here! advise *one thing if you have a test data it must be 25 and above. just fix the design.
God Bless!

[trex]

oh ok. sorry about the test data. thank you so much kulitag

[philippecmartin]

Hi,

This post is very important to me as phdb.zip answers a question I have been struggling with: how to get grouping to work and pass parameters to the SQL.


Many thanks.

Where is that documented ?

Regards,

Philippe