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.