•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 456,512 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,694 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 1064 | Replies: 3
 |
•
•
Join Date: Jun 2007
Posts: 29
Reputation: 
Rep Power: 2
Solved Threads: 0
Light Poster
Let, i have a msà ccess db with 3 tables having 'cost' field in all of them . Now in my report i want to
1) Show the sum of costs of indivisual table under the heading of each table (let $3000 for every table) &
2) show the sum of all the sum value of individual tables (here it would be $9000) at the bottom of the page under 'total' heading. How can i do it? Plz help me.
1) Show the sum of costs of indivisual table under the heading of each table (let $3000 for every table) &
2) show the sum of all the sum value of individual tables (here it would be $9000) at the bottom of the page under 'total' heading. How can i do it? Plz help me.
•
•
Join Date: Aug 2007
Location: Cavite,Philippines
Posts: 508
Reputation:
Rep Power: 3
Solved Threads: 68
Posting Pro
Use LEFT JOIN command in your SQL Query to combine all the 3 tables.
"death is the cure of all diseases..."
http://ryantetek.wordpress.com
http://ryantetek.wordpress.com
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,444
Reputation:
Rep Power: 4
Solved Threads: 87
Use suitable joins to retrive data from multiple tables.
Share your Knowledge.
|
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Crystal Report & Code based Dataset (VB.NET)
- Datas from different tables in one crystal report.. (Visual Basic 4 / 5 / 6)
- How to pass querystring to crystal report (Visual Basic 4 / 5 / 6)
- Issue about passing parameter to Crystal Report 11.. (Visual Basic 4 / 5 / 6)
- how to add database fields dynamically to a crystal report in .net 2003 (C#)
- crystal report related.........simple one......Please take 2 min to read this... (VB.NET)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: CommandList
- Next Thread: Exporting Crystal Report
