Search results for query: *

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, 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 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 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, 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, 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...

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...