Search results for query: *

yes..go to Administrative Tools -> Data Sources (ODBC) and select the your desired configuration. my fault that I didn't mentioned it very clear about the driver. I am using Oracle8 ODBC driver and it works just fine. However, I have tried CR Oracle8 driver, it seems like you cannot keyin the...

Are you using ODBC Driver? If yes, go to edit the ODBC configuration and for the user id section, key in username/password. For example, the user id is mike and password is mike123, the valid input will be mike/mike123 Tim

I think you can omit the ‘SELECT’ and ‘FROM’ from SQL Expression if you wish to call the function. For example, calls_Assigned(1002) will do the work. Tim

kai, As I mentioned earlier, if we contruct in this way, it wouldn't get pass down to SQL database. It will return all the reconds and then only filter the selected date. pls help. Tim

AnnetteH, Perhaps, I show you what I have done as your helpful hints. 1. Create a oracle function called GET_REPORT_DATE (As you mentioned) 2. Create a report without selection criteria. 3. Create a SQL expression call Get_Date with just a call to the oracle funciton. 4. Contruct a formula...

AnnetteH, Thanks so much for your effort. However, what I want is the selection must be able to pass down to database to process before it return the result. For the mentioned solution, it works but it only get filter out when all the result return from database. Imagine, we have billion...

kai, As I mentioned earlier, I have tried it but it wouldn't get pass down to SQL. do u think I need to try out CR 9.0? We have converted some of our critical reports to Stored Procedures and I hope that we don't have to do the rest as we have written 400 hundred over reports so far and most...

Please refer to thread782-477236 and Madawc Williams has a very good explanation on how to suppress subreport. Again, it all depends on how you report design and layout. In some cases, you migth consider to use underlying feature. Tim

Annette, Unfortunately, I am using CR 8.5 and it didn't come with the SQL Command Object features. I wish I can do something in CR 8.5 without upgrading to CR 9.0. Kai, My problem is still the same. It still cannot pass down the selection to SQL to process. I noticed that CR 8.5 wouldn't pass...

AnnetteH, Finally, I learnt how to call Oracle function from SQL Expression. Thanks… However, I noticed that you cannot access the Crystal Formula or Parameter from SQL Expression Editor. Any idea how to overcome it?? I have done a simple test and created an Oracle function to return the...

AnnetteH, Your third options sound good to me. But the problem is how am I going to convert the oracle function into SQL Expression? I don't know crystal well and so far I don't see you can add the oracle function into crystal reports or SQL Expression. Pls help. Kai - Actually, out...

Hi kai, thanks for the response. In fact, I have viewed through all the relavent posting before I posted this question. sorry.. the info as below :- Crystal Version - 8.5 Database - Oracle 8i Connectivity - ODBC I have tried the method that u mentioned but it still wouldn't pass down the...

Hi experts, I have a real problem here. I have checked with our local senior crystal consultant and they were not able to help me. I have defined a friendly date parameter called (?Process Date) and allow user to select P - (current biz date) C - (current system date) or user input date...