Aaron23

I'm trying to add a summary or sub-summary (not sure which is appropriate) to a report. I want the sub summary to show a count of different items selected in a drop down list box. What I've tried to do is create a summary field of the drop down list which is a "count of" the field I want to summarize. Then place that summary field in the sub summary layout part. But when I view the report it's just giving me a count of all records in the found set instead of showing me the breakdown. For example the field I want to summarize has 5 statuses "sold", "lost", "bidding" and so on ... On the report I want to see: Sold: ## Records Lost: ## Records Bidding: ## Records and so on But I'm just seeing ## Records. Any help is very appreciated.

That did indeed solve my problem. Thank you so much for your help.

Sorry, I'm cross posting this from the portals forum because I just realized this is probably the correct category : Hi, I'm new to the board so hopefully I'm following any established protocol but I have a problem that's stumping me and I'm hoping someone can offer some insight. My company runs a web portal so that sales reps around the country can search for data we've assigned to their user name through our website. When defining the users account priveledges I have set everything up correctly except for 1 fact. Within the record priveledge set, if I set 1 of the tables to limit instead of all, the users will still be able to access their information in the database, but when they try to perform a search they get the error: No Records Found: No records were found in the database "leads" for the find you specified. This happens when searching any field within the database. If I then set the priveledge to "all" the sales reps can perform the search, however they also have access to all the other reps information as well. The limit I'm placing on the priveldge is Sales Rep (one of the field names) = Get (UserName) Which is correctly limiting a reps ability to look at only leads assigned to his user name, but incorrectly limiting his ability to search for records that match his user name. I hope this is clear. I've never used Filemaker before this and consequently don't know what information my or may not be pertinent. Thanks for any help you can offer.