Connecting Tech Pros Worldwide Forums | Help | Site Map

Data report in VB6

Newbie
 
Join Date: Aug 2009
Posts: 4
#1: Aug 22 '09
Hi,

I have a form with 4 textboxes whose numeric values are retrieved frm MS Access database.
When i click on command button 'calculate' it adds up the data in the 4 textboxes
and displays it in another textbox 'total'
The problem arises when generating data report for this form. In the report im able to get the 4 textbox values but not the grand total.
How do i include grand total too in the data report ???

Pls help!!

debasisdas's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,511
#2: Aug 22 '09

re: Data report in VB6


you need to add a formula field.
Newbie
 
Join Date: Aug 2009
Posts: 4
#3: Aug 24 '09

re: Data report in VB6


Hi,

Do i need to use crystal report for this?
debasisdas's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,511
#4: Aug 24 '09

re: Data report in VB6


you can if you want to, but that can be done using data report itself.
Newbie
 
Join Date: Aug 2009
Posts: 4
#5: Aug 25 '09

re: Data report in VB6


Could u plz tell me how do i display the grand total of all the textboxes using data report? Im using MS Access for the database ....
smartchap's Avatar
Familiar Sight
 
Join Date: Dec 2007
Location: Lucknow, India
Posts: 194
#6: Aug 25 '09

re: Data report in VB6


U can go to following link & have help:

http://msdn.microsoft.com/en-us/libr...00(VS.60).aspx

Also go to previous page in the above link page to have more info.
Newbie
 
Join Date: Aug 2009
Posts: 4
#7: Aug 27 '09

re: Data report in VB6


Thanks a lot for your help :)
smartchap's Avatar
Familiar Sight
 
Join Date: Dec 2007
Location: Lucknow, India
Posts: 194
#8: Aug 28 '09

re: Data report in VB6


Pleasure in helping u.
Reply