Search results for query: *

Actually I did. We have Goldmine Sales & Marketing with GoldSync Ver 6.0 We use an ODBC connection to a SQL Server for the intranet users and Dbase file structure for Remote users. How this all sync's and ties in is out of my league and I leave it to the GM Admin to handle that. Anyway, I...

Here is another way to tackle 'All' and it also processes it much faster. ({USERINFO.DIVISION} = ( if {?Division} <> "All" then {?Division}) OR {USERINFO.DIVISION} > ( if {?Division} = "All" then "" else 'zzzzzzz'))

Thanks everyone for your inputs. My hurdle is trying to get the second part of the UNION to use the params. Crystal Reports will automatically stick in the WHERE clause with the RECORD SELECTION criteria, but I am trying to get Crystal Reports to generate a similar WHERE clause in the second...

How can I create a UNION between 2 tables AND use the Parameters in the Where clause. I cannot use VIEWS, Crystal Queries, Temp Tables or Stored Procedures as this report is run within GoldMine and GM will only accept straight SQL. Here is what I want to accomplish; Select A.id, A.Name...

How can I create a UNION between 2 tables AND use the Parameters in the Where clause. I cannot use VIEWS, Crystal Queries, Temp Tables or Stored Procedures as this report is run within GoldMine and GM will only accept straight SQL. Here is what I want to accomplish; Select A.id, A.Name...

Dave, Thank you for your insight. Sometime during mid April, I came across user.dbf. It contained a field called USECURITY, which I assumed I could use to find all this user's records or groups, but being that its encrypted, I cannot be sure. Anyway, I thought I could use this field and do a...

I am trying to limit Crystal Report to print only those contact information for which the user has access to. Each Contact has a Security code in the Key5 field of the Contact1 table. Here are some issues; I don't know how to check which user initiated the report. I don't know where GM stores...