Search results for query: *

Thank you all for your help. I ended up using the FCIV program to compute hashes and then comparing those.

Actually, the FC was working fine (i.e. it did not seem to include the timestamp difference) but then I guess the server team applied some patches and it broke the FC program. I just tried it without the "|FIND "FC:no dif">nul" command but that didnt work either. It still takes the timestamp...

Hello, I am using FC on a Windows Server 2003 machine as follows: @ECHO OFF if exist EmptyFile.xls goto :EXECUTE goto :END :EXECUTE FC ErrorFile.xls EmptyFile.xls | FIND "FC: no dif" > nul IF ERRORLEVEL 1 goto :hasdata IF ERRORLEVEL NOT 1 goto :END :END exit :hasdata echo "hello" goto...

Hello, I am using FC on a Windows Server 2003 machine as follows: @ECHO OFF if exist EmptyFile.xls goto :EXECUTE goto :END :EXECUTE FC ErrorFile.xls EmptyFile.xls | FIND "FC: no dif" > nul IF ERRORLEVEL 1 goto :hasdata IF ERRORLEVEL NOT 1 goto :END :END exit :hasdata echo "hello" goto...

Sorry about the earlier message - the number of rows actually increased this time. And the @Exp field has duplicates.

I added the left join and the number of rows did not decrease so that was great ! And then I did this - I changed the @Exp formula to Maximum ({@Explanation}, {EXPENSE_TYPE.DESCRIPTION}) and put it in the detail section. Now, there is nothing in the Explanation fields. It is blank.

Hello lbass, I created a formula called 'Explanation' as follows: If IsNull({BUSINESS_RULE_VIOLATION_VW.EXPLANATION}) then " " else {BUSINESS_RULE_VIOLATION_VW.EXPLANATION} And then I created anothe formula called 'Exp' as follows: Maximum({@Explanation}) And I put @Exp in the...

Thank you lbass. I tried both options but it didnt seem to work. Table.Field is a string field and I am using Crystal 10.0 - does this change anything?

Hello, What would the crystal equivalent of the following be: MAX(NVL(field, ' ')) I tried using isnull and field = " " and maximum but they did not work. Thanks.

Hello, We set up a Windows SharePoint Services 3.0 application to collect information about various systems that 5 departments in our company support. We created a list and had users update information. Now some of the users have attached documents too. What is the best way to download all...

Hi, We have a field in the database that is of type long and it wont show up properly on a crystal report. Our DBA wrote a custom function to convert that field. How do I use that custom function in the crystal report. We use Crystal Reports 10.0 and Oracle 9i. Thanks.

Hi, I have a very limited knowledge of Sharepoint and I have just used it once to put up a list to collect information. Are there any good resources out there on how to use Sharepoint to set up an online event registration site. I have downloaded the template but I havent gotten very far with...

Thank you for response.

Hi, There is a Crystal Reports v 10 report that uses a command. One of the parameters in this command needs to accept multiple values but I am unable to change the parameter. There are about 25 formula fields that this report uses and I was hoping that there would be some way to change the...

Sorry, I didnt realize that the data was all muddled. This is what we are supposed to get: 10050123451234500000106052008011800000007988 V 10050123451234500000108632008040900000002500 10050123451234500000108642008040900000065942...

Hi, I have this query that displays the detail records first and then the summary records: select '10' || '050' || '1234512345' || rpad(substr(a.check_number, 2, 10) || ' ', 10) || rpad(to_char(a.check_date, 'yyyymmdd') || ' ', 8)|| rpad(lpad(trunc(a.check_amt * 100, 0), 11, '0') || ' '...

Instead of using suppression, I used the record selection criteria to exclude records that I didnt want and that fixed the problem. Thank you for your responses.

Hi, I have a crystal report (version 10.0) that calculates account balance in the detail section. The report is grouped by various fields and I have put the summary of the account balance in one of the group footer section. The summary displays the right sum when I run the report. Then I used...

I added these 2 lines: BREAK ON a.check_number SKIP 1 COMPUTE COUNT LABEL count OF a.check_number ON a.check_date before the SELECT clause. The SQL ran without any errors but it did not print the label out.

Hello, I have a SELECT query(pasted below) that I use to output a file. The users now want the total number of checks and sum of checs outputted at the end of the file with labels. I thought dbms_output.put_line would work but it gives me an error. Please help ! SET FEEDBACK off SET HEADING...