N/APosted on - 04/05/2012
I want to calculate the total of my overall sales in my datareport using visual basic 6.0 but I don't know how to code that.
This is an example of the display that appears in my datareport.
customer name product name quantity price total
John Doe soap 5 5.00USD 20.00USD
Allen Smith shampoo 2 7.00USD 14.00USD
Total Sales: ??????
How can I code the total sale in datareport using vb6.0?
Count the total of my overall sales in data report
You can add another table in your database that tracks the total sales. This table could have only one column in it due to the fact the there is only one row for the total sales in your datareport. Next thing you'll do it so attached it in the footer section as the datasource of your datareport.
This is the only way that I can think of due to the fact that we can't put computed values on the datareport unless it's coming from the database.
I can imagine that the table I suggested to you can only have one row of data and will just change over time as you create your reports.
I hope it helps.