Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB.NET
| Search | Today's Posts | Mark Forums Read
VB.NET General VB.NET discussions for issues that don't fall into other VB.NET forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 4th, 2005, 08:45 AM
Registered User
 
Join Date: Jan 2005
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Running Total field being multiplied together HELP

I have 6 tables in my oracle database. In my crystal report I am showing my community details from one table. But I want to do a count of how many records there are in the other tables that involve that community. K that is a little confusing Let me try it this way. For example

I have 6 tables tblCommunity, tblcommunitySections, tblresturants, tblbars, tblstores, tblhotels

And with my report I have the details from the Community table, then brokedn down by sections of that community and in that part I want to show a count of how many resturants there are in that communitysection and then a count of bars for that communitysection and beaches etc. I don't want to show all the records but just the count of each record from each table that is in that communitysection.

So I am using a crystal report grouped first by community then grouped by communitysection, and in that community section I am using running totals to see how many restaurants are in that community section then bars etc. When I put the first runningtotals field on the group footer it works perfectly it shows the number 2. But when I add another running total it comes back with wrong numbers for both the running totals multiply together then both show that number. where it should have showed the numbers 2 and 15 it shows 30 in both....

Why is this happening I have been trying to figure this out for more than a week. Please help.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate a running total Neal XSLT 3 March 22nd, 2007 11:16 AM
Adding values to Running Total hafizfarooq Crystal Reports 0 September 12th, 2006 07:53 AM
Running Total jdmorr SQL Language 5 March 9th, 2005 03:28 PM
Running Total Fields edramail Crystal Reports 0 May 17th, 2004 09:22 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.