Recent content by jimmarkham

Jeff The correlated subquery is evaluated row by row (well... maybe not in some cases but the effect is the same). But the condition is not an '=' its a '<'. The subquery returns a number (the number of sales values greater than the one we are currently considering) and that number is...

We did this on an Oracle training course 10 years ago. The solution went like this: Assume that you have a table T1 with a column SALES and you want the top five sales (without using an order by). In Oracle you can do it this way: select SALES from T1 a where 5 > ( select...

I had this problem with Access 97. I assume that you can use the linked tables in the linked Access database when you are using Access itself. If not then you have a different problem What worked for me was to create an Access query in the 'linked' database that read the linked table...

I got this error once, using an Oracle database, with Crystal 8 and a 3rd party app. I'll try to explain what it was. Our third party product uses Crystal for reporting but not all the Crystal DLLs are distributed with that 3rd party app. In particular the one that handles advanced SQL...

Thanks Synapse. The conditional suppression is an interesting idea. I don't have it in the report but that is exactly how the report is behaving. If I ever find out what I've done wrong here I'll let you know! Jim

Thanks Synapse Unfortunately I can't use the CR ODBC driver. The users have a packaged system that incorporates Crystal as its reporting mechanism. I can add reports to the system but they will be run through the software config delivered by the package suppliers. I'll take a look at the...

Has anyone any ideas what might be happening here please. Crystal Reports 8.0 Oracle 8.0 database. Oracle ODBC driver I have a report with one level of grouping and a subreport in the group footer. The group header and detail lines are suppressed. What the user sees is a few details from the...

This may not be practical, but its the only thing I can think of. Lets say you have three csv files called csv1,csv2,csv3 You could: 1. Create an Access database 2. Link the csv files to the access database - you now have three tables called csv1, csv2 and csv3 3. Create a query that unions...

You could try this (in sql*plus or somewhere) and if it works then perhaps it could be incorporated into your CR. Change this part of the sql (&quot;COMMUNICATION&quot;.&quot;CREATED&quot;>=TO_DATE ('01-11-2002 00:00:00', 'DD-MM-YYYY HH24:MI:SS') AND...

Try this create a string containing the date in dd/mm/yyyy hh:nn:ss format with single quotes around it eg dim ddd as string ddd=&quot;'21/03/2003 12:00:00'&quot; then do Set boCond = bodp.Queries.Item(1).Conditions.Add(&quot;Rep Trades&quot;, &quot;Execution Date&quot;, &quot;Greater...

Thanks synapsevampire. You are correct. Changing the ODBC driver has fixed the problem. Cheers Jim

Crystal 8.5 Oracle 7.3.4 database ODBC connection on Windows 95 Does anyone know whats happening here please. I create a report in Crystal with a parameter that is type date or datetime. The parameter is to be used in the selection criteria and so gets passed into the query syntax. When I...

I have done similar things (also for daily bed occupancy in a hospital) as follows: Create an extra table (lets call it Dates) with one field (lets call it caldate) that is simply a list of dates. Populate it with dates that will cover everything you are looking for historically and into the...

Assuming you are getting records from a database then selecting them should be possible. To select all records where the leave overlaps the period startdate to enddate the conditions are lve_startd < enddate and lve_endd > startdate (i.e. the leave must start before the end of the period in...

Thanks for your reply synapsevampire. I'm already using a view for the subreport. The Oracle procedure would be a last resort as its a poor way to do it (in my opinion anyway) I have (almost) found a solution in Crystal. If I create a formula like this...