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...
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...
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.