Data reports

[chuckzter]

Hi guys,

Me and my friends are making an enrollment system, i kinda need help on how to use data reports. Or any suggestions/alternatives on how to show the data. Example, overall transaction. We're getting the data from our database and we're using ADODB.


Thanks.

PS.

By overall transaction, i mean like


Student number | SubjectCode | Units | Price
0923 DBMA1 3 12000


All these shown at data report. Or am i mistaken about the datareport's function?

[Ali Rizwan]

Hi,
Do you know Data Environment and how to use it?

[Ali Rizwan]

Ok
Try this sample.

[chuckzter]

I've downloaded the zip.

Thanks for the immediate reply.

I'll just post if i need to clear up some things. Thanks again. :)

[chuckzter]

OMFG! You own bro/sis! Thanks.

By any chance do you have a link on where i can find a tutorial on how to make it?

I could predict myself asking questions here again though.

[Ali Rizwan]

I've downloaded the zip.

Thanks for the immediate reply.

I'll just post if i need to clear up some things. Thanks again. :)

Be quick
I m just online for a couple of hours more.
And i m a boy
GOODLUCK to your app.
ALI

[Ali Rizwan]

OMFG! You own bro/sis! Thanks.

By any chance do you have a link on where i can find a tutorial on how to make it?

I could predict myself asking questions here again though.

sorry i have ot any link for such thing.
But i m here for your help.
And i ll search for you.
GOODLUCK
ALI

[chuckzter]

I know this would be hard and i might be asking too much but i really need the info, can you teach me step by step what you did? How you did the whole thing. Syntax etc.

The only thing i noticed was the labels, you created a table with 4 "things". Student number, subject code, unit and price. I can't seem to find the way on how to do this. But i am trying.

[Ali Rizwan]

OK
Now do these steps.
=============== ===========

** First create a database with msaccess named DBASE and save the table as name TBL
** Start New Project with VB6
** Add DataEnvironment by right clicking on Project Explorer goto Add -- More ActiveX Designers -- Select Data Environment
Now a window will be open where you see a tree view as
- DataEnvironment 1
|-- Connection1

=============== ===============

Second

=============== =============== =

** Now set Connectin Source property of Connection1 to Provider=Micros oft.Jet.OLEDB.4 .0;Data Source=C:\DBASE .mdb;Persist Security Info=False (You can change the path C:\DBASE.mdb)
** Add a Commandby right clicking on Connection1 -- Add Command
** Set CommandType property to 1-adcmdTable
** Set CommandText property to the name of your database table (TBL)
** Now click on Command1 you will see all the Fields in you database in a tree view.

=============== =============== ==

Third

=============== =============== ==

** Add a Data Report
** Set Data Source property of Data Report to Data Environment1
** Set Data Member property of Data Report to Command1

=============== =============== ==

Fourth

=============== =============== ==

You ll see a bunch of Sections on Data Report
** Now add RptLabel remember RptLabel not RptTextBox in Report header (Second Tab)
** Now add RptTextBox in Detail Section or in 3rd Tab
** Set DataMember property of RptTextBoxes to your associated fields (selected with the help of a combo box)

=============== =============== ==

Add a button Form1
write this code in click event

DataReport1.Show

=============== =============== =

Your report is made succssefully.
Reply if works or not

GOODLUCK
ALI

[Ali Rizwan]

I know this would be hard and i might be asking too much but i really need the info, can you teach me step by step what you did? How you did the whole thing. Syntax etc.

The only thing i noticed was the labels, you created a table with 4 "things". Student number, subject code, unit and price. I can't seem to find the way on how to do this. But i am trying.

Hello,
Any More Question?

[chuckzter]

Thanks Ali,

Unfortunately, i haven't done what you told me completely. Me and my friends will work on it tomorrow. We have schedule issues. I'll post updates soon okay? :) Again, thanks for your quick response.

[chuckzter]

We've got it! :) Data report function on our system is okay now.

We have another problem though. (Posted another thread.)

[Roderick]

I Can't follow, I can not find the data environment in vb. In creating new project are you using standard exe or data project?

[jaz215]

I Can't follow, I can not find the data environment in vb. In creating new project are you using standard exe or data project?

if you can't find the data report, its probably not yet added in the tabs. what you need to do is right-click on your toolbox and click components. and on the designer tab check the field on data environment and data reports

** you can use a standard exe for this