Making Reports in 6.5

[mpiontek]

I would like to make a report that would list all the counties in our database, but not list one county more than once. Is this possible? I am not familiar with making reports yet, a push in the right direction would be helpful.
Thanks.

 

[M8KWR]

to my knowledge you could not do this through goldmine reports.

I would use access to do this, but you could use Crystal, and do it through some sql coding.

Hope that helps, if you do need any further assistance please say.

 

[goner]

what fields are you storing the county in? There's a COUNTRY field on the main screen, but not a county one.

The simples way to do it would be to use a quick SQL query like this one for states:

select distinct(state), count(state) from contact1 group by state

This will give you a count of each state you have records for...



Doug Castell
Computer Control Corp
(310)396-6811

http://www.ccc24k.com

 

[mpiontek]

Thanks guys. I appologize for not posting, I found the public.goldmine6.general support news forum and have received a lot of help through there. We changed out Country field to County since we only do biz in Wisconsin.

Thanks for your reply!!

-Mark

 

[goner]

well then, this query shoudl do the trick for you:

Go to Lookup|SQL Queries and enter:

select distinct(country), count(country) from contact1 group by country


Then, once the results return, you can right-click inthe results area and select Output to->Excel and play with / print the results in Excel, if necessary.


Doug Castell
Computer Control Corp
(310)396-6811

http://www.ccc24k.com