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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. WAndrewW

    How to pass group key value to a SQL statement

    I am not sure what you are trying to do. If I want to add a where clause to the Query I generally add a parameter of the appropriate datatype in you case probably string or date. Then when prompted for the parameter value I put in the condition I want met. So I am assuming that the ultimate...
  2. WAndrewW

    Custom SQL and Crystal widgets

    I guess I did not explain clearly. The main point of question one is connecting to two databases on different physical machines and doing a distributed join. Question 2 may be clarified by the sql. This is part of the SQL SELECT t.CUSIPNr AS Cusip, t.PoolNr AS ContraAccount, t.TranDt AS...
  3. WAndrewW

    Multiple Reports in Actuate

    I have never used Siebel, but Actuate will allow two groups of data to be incorporated into the same report. Check in the Samples directory (Assuming you installed on the C drive C:\Actuate5\eRDPro\EXAMPLES. Each sub directory has a readme file describing what the report shows. If the two...
  4. WAndrewW

    Crystal vs Actuate

    I have used Actuate with Stored procedures on DB2 - AS400. Generally my knowledge is more advanced with Actuate. Actuate seems to offer more control to the programmer than does crystal especially in the area of customizing SQL.
  5. WAndrewW

    Custom SQL and Crystal widgets

    Hi, I am re-visiting Crystal Reports after prolonged absence. Here are my problems. 1. I need to connect to two databases. The first database returns a result set used in Modifying the Where part of an SQL statement (second database) for each row returned from the first database. The databases...

Part and Inventory Search

Back
Top