Connecting Tech Pros Worldwide Forums | Help | Site Map

Data reports

Member
 
Join Date: Oct 2007
Posts: 50
#1: Oct 2 '07
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's Avatar
Banned
 
Join Date: Aug 2007
Location: Lahore Pakistan
Posts: 929
#2: Oct 2 '07

re: Data reports


Hi,
Do you know Data Environment and how to use it?
Ali Rizwan's Avatar
Banned
 
Join Date: Aug 2007
Location: Lahore Pakistan
Posts: 929
#3: Oct 2 '07

re: Data reports


Ok
Try this sample.
Attached Files
File Type: zip DB.zip (41.5 KB, 51 views)
Member
 
Join Date: Oct 2007
Posts: 50
#4: Oct 2 '07

re: Data reports


I've downloaded the zip.

Thanks for the immediate reply.

I'll just post if i need to clear up some things. Thanks again. :)
Member
 
Join Date: Oct 2007
Posts: 50
#5: Oct 2 '07

re: Data reports


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's Avatar
Banned
 
Join Date: Aug 2007
Location: Lahore Pakistan
Posts: 929
#6: Oct 2 '07

re: Data reports


Quote:

Originally Posted by 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. :)

Be quick
I m just online for a couple of hours more.
And i m a boy
GOODLUCK to your app.
ALI
Ali Rizwan's Avatar
Banned
 
Join Date: Aug 2007
Location: Lahore Pakistan
Posts: 929
#7: Oct 2 '07

re: Data reports


Quote:

Originally Posted by 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.

sorry i have ot any link for such thing.
But i m here for your help.
And i ll search for you.
GOODLUCK
ALI
Member
 
Join Date: Oct 2007
Posts: 50
#8: Oct 2 '07

re: Data reports


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's Avatar
Banned
 
Join Date: Aug 2007
Location: Lahore Pakistan
Posts: 929
#9: Oct 2 '07

re: Data reports


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
- DataEnvironment1
|-- Connection1

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

Second

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

** Now set Connectin Source property of Connection1 to Provider=Microsoft.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
Expand|Select|Wrap|Line Numbers
  1. DataReport1.Show
  2.  
===============================

Your report is made succssefully.
Reply if works or not

GOODLUCK
ALI
Ali Rizwan's Avatar
Banned
 
Join Date: Aug 2007
Location: Lahore Pakistan
Posts: 929
#10: Oct 3 '07

re: Data reports


Quote:

Originally Posted by 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.

Hello,
Any More Question?
Member
 
Join Date: Oct 2007
Posts: 50
#11: Oct 3 '07

re: Data reports


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.
Member
 
Join Date: Oct 2007
Posts: 50
#12: Oct 6 '07

re: Data reports


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

We have another problem though. (Posted another thread.)
Roderick's Avatar
Newbie
 
Join Date: Dec 2007
Posts: 4
#13: Dec 6 '07

re: Data reports


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?
Member
 
Join Date: Nov 2007
Posts: 55
#14: Dec 6 '07

re: Data reports


Quote:

Originally Posted by 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?


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
Reply


Similar Visual Basic 4 / 5 / 6 bytes