Search results for query: *

Thanks 'J Works like a charm of course. Regards Warren

Hi all, This is a simple one for the seasoned professionals, I just cannot find the answer in any of the threads.Apologies if it has already been covered. My report is a file system data report to extract number of log files within a directory. The file name is created by imports from servers...

Hi Ken, Well, I've had my 5 minutes of stupidity. Indeed, You are correct, I was "revisiting" the previous parameters all the time. Much obliged. Regards Warren I'd rather be stupid for 5 minutes than for the rest of my life.

Hi Ken, Thanks for the response. CR Version 8 Data type is date time which I have selected to convert to date. In the parameter the Data Type is selected as date. I have tried 2 different selection formulas 1.) {PLY_POLICY.PLY_EFFDATE} in [{?First Date Range}, {?Second Date Range}, {?Third...

Hi, Can anyone provide some insight please. I rewrote my report, kept it basic, put in the 3 date parameters but still no luck. I'm guessing I have inadvertently changed some setting in my options. If so, no idea which settings I might have changed? Regards Warren I'd rather be stupid for 5...

Hi, I have a report that has amongst others, 3 date parameter ranges. These worked fine, but subsequent to additional work on the report, the parameters selected don't hold the values selected. To elaborate, originally, when I selected a range Jan to Mar in Date param 1 and April to June in...

Hi synapsevampire, Thanks for your response. "What does override mean here?" Indeed, not phrased accurately. What I mean is, I wish to have ({PLY_POLICY.PLY_INVOICEDATE} in {?From Date} to {?To Date})as the main selection dates, and within this date range, I need to have the ability...

Naith, Lisa, Writing crystal reports is an add-on to my actual job, and I am not a tecchie by any means (no kidding?). Your recommendations have now veered me down the river of mysterious waters and I have missed my deadline by 2 days to date. Hence I'll have to outsource this report. Thanks...

Hi All, I know this answer is in this forum, but after reading multiple entries, I am non the wiser, due to lack of understanding of the exact formula set I would require. My report (already up in Crystal Reports 4 Other Topics FAQ149-363008 which Naith is kindly providing input on.) requires...

Hi Naith, Thanks for the expeditious and lengthy reply, it really is handy when the experts try and lay on as much information for the novices like myself. I obviously misinterpreted what I was reading when researching sub-reports, hence the erroneous conclusion. So now I need to get a...

Hi All, I need to design a report that has me stumped. I'll try and provide the specs in full: The End Result A B C D E F G H I J K L M N O Group Client Client ACC Premium Levy Comm Code No...

Hi Billgates, Thanks for the feedback, I'll pass this on to my client.My sentiments are same, I believe it is indeed a profiles issue, although I believ the login script does run. Regards Warren I'd rather be stupid for 5 minutes than for the rest of my life.

Hi, I support a fat client application, which my client is running through citrix. I'm trying to establish whether citrix can be the cause of the following situation. Unfortunately, I'm not au fait with citrix, so please bear with me. According to my client they have 2 ways of accessing the...

Hi Jim, Thanks for your prompt & concise response. Unfortunately, I'm still presented with all the names. To confirm your instructions: I inserted a group on the field name (single field, is abbreviated name of business). Field already existed in report in details section. Placed your formula...

Hi, I'm trying to write a report to identify all client names that have a special character such as and ampersand or underscore etc.Unfortunately, I have no programming knowledge, hence I don't know how to write a formula to use as a filter (which I am assuming is the route to go). Any...

Thanks karluk, obvious to you, not to me. I appreciate you taking the time to post a reply. Regards, I'd rather be stupid for 5 minutes than for the rest of my life.

Hi everyone I'm brand new to SQL, trying to learn this fascinating language. I am required to run this script via SQL plus to Oracle 7.3 DB.I did not write it, but it is not producing desired results. So I want to correct it. The following does not change the 2 usr_inhibited MALANCO01 &amp...

Hi All, In what instances does suppress if duplicated not produce desired results. In previous reports, this baby as worked more than adequately for me before, but not in my current report. My report has 2 groups, client (group1) and invoice. I have been forced to total each invoice, and each...

Hi all, I have a spot of bother in trying to eradicate muliple records. I'm using 3 tables, table 1 linking one to one to table 2, and table 2 linking one to many to table 3. Needless to say, when I use a field from table 1, I get multiple entries against data when using fields off table 3...