Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Union with Parameters
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...- kit2002
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
using UNION with Parameters
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...- kit2002
- Thread
- Replies: 0
- Forum: FrontRange Solutions: GoldMine
-
Where does Goldmine store users and user groups
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...- kit2002
- Thread
- Replies: 4
- Forum: FrontRange Solutions: GoldMine
