Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pnad
  • Order by date
  1. pnad

    Using FC (File Compare)

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

    Using FC (File Compare)

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

    Using FC (File Compare)

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

    Using FC (File Compare)

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

    Crystal Equivalent of MAX and NVL

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

    Crystal Equivalent of MAX and NVL

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

    Crystal Equivalent of MAX and NVL

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

    Crystal Equivalent of MAX and NVL

    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?
  9. pnad

    Crystal Equivalent of MAX and NVL

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

    Dowloading attachments

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

    Custom Oracle Function

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

    Event Planning using Sharepoint 2003

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

    Multiple Values for an input parameter

    Thank you for response.
  14. pnad

    Multiple Values for an input parameter

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

    Not able to select distinct record

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

    Not able to select distinct record

    ...'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') || ' ', 11)|| rpad(' ',15) || decode(a.check_recon_status, 'V', 'V',' ')|| rpad(' ',80) as col1 from table a, table b where...
  17. pnad

    Summary when suppressing records in detail

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

    Summary when suppressing records in detail

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

    Output to a file using a SELECT query

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

    Output to a file using a SELECT query

    ...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') || ' ', 11)|| rpad(' ',15) || decode(a.check_recon_status, 'V', 'V',' ')|| rpad(' ',80) as col1 from table...

Part and Inventory Search

Back
Top